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.

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

PAGEIOLATCH_*—Buffer latches, including the PAGEIOLATCH_EX wait type, are used to synchronize access to BUF structures and associated pages in the SQL Server database. The most frequently occurring ...

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

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