SQL Server Live Health Check
Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor
Posted inBaseline-SQL-Server SQL Alerts
Create Auto-Clearing Blocking Tree Alert on SQL Server
Setup/Configure Blocking Mail Notification Alet for SQL Server on-prem & cloud including Azure, AWS, etc.
Posted inLinux
SQL Server on Linux Mint
Why Linux? To start with, I think everyone agrees that Linux is core skills, and no doubt every IT professional should be familiar with it. Almost all enterprise software solutions…
Posted inErrors
Error/Fix: Cannot initialize the data source object of OLE DB provider “OraOLEDB.Oracle” for linked server. (.Net SqlClient Data Provider)
Recently I was working on one user request to create a linked server for Oracle database in SQL Server 2014 instance. After installing the correct Oracle ODBC drivers, when I…
Posted inPowershell
ScriptOut Linked Server with Actual Password
Within my organization, we work in a controlled environment. That means, with each SQL Instance migration, we have strict rules to script out everything including System database user objects, operators,…
Posted inBaseline-SQL-Server SQL Alerts TSQL
Setup Long-Running Jobs Alert
In my organization, we have many SQL Agent jobs that are expected to execute within a particular time window. But there are times when some of them take longer than…
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 inDatabase Administration
Indexing Maintenance Solution for Replication
Like any other DBA, I fell into the trap of using straight maintenance solution using Reorganize operation for Indexes with avg fragmentation with 30% or less with Index Rebuild for…
Posted inErrors
Error/Fix: There is insufficient system memory in resource pool ‘default’ to run this query.
Recently I was reading about Temporal Tables feature that has been introduced with SQL Server 2016. So, as usual, I thought to get the knowledge in practice with my virtual…
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.…