We're a wiki, like Wikipedia:
all of the information you see here is freely editable by any logged-in user.
Anyone can contribute to articles, add new code, edit articles, you name it. This site is by the community, for the community. Content is moderated by the community and our own panel of database experts, all with a high level of expertise and passion in their field.
Wiki Updates
SQL Azure
Get started with SQL Server in the cloud.
SQL Server Training
Free, in-depth, training with Kevin Kline, Brent Ozar, Buck Woody and Ariel Weil.
DBCC Commands
Using DBCC commands.
Date and Time Functions
Get to know Date and Time functions in T-SQL.
Finding the Instance Name from Task Manager
Troubleshooting multiple instance overhead.
Blog Updates
-
Does TF 1118 affect Tempdb only or all user databases as well?
A better understanding of the trace flag for Tempdb.
-
Do You Solution?
Use Solution Explorer to organize your scripts and projects.
-
Does CHECKPOINT write uncommitted data to disk?
What really happens when a CHECKPOINT is issued?
-
Index Black Ops Series
Summary post of this excellent series on indexing.
-
Maaaaaagic Tables!!!
What are Magic tables? Do they even exist?!.