SQL Saturday 343 (Medellín)

Last 27th of September SQL Saturday 343 took place. It was the first SQL Saturday Event in Medellin, Colombia. Even though I was born in Colombia I had never been in Medellin. If you have never been in Medellin, I can recommend it to you as a great vacation destination, the city is beautiful, the food is […]

Free PowerShell training!!!

I have good news for those of you who would like to improve their PowerShell(PoSh) skills. Veeam has made a few videos available that will help you improve your PoSh skills. You can find the PowerShell training videos here. Have fun!

Missing Index Script

I have been using the SQL Server Performance Dashboard for a long time. The Performance Dashboard is in my opinion an excellent tool to troubleshoot, specially when you don’t have a set of your own scripts. One of the things that the Performance Dashboard has is a list of the missing indexes on the SQL […]

SQL Saturday 282

SQL Saturday #282 will take place in San José, Costa Rica. The event count with great speakers, I feel honored that one of my sessions was selected for the event. If you are around San José on the 26th of April and you work with SQL Server, I will advise you to attend the event. […]

Download SQL Server 2014 now!

I did not write this post yesterday as I though that most people would think it will be an april fools’ joke. It finally arrived. SQL Server 2014 RTM is available for download. If you want to download it, you can do so by going to http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx?WT.mc_id=Blog_SQL_Launch_SQL2014. I’m really happy about this new version of SQL […]

SQL Server 2014 almost here!

Today’s biggest news for anyone using SQL Server is that the SQL Server 2014 RTM release date has been announced. The newest version of SQL Server will be released on April fool’s day. Quentin Clark announced the release date in Microsoft’s official blog. If you want to know more about this release you can check […]

Have you already tried “sp_AskBrent”?

Most of you probably have heard of  Brent Ozar. Today I would like to ask you, have you already tried “sp_AskBrent”? If you have not tried yet, I will strongly recommend to try it. It will help you to identify what is making your Server slow. Even if you are not really sure about it, […]

What do the "DB File Free Space (MB)" and the "DB File Free Space (%)" SCOM performance counters really monitor?

What do the “DB File Free Space (MB)” and the “DB File Free Space (%)” SCOM performance counters really monitor?

SCOM can be very helpful when monitoring your SQL Server Infrastructure. Sometimes when I get SCOM alerts, I don’t really now what they mean. Luckly for me there are many people that do know what they mean and how they work. One of these persons is my colleague Ruud van den Hooff. He took the time […]

Annual Report

Annual Report

A few things every DBA should know about Page Life Expectancy(PLE) & NUMA

A few days ago I was talking with some friends about Page Life Expectancy and why I do not consider it to be a valuable counter anymore. I started the discussion because I read Paul Randal’s blog about how the PLE value is affected when using systems that use  Non-Uniform Memory Access. According to Paul’s blog […]