Though this may look very simple to you it is very crucial to me and I would like to know your opinion about it. I have included the latest video.
SQL SERVER – Script to Update a Specific Column in Entire Database
Last week, I have received a very interesting question and I find in email and I really liked the question as I had to play around with SQL Script for a while to come up with the answer he was looking for. Please read the question and I believe that…
Read MoreSQLAuthority News – Advantages of Distance Learning
Distance education is extremely popular – almost overnight, it seems. Almost everyone has taken an online course, or knows someone who has, or is considering joining an online school. There are many advantages and disadvantages to attending an online school – but the same can be said of attending a…
Read MoreSQL SERVER – Weekly Series – Memory Lane – #031
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…
Read MoreSQLAuthority News – New Theme of SQLAuthority and Video Courses
I have been blogging for almost 7 years now. Recently I reached a very important milestone for my blog. I completed over 2500 blog posts as well have been receiving consistently over 2 Million Views every month. It has been a fantastic ride and I am planning to continue contributing…
Read MoreSQL SERVER – Add Identity Column to Table Based on Order of Another Column
After reading my earlier article on Identity Column, I received a very interesting question. The reason, I like to call it interesting is though, I have provided answers to him, I believe there should be another better alternative to this problem. Let us see the question first in his own…
Read MoreSQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052
Earlier I have posted a puzzle where I was receiving different results when I executed two different queries. I encourage all of you to read the original puzzle here, the puzzle had received many fantastic responses and I have later blogged about the solution of the puzzle over here. Now I…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.