Registration Open for My Upcoming Pre-Cons: Belgium, Dallas, Iceland, Israel, Miami, Orlando!
I’m hitting the road this spring. Here’s where to find me in person: SQLSaturday Iceland – Your First SQL Server Performance Tuning Class – March 16 – You’re stuck with a database server that’s not going f …
Complimentary access to Gartner’s 2018 Market Guide for Data Masking from Redgate
According to Gartner, « security and risk management leaders should use data masking to desensitize or protect sensitive data to address threats and compliance requirements. » Gartner further adds, « by 2021, the global enterprise use of data masking (DM) …
A Tiny Trauma
Unexpected issue with a hidden calculation on TinyInt
Better Code Reviews with GIT
As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.
SQL SERVER – Say No To Database Engine Tuning Advisor
I have been using SQL Server for over 20 years and have been working on the focused area of SQL Server Performance Tuning for over 12 years. In recent time I have been very busy doing Comprehensive Database Performance Health Check, and the client …
The “Guess the Next Release Date” contest continues…
Back in December 2017, when I posted the Guess the Next SQL Server Release Date Contest, you could leave your guess in the comments for a chance to win a Live Class Season Pass and a Recorded Class Season Pass. Here’s how the guesses so far …
Creating Your First Stored Procedure
Learn how to get started writing code modules inside of your SQL Server database,
Robotics Process Automation: The New Digital Assistant
When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA), however, deals with automating mundane office tasks. In this article, Arvind Kumar explains the benefits of RPA …
Compliant Database DevOps for SQL Server using Redgate Tools
In this article Stephanie Herr looks at the Redgate tools that give you an end-to-end compliant Database DevOps Solution
Getting Started with Database containers
A beginning look at containers in Windows.
Feb 2019 Updates – Webcast, SQLBits, SQL Saturday and Performance Tuning of Your System
As February starts, just thought of dropping a note to let you know where you can find me in the upcoming months. Do scroll down all the way to read the change in offering in SQL Server Performance Tuning Workshop. Optimize Server Performance by Reduci …
Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211
Question: Does Parallel Threads Process Equal Rows? Answer: No. (Well usually no). I received the same question during the Comprehensive Database Performance Health Check. Here is the simple proof running the following query: SELECT [SalesOrderID] …
SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation
Once upon a time, I was trying to remove TempDB database additional files, but it was not working. In this blog I would explain the steps needed fix Msg 2555: Cannot move all contents of the file to other places to complete the emptyfile operation. THE …
SQL Server Diagnostic Information Queries for February 2019
This month, I have just made some minor improvements to most of the query sets, mainly in the comments and documentation. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spect …
[Video] Getting Started with the Consultant Toolkit
You’re a consultant who needs to figure out why your clients’ SQL Servers are slow and unreliable. You’ve collected a bunch of diagnostic queries over the years, but they have a lot of holes, and you don’t really have the time t …