Brent shows what Perfmon counter to watch after your SQL Server restarts.
In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.
This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.
Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
Everyone needs to learn about these hardware bugs and apply patches as soon as possible.
Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.
As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been removed from recent versions of SQL Server. In some cases, the features were widely used and often loved, while others had lost their usefulness over the years or were replaced with something much better. In this article, he remembers Data Transformation Services (DTS), a handful of DBCC commands, a few utilities, Active Directory Helper Service, English Query, Web Assistant, SQL Mail, Native XML Web Services, Notification Services, SQL Distributed Management Objects, Surface Area Configuration Tool, and the Pubs and Northwind databases.
SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.