SQL Server sample databases were always delivered with the product. Not so in SQL Server 2008. Microsoft decided to de-couple the dependency and have us download the samples for free from codepex.com.

For this example, I’m choosing the AdventureWorksLT sample database as the source (Figure B). The next step is to create a server to host your SQL database. In the Server section, click the ...

Let’s use SQL Server Enterprise Manager to add a Windows group to a Pubs database (a sample database that comes with SQL Server 2000) role. The first step is to create a login for the members of ...

Microsoft continues to make positive strides in the world of open source. The company once considered open source software to be an anathema, but now it’s common for Microsoft to pull software ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep ... you must be aware that a bare date (like "2017-10-31" in my sample query) includes a time: It's midnight in the ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...