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

The four pillars of SQL Server 2008's enhancements are mission-critical platform, dynamic development, beyond relational data and pervasive business insight. The second and third of these pillars are ...

“Free” is a term rarely associated with Microsoft offerings, especially at the server end of the spectrum. Exchange Server, SQL Server, SharePoint, Hyper-V — IT admins know functionality comes at a ...

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...

In today's digital economy, safeguarding sensitive data, particularly credit card information, is critical to maintaining consumer trust and adhering to regulatory standards. The Payment Card Industry ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Remote Server Administration Tools (RSAT) are meant for the system and IT administrators. They allow admins to set and manage roles as well as the features that are installed on a Windows Server ...