Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Posted inPowershell SQLMonitor TSQL
How To Handle Passwords in PowerShell Automation
This blog describes how to handle passwords when writing PowerShell automation using Credential Manager
Get Core SQLServer Health Metrics using Dynamic SQL
Dynamic SQL To Collect Remote SQL Server Health
Troubleshooting High CPU on SQL Server – Part 2
Troubleshoot CPU Issue on SQL Server using SQLMonitor
Error/Fix: Msg 924. Get Database Out of Single User Mode
Losing single_user database connection is painful, and this script helps to regain the database access by getting database back to multi_user mode.
Posted inBaseline-SQL-Server TSQL
Time conversion from local to UTC and vice-versa
Recently I have been working on setting up baselining for my SQL Server lab environment. As part of baselining, I capture all the required Perfmon counters both at SQL Server…
Posted inSQL Alerts TSQL
How to Setup Blocking Alerts on SQL Server
It's very common for Database professionals to experience blocking. Even though blocking is a usual activity, it can convert into an issue anytime. And becomes pain point when DBAs are…
Posted inExecution Plan Performance Tuning TSQL
Question/Answer – Should I filter the data in Sub Queries??
Recently a good friend of mine asked me question whether is there any performance benefit in filtering the data out in subqueries, and then joining them. Well, answer is NO.…
![Should we check [context_switches] for SQL Server Query from Performance Point](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/05/Context-Switches.png?fit=1024%2C252&ssl=1)
Posted inPerformance Tuning TSQL
Should we check [context_switches] for SQL Server Query from Performance Point
Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server Queries while performance tuning, then here is the official verdict from Paul Randal. Thanks Friends!…