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.

Redmond Review SQL Server Data Tools: a Model Toolset Using SSDT means we don't just shout orders at the database; instead, we plan what we're going to say. By Andrew J. Brust 12/01/2011 For almost 13 ...

Microsoft recently updated its All-In-One Script Framework, which features SQL Server (and other) scripts designed to address common problems reported by users in forums, support incidents and online ...

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.

You can treat SQL Server on Linux as a new deployment option, not a whole new database. That means you can choose the operating system that best fits your project.

An open source project gives DBAs the ability to channel PowerShell for automating and scaling complex SQL Server tasks, starting with the most basic: database backups.

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...

The awk command is incredibly useful, and you will be surprised at just how powerful and transformative it will make your scripts. Here's how to get started using it.

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.