(Kenneth Fisher) If you’ve ever looked at the output for sys.dm_exec_sessions you may have noticed the column program_name. Frequently you’ll see entries like these:

(Hannes Du Preez) In a predominant mobile world, it is essential as a developer to know which databases are available and which technologies can be used to write a data-centric mobile app. In this article you will learn about the SQLite database, Xamarin, and how to make them work together with C#.

(Eli Leiba) There comes a time when a DBA needs to know how much CPU resources each SQL Server database is using. This comes in handy in cases where you need to investigate high CPU usage on your SQL Servers or when you are just trying to understand the CPU heavy consumers on your server.

Hello everyone, this is John your Austin SQL Server Consultant here and today I am going to answer a question that comes up often so I wanted to blog about it for everyone. The question of the day is where can I download the previous SQL Server Updates?

(Pinal Dave) Today we will see a very simple example of the Parameter Sniffing. I was asked by my client if I can explain to them what is the simplest example of the parameter sniffing during a recent consulting engagement of Comprehensive Database Performance Health Check.

(Jason Brimhall) DBAs and ad hoc queries sometimes go together like oil and water. While we may prefer to avoid the ad hoc queries, sometimes it is the best method to achieve a task.

(Grant Fritchey) The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first operator.

(Mohammed Moinudheen) I would like to secure the contents of my Azure storage and limit the accessibility to authorized users based on a certain end date. I would also like to limit the access to the various other services that are available within the Azure storage account. Is there any easy way th

(Chris Webb) One new feature that was introduced in the December 2019 release of Power BI Desktop, but which wasn’t mentioned in the release blog post, is the “Diagnose Step” button on the Tools tab of the Power Query Editor ribbon:

(Pinal Dave) Sometimes it is critical to get back to basics when working on solving a complex problem at Comprehensive Database Performance Health Check. Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the stored procedure.