Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Archive for June, 2016

SSIS Catalog Execution with T-SQL

Posted by Simon Cho on 06/10/2016

I create one SP to execute SSIS Catalog using T-SQL.

It sometimes helps to execute SSIS package dynamically.

Full script download link.


exec [dbo].[USP_EXEC_SSIS_Catalog]
@folder_name NVARCHAR(128)
, @project_name NVARCHAR(128)
, @package_name NVARCHAR(260)
, @Multi_CustomValue VARCHAR(MAX)= NULL –“<ParamName>|#|<ParamValue>|##|<ParamName>|#|<ParamValue>… Ex. “SyncBack_Period_DD|#|-14|##|BackupFolder|#|X:\Test”
, @reference_id BIGINT = NULL
, @use32bitruntime BIT = 0
, @execution_id BIGINT = NULL OUTPUT

Posted in Common | Tagged: , , , , | Leave a Comment »

I’m going to Speak at South Florida, 6/18 – Update Download link

Posted by Simon Cho on 06/10/2016

Please register it on SQL Saturday page

  1. Build ETL efficiently (10x) with Minimal Logging : Presentation
  2. Myths and Truths about SQL Server Transaction : Presentation, Demo

@sqlsatSoFla #sqlsat524 #sqlsaturday

Posted in Common | Tagged: , , | Leave a Comment »

SQL Server 2016 installation

Posted by Simon Cho on 06/03/2016

SQL Server 2016 is released at 6/1.


SQL Server 2014/2016 Developer edition are free after joining  Visual Studio Dev Essentials.


Before install Please read release note. They ask VC runtime update before installation.


Install Patch Requirement (GA)

Issue and customer impact: Microsoft has identified a problem that affects the Microsoft VC++ 2013 Runtime binaries that are installed as a prerequisite by SQL Server 2016. An update is available to fix this problem. If this update to the VC runtime binaries is not installed, SQL Server 2016 may experience stability issues in certain scenarios. Before you install SQL Server 2016, check to see if the server needs the patch described in KB 3138367 – Update for Visual C++ 2013 and Visual C++ Redistributable Package.

KB 3138367 is required if the build version of msvcr120.dll is not 12.0.40649.5 or higher. To check the file build version:

  1. Open Windows Explorer.
  2. Navigate to %SystemRoot%\system32\msvcr120.dll.
  3. Right-click the file and then click Properties.
  4. Click the Details tab.
  5. Verify the file version is 12.0.40649.5 or higher.

If the build version of msvcr120.dll is not 12.0.40649.5 or higher you need to install KB 3138367.

Resolution: To install this required update, download and run the appropriate vcredist_*.exe based on your system language and architecture from KB 3138367.

If you have SQL Server 2016 installed on a computer that needs KB 3138367, do the following steps in order:

  1. Download the appropriate vcredist_*exe.
  2. Stop the SQL Server service for all instances of the database engine.
  3. Install KB 3138367.
  4. Reboot the computer.


Posted in Common | Tagged: , , | Leave a Comment »