A Microsoft SQL Server community of 1,716,846 DBAs, developers and SQL Server users

The first level of this stairway introduces the basics of source control, some common technologies and technologies, and demonstrates how to start versioning a SQL Server database.  Read more...

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...

The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.  Read more...

Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.  Read more...

Steve Jones is putting out an open call for guest editorial pieces in the spring of 2014. If you're interested, read on.  Read more...

Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.  Read more...

This article describes a way to automatically restore multiple database backups from a directory.  Read more...

Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.  Read more...

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014. Register while space is available.  Read more...

Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.  Read more...

In Chapter 1 of our book, MDX with SSAS 2012, we’ve devoted a section “Setting a default member of a...  Read more...

At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy...  Read more...