In today’s episode, we’ll explore how to simulate and capture deadlocks in SQL Server using the powerful SQL Server Profiler.
Capture Query Plans Using Extended Events and Traces – Analyzing SQL Server Query Plans – Part 1
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Capture Query Plans Using Extended Events and Traces.
Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly
I am not sure what changes I made in one of my Virtual Machine, but I was running into an issue. In this blog, we would discuss how to fix error “The ‘SqlStudio Profile Package’ package did not load correctly” while launching Visual Studio.
SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly
Sometimes there are unexpected errors and it’s always fun to find the cause of them. In this blog, we would learn about fixing an error which I received while doing create catalog from SQL Server Management Studio.
SQL SERVER – SQL Profiler vs Extended Events
To tell you the truth, I didn’t know how to start this article about SQL Profiler vs Extended Events. After all, I decided to take mind off things and to watch a movie. The movie was Iron Man 2. In addition to the brilliant performance of Robert Downie Jr., one phrase stuck in my mind and immediately inspired my writing.
“Don’t get so attached to things, learn to let go.”
~ Iron Man 2 (Robert Downie Jr)
What is better the old reliable SQL Profiler or something new? My personal choice is Extended Events. Why? To deal with Extended Events, we should go back to SQL Profiler and comprehend its work. First, a new trace is created, and information to be traced is noted.
SQL SERVER – FIX: SQL Profiler Error – Cannot Retrieve Trace Definition for SQL Server Version
As soon as I opened profiler and clicked on “connect” button, I was welcomed with below the message box. This is one of the funniest error message which I have seen from long time. There is no message!!! Let us see how to fix SQL Profiler Error.
Hitting OK on above, came to below message.
The version shown in the message 13.0.900 is the version of my SQL instance (SQL Server 2016 CTP) on which I was connecting. Here is the text of the second error message.
SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server
In this blog post we Nakul will talk about Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server.