In order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a DMV called...

When you configure log shipping, there are 4 SQL Server Agent jobs that are set up: Backup: Performs a backup log operation on the...

Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a mini PASS Summit,...

It’s been a great a busy week. On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen....

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “5” not found /] Course...

The SQL Server Integration Services course teaches you to use this SQL Server program to build data integration solutions. [table “6” not...

Traditionally, we want our Clustered Index to have the following attributes: Narrow: So that our clustered index and the non-clustered...

The SQL Server Integration Services course teaches you to use this SQL Server program to build data integration solutions. [table “6” not...

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “5” not found /] Course...

One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task. Monitoring is a strategy, and a...