Let’s look at the following script: Transact-SQL CREATE TABLE LoadMeFast (Id INT NOT NULL, InsertDate DATETIME NOT NULL,...

This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter. The session covers many...

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