top of page


The #1 Enemy of Data Loading in SQL Server
Let’s look at the following script: Transact-SQL CREATE TABLE LoadMeFast (Id INT NOT NULL, InsertDate DATETIME NOT NULL,...

Madeira Team
Jun 3, 20153 min read
0
Query Progress Tracking in SQL Server for the DBA VC
This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter. The session covers many...

Madeira Team
May 29, 20151 min read
0


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

Madeira Team
May 19, 20151 min read
0


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

Madeira Team
May 11, 20156 min read
0


Debug Managed Code and Stored Procedures Seamlessly
Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing and code analysis....

Madeira Team
May 6, 20155 min read
0
How to Measure IO Latency for Database Files in SQL Server
In order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a DMV called...

Madeira Team
Apr 8, 20152 min read
0


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

Madeira Team
Mar 30, 20152 min read
0


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

Madeira Team
Mar 10, 20151 min read
0
SQLRally and SQLBits Slides and Demos
It’s been a great a busy week. On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen....

Madeira Team
Mar 6, 20151 min read
0
Spring 2015 Advanced Programming in SQL Server
The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “5” not found /] Course...

Madeira Team
Mar 4, 20151 min read
0
bottom of page