top of page
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
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
Spring 2015 SQL Server Integration Services
The SQL Server Integration Services course teaches you to use this SQL Server program to build data integration solutions. [table “6” not...

Madeira Team
Mar 4, 20151 min read
How to Fix Latch Problems when Working with Ascending Keys in SQL Server
Traditionally, we want our Clustered Index to have the following attributes: Narrow: So that our clustered index and the non-clustered...

Madeira Team
Mar 3, 20151 min read
Spring 2015 SQL Server Integration Services
The SQL Server Integration Services course teaches you to use this SQL Server program to build data integration solutions. [table “6” not...

Madeira Team
Mar 2, 20151 min read
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
Feb 27, 20151 min read


Monitor Query Statistics
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...

Madeira Team
Feb 26, 20158 min read
Speaking at SQLBits and SQLRally
Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun. SQLRally On...

Madeira Team
Feb 24, 20151 min read


The Risk of Ownership Chaining
Recently, I encountered at work the true meaning of ownership chaining and a security risk it can cause. I was asked to define a login...

Madeira Team
Feb 16, 20155 min read


SQL Saturday 360 in Israel
I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had two tracks, one for SQL Server and one for...

Madeira Team
Jan 28, 20151 min read
bottom of page
