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

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

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

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

View index usage statistics that show you how often the indexes in the database are used, and whether they’re used for writing or...

This Monday, at SQLSaturday Israel, I presented my new session, “The Data Loading Performance Presentation”. I worked on the session a...

Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning...