README SSIS_Analyzer MS SQL SSIS database tools for packages, jobs, and more. Old SSIS Viewer This is basically the SSIS Viewer with a really crappy UI. This is my first VB.Net application, and this ...

Connect to a SQL Server instance on an Azure VM using SSMS. Create and query SQL Server on an Azure VM by running basic T-SQL queries in SSMS. The following steps show how to create an optional DNS ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

While SSMS must be version 2016 or 2017, the SQL Server engine that produced the dump can be SQL Server 2008 or newer. When invoked, the SQL Server Diagnostics pop-up dialog asks for you to provide ...

SSMS 2008 also has a useful wizard to help us decide on the level of compression we can choose. SQL Server 2008 supports two levels of data compression – row and page level.

But Microsoft has rectified this missing feature with SSMS 2008 so we don’t have to switch to Visual Studio in order to debug our Transact-SQL code.

By using the Microsoft.SqlServer.Management.IntegrationServices.dll library, we can use PowerShell to automate the creation of an SSIS catalog along with folders inside. Before we get started writing ...