57% of Your Bosses Are Cheap. (Well, maybe 100% of your boss in particular.)
You know what I’ve noticed about companies? Some companies buy tools for you, but they just don’t have a training budget. They believe they hired you to solve problems, and you should have come with the knowledge to get your job done …
SQL Server Performance Tuning Recorded Class – 40% Discount for 4 Days
I have been blogging on SQLAuthority.com for almost 13 years. Well, to be honest, I will be completing the 13th year on November 1, 2019. I did my very first blog post on November 1, 2006, and since that day, I have been pretty much blogging every sing …
Oops, I deleted that data
We all have these days as a DBA, hopefully they are few and far between for most of us. This morning I walked into the office and found a stack of emails saying that a developer had responded to a support ticket and modified the values in one of …
Planning for SAP HANA Deployments in Public Cloud Environments
The post Planning for SAP HANA Deployments in Public Cloud Environments appeared first on SQLServerCentral.
Understanding Auctions
In spite of the fact that they don’t get much attention in basic economics classes, we live in a world where we are subject to auctions almost constantly. It’s not just getting something on eBay or other auction sites, but it’s how ma …
Recreating Databases from Scratch with SQL Change Automation
The post Recreating Databases from Scratch with SQL Change Automation appeared first on SQLServerCentral.
Your Data Career is Stuck in a Rut.
You haven’t really grown as a data professional this year. You’re kinda floating along in your database career, reading blogs, attending webcasts now and then. Maybe you’ll hit a SQL Saturday this year, but … you don’t re …
SQL SERVER – Getting Second Row from Table
The other day during one of my old clients sent me an email about if I know any trick to get the second row from the resultset. I know why he was asking this question as I had worked with him before Comprehensive Database Performance Health Check.Let u …
Using the SQL Compare command line with Argfiles
The post Using the SQL Compare command line with Argfiles appeared first on SQLServerCentral.
Transaction Isolation Levels
Introduction While working with SQL databases, we often write queries without giving a second thought about how the query is going to read data from the underlying tables. As we are aware, databases are designed to follow the basic ACID properties (Ato …
Why Query Store Actual Operation Mode is Not Same as Requested? – Interview Question of the Week #248
Question: Why Query Store Actual Operation Mode is Not Same as Requested?Answer: Recently, one of the largest bank institutes hired me to help them with their SQL Server Performance. The biggest issue which they were facing was query regression. While …
SQL SERVER – Identifying Query Generating Malicious Wait Type
Just another day in my life when I got involved in the SQL Server Performance Comprehensive Database Performance Health Check, where I ended up with a server with a high amount of malicious Wait Type. In this blog post, we will learn about how to fix t …
The Curious Case of… emergency-mode repair
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …
Updated First Responder Kit and Consultant Toolkit for October 2019
This is a pretty doggone big release. There are a lot of improvements to sp_BlitzFirst, sp_BlitzCache, and sp_BlitzWho to prepare for a new release of the First Responder Kit Power BI Dashboard. If you’re using that today, I would strongly recomm …
SQL SERVER – Upgrade Rule Failure Error: No Custom Security Extensions
A few days ago, I wrote a blog about the issue with the SQL Server upgrade where issue was due to Reporting Services installation in a bad state. Here is the link for that blog. SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as …