Today, I am very happy to share a fun video about class Real World Performance Solutions. I was very fortunate that I got the opportunity to build this video with Bert Wagner. He is truly a talented SQL Server expert and amazingly creative with the videos. I have never seen in my life anyone so versatile with creative with educational videos.
SQL Server Performance Tuning is not as difficult as most of the people think. Actually, SQL Server performance tuning is very easy and simple, if you exactly know what to do and when to do. Well, that is what is the theme of the free webinar which I have done for 24 Hours of PASS.
Lots of people ask me what is the one thing which I am very much proud of in my life. The answer is very simple, I am very much proud of the webcast, which I have done for Group By Conference 3 Common Mistakes to Kill SQL Server Performance. You can watch the video at any of the following location:
One of the most popular question I receive is usually about How to get column names from a specific table in SQL Server?
Earlier this year, I was fortunate to take part in the first edition of the Group By Conference organized by Brent Ozar. I was extremely fortunate that I was able to present an hour long presentation on the subject 3 Common Mistakes to Kill SQL Server Performance.
In this blog post we are going to leave about how to Speed Up Performance Without Code Change or Configuration Change in SQL Server.
One of the most common question I get on blog is – how do I attach database without log file. I have previously blogged about it over here. I request you to read this blog post if you want a solution where you can learn how to attach database to SQL Server with the help of T-SQL.