SQL Server Management Studio (SSMS) is a Microsoft application that provides integrated management and administration of SQL Server. Nevertheless, SQL Server Express provides a user-friendly interface ...

The information logged from SSMS doesn't always provide enough detail for troubleshooting, and verbose logging can be enabled to capture more details. Determine the location of the SSMS executable ...

To import environment settings from another installation of SSMS, select Tools > Import and Export Settings.... In the welcome dialog, select Import selected environment settings, then select Next>.

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.

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 ...