MySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server
One of my clients contacted me for a linked server issue between SQL Server and MySQL Server. Since I mostly work with SQL Server, it was a fun installing and connecting MySQL Server. While I was trying to simulate the issue and I wanted to create a li …
Getting Started with Veeam Explorer for Microsoft SQL Server
Veeam Explorer for Microsoft SQL Server allows application-specific restores of SQL databases, as well as contents of tables, objects such as stored procedures, views and more. Additionally, you can restore the databases to a specific transaction.
Building SQL ConstantCare®: Product, Packaging, and Pricing
Our new SQL ConstantCare® is our first paid online service – it tells you what you should do next on your SQL Servers. I’ve written about the vision and the architecture design, and this week I’m continuing to share the …
SQL Server 2017 for Linux first impression
Microsoft has released a version of SQL Server 2017 for Linux.
Monitoring and Troubleshooting Deadlocks with SQL Monitor
This article will discuss why deadlocks occur, why they require immediate investigation by the DBA, and the diagnostic data required to troubleshoot them.
SQL SERVER – AlwaysOn Automatic Seeding – Database Stuck in Restoring State
As a part of my consulting, I observed that there is a lot of interest in using AlwaysOn availability group. I have deployed many AlwaysOn solutions from start-to-finish. Recently I encountered an issue and in this blog, we would discuss reason of an a …
[Video] Office Hours 2018/3/21 (With Transcriptions)
This week, Brent, Richie, and Erik talk replication, SQL Source Control with Git, installing service packs in cumulative updates in SQL Server, query tuning, write errors, log backups, Azure managed instances, 3-rd party backup software, and DBA porn. …
Which is Better for Performance – SELECT or SET? – Interview Question of the Week #166
Question: Which is Better for Performance – SELECT or SET? Answer: Some questions never get old. This is one of such question. Remember that SELECT is designed to return data whereas SET is designed to assign values to lo …
So You Wanna Debug SQL Server Part 1
Start here! This is a gentle introduction to getting set up and started. I’m nowhere near as good at this as I want to be, but I’ve been inspired by a couple wizards: Bob the Ward and Paul the White. The first thing you need to do is go dow …
QL SERVER – Unable to Create Listener: Msg 41009 – The Windows Server Failover Clustering (WSFC) Resource Control API Returned Error Code 5057
One of my clients contacted me for quick On-Demand consulting. They were working under close deadlines and delivering the solution on time was critical for their success. They contacted me and explained that they were having trouble creating a listener …
Table Valued Parameters: Unexpected Parameter Sniffing
Like Table Variables, Kinda Jeremiah wrote about them a few years ago. I always get asked about them while poking fun at Table Variables, so I thought I’d provide some detail and a post to point people to. There are some interesting differences b …
Getting query text from SSMS into a CSV with PowerShell
You have times where you need to copy/paste something out of SSMS’ grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers …
Thinking about microservices? You need DevOps first
With the rise of new virtualization technologies using containers, people are starting to think more and more about using microservices in their organizations. They’ve been getting a lot of attention and companies like Netflix, Amazon, Uber, and …
SQL SERVER – How to Fix High CPU Consumption on SQL Server 2017 and 2016
In this blog post, we are going to discuss how to fix high CPU Consumption on SQL Server 2016 and SQL Server 2017. One of the large multinational corporations recently hired me for Comprehensive Database Performance Health Check. Usually, customer …
Recover Data in SQL Server AWS RDS with the Help of BACPAC
Amazon Web Services (AWS) provides highly available, highly managed SQL Server instances through the Relational Database Service (RDS). Using RDS instances greatly reduces much of the administrative need for managing backups, minor upgrades, and monito …