SQL SERVER – How Do I Evaluate Monitoring Tools?
From last many years, I have been working with SQL Server focusing on Performance Tuning and Optimization. I often get asked what is my favorite monitoring tool. I have previously written about this subject on the blog and there are five part blog seri …
How to Build an Efficient Request Process for SQL Server DBAs
The post How to Build an Efficient Request Process for SQL Server DBAs appeared first on SQLServerCentral.
MDX (MultiDimensional Expressions) in 148 minutes
If you want to understand the fundamentals of MDX in less than 3 hours – this article can be helpful. I came to the conclusion that the best way of learning are video tutorials. 143 minutes of watching and 5 minutes of reading. Let’s get started. Some …
Developers: Azure SQL DB Serverless can save you money.
If you’ve got a database that doesn’t need to be on all the time, Azure SQL DB Serverless is in public preview now. It makes a lot of sense for those development databases you have to keep around, but don’t really want to pay for. If …
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me. …
Microsoft SQL Server: Current Identify Column Value in a Table
The post Microsoft SQL Server: Current Identify Column Value in a Table appeared first on SQLServerCentral.
Using Azure Data Studio with TFVC
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azu …
The Silent Bug I Find in Most Triggers
Get Notebook – FAQ I don’t have a problem with triggers. They get the job done when you need to implement business logic in a hurry, and you’re not allowed to change the application. As long as you keep the number of statements to a m …
SQL SERVER – Script to Kill All Inactive Sessions – Kill Sleeping Sessions from sp_who2
I consider myself fortunate that I get to work with so many different clients while engaged in Comprehensive Database Performance Health Check. Recently we found out that one of the third party application for the client is not closing the connections …
Enable SQL Server Agent Mail Profile
The post Enable SQL Server Agent Mail Profile appeared first on SQLServerCentral.
How to List Dirty Pages From Memory in SQL Server? – Interview Question of the Week #223
Question: How to List Dirty Pages From Memory in SQL Server?Answer: I recently received this question today during my SQL Server Performance Tuning Practical Workshop. To my surprise, I have already blogged about this in detailed earlier so during the …
SQL SERVER – Error: 9642 – An error occurred in a Service Broker/Database Mirroring transport connection endpoint
During my consultancy engagement, my client’s DBA team was checked ERRORLOG and asked me the possible cause of below error about service broker.DateTime spid74s Error: 9642, Severity: 16, State: 3.DateTime spid74s …
SQL SERVER 2008 R2 – I Support You Beyond July 9 2019
One of my clients is primarily using SQL Server 2008 R2 for most of their application. They are also using the same for their own clients and are managing over 100 installations of various versions of SQL Server. They have frequently hired me for Compr …
Change Not For Replication Value for SQL Server Identity Columns
The post Change Not For Replication Value for SQL Server Identity Columns appeared first on SQLServerCentral.
Are your CPU-intensive queries running slowly? Check your VM type.
When you build a VM for SQL Server in Amazon EC2, Azure VMs, or Google Compute Engine, it’s all too easy to overlook the CPU speeds that you’re getting. Most of the time, it doesn’t really matter because SQL Server isn’t us …