On May 18 I presented a session about Extended Events as part of the Global Hebrew PASS Virtual Chapter. I explained what Extended Events...

This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server. What is DocumentDB?...

Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing and code analysis....

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