I’m 30 today. In addition, it’s been 10 years since I started working with SQL Server. In my twenties, I fell in love with T-SQL and SQL...

I was invited to take part in a new initiative conceived by Boris Hristov (Blog|Twitter). Boris wants to start using the Google Hangouts...

For most DBAs, Management Studio is the primary work tool. That’s why properly using it can save a-lot of time and effort. Here’s a few...

Or Using SQL Server 2012 Offset Functions to Detect Gaps In Your Data Today we are going to examine date island problems and the ways in...

I came across a cool open source tool called “SQL Space Map“. The tool, written by Ryan McCauley, presents a visual representation of...

Views, table variables and local variables are great in terms of programming principles. But In terms of performance, they can be a honey...

One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan. This Dynamic Management Function allows us to...

Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on. Companies want to check what...

About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much. Today, I want to talk about the various video...

Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server user group. Among the...