How to build a multi-domain cluster with AlwaysOn availability groups - SQL Server 2016

SQL Server 2016 is making lots of news, and promises to be a revolutionary SQL Server version. In talking about ...

How to store performance counters directly on SQL server using TypePerf Command

Introduction

Powershell error: sqlps.ps1 cannot be loaded because running scripts is disabled on this system

Introduction

An interesting issue came across my desk this week. One of our clients has a number of ...

Multi Tb migration using mydumper

In this post I will explain how to transfer a multi terabyte size database between two MySQL instances using mydumper, ...

Using Kerberos configuration manager to resolve Microsoft SQL server SPN issues

Identifying SPN registration and authentication failures

It’s not uncommon to have authentication issues ...

SQL Server default configurations that you should change

Who here takes the time to adjust default values for SQL ...

SQL Server and Azure - hybrid partitioning - a low-cost solution to retain your data

It's already a fact: cloud is here to stay. As time goes by, we have a better understanding of how it really works ...

SQL Server on Linux – Configuration (Ubuntu)

Following on from my previous ...

Three hidden Azure SQL database gotchas

Context

Azure SQL Database is Microsoft’s Database as a Service (DBaaS) platform offering. It allows end ...

How to restore encrypted backups

Background

SQL Server started having encrypted backups since SQL Server 2014. You can see the technical ...

Import/export multiple SSIS packages

While I was working on a migration project recently, I had the task of importing and then exporting multiple ...

Data classification with Microsoft SQL Server and Azure SQL DB (GDPR, PII, HIPPA...etc)

This blog post will cover SQL Server on-premise or IaaS and Azure SQL DB and how to classify data in both. Let's ...

Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

Introduction

When you have a SQL Server environment where a very complex replication setup is in place, and ...

Locks, blocks and deadlocks - what's the difference?

Explanation

We are often being paged by development teams talking about locks, blocks or deadlocks and some ...

SQL server 2016 - AlwaysOn basic availability group

Recently I was playing with the SQL Server 2016 CTP 2 and noticed that there was a new ...

Issues with Plan Cache Reuse & Row Goal Optimization

I am presenting here on behalf of my colleague Fabiano ...

Implementing fuzzy search in SQL server - part 2: Levenshtein distance

Introduction

The Levenshtein Distance, as discussed in my

Auditing MySQL Users With McAfee Plugin

It is a common auditing requirement to log user connection events, including whether or not authentication was ...

Windows containers: installing SQL server

This blog post is a quick introduction to Containers in the Windows world, and a walk-through on installing SQL Server ...

How to display database statistics for all objects used in a SQL statement

When my current task is to optimize a particular SQL statement, I find it quite useful if I can determine if the ...

How to analyze SQL server stack dumps

Troubleshooting SQL server stack dumps: A practical guide

As a SQL Server production DBA, at some point in ...

DBAs: The 5 key skills you will need in the cloud

Like many organizations, yours is likely under pressure to reduce costs and resources, while increasing storage ...

Dbatools and a SQL Agent

The mission:

Tell every DBA around the world about a secret formula that will give them ...

Azure Data Lake basics for the SQL Server DBA / developer and... for everyone!

The basics