SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals. Here ...

In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS), introducing some key features such as support for materialized view scripts in SQL Data Warehouse. It also ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

I'm down on SQL Server Management Studio right now. I basically just spent a day trying to swap out the evaluation version of SQL Server 2008 R2 with the Express version, and SSMS just wouldn't ...

Microsoft has offered the download of SQL Server 2008 with advanced services for FREE, but only suitable for learning and building desktop and small server applications, and for redistribution by ISVs ...

Microsoft this week announced SQL Advanced Threat Protection (ATP), which is described as "a new security package" for Azure SQL Database users. Microsoft charges for using SQL ATP, although there's a ...