GigaOm x Pythian: Realities and Risks of Enterprise AI
In a recent interview on the Business Disruptions in Tech podcast, Howard Holton and ...

Problem How often do we do Security Reviews for your SQL Server Instances? We aim to stay on top of security and to be ...
SQL Server 2016 is making lots of news, and promises to be a revolutionary SQL Server version. In talking about ...
Introduction Every DBA should know that the baseline is one of the most important pieces to make a proactive ...
Introduction An interesting issue came across my desk this week. One of our clients has a number of PowerShell tasks ...
In this post I will explain how to transfer a multi terabyte size database between two MySQL instances using mydumper, ...
Identifying SPN registration and authentication failures It’s not uncommon to have authentication issues with Microsoft ...
Who here takes the time to adjust default values for SQL Server Configuration after installing it? Unless your company ...
It's already a fact: cloud is here to stay. As time goes by, we have a better understanding of how it really works as ...
Following on from my previous post where we installed SQL Server with the default configuration this article goes into ...

This blog post covers sharding a SQL Server database using Azure tools and PowerShell script snippets.
Context Azure SQL Database is Microsoft’s Database as a Service (DBaaS) platform offering. It allows end users to ...
Background SQL Server started having encrypted backups since SQL Server 2014. You can see the technical details here. ...
While I was working on a migration project recently, I had the task of importing and then exporting multiple packages - ...

In this article, we'll cover the functionality available in SQL Server 2014 for textual research known as Full-Text ...
This blog post will cover SQL Server on-premise or IaaS and Azure SQL DB and how to classify data in both. Let's start ...
Introduction When you have a SQL Server environment where a very complex replication setup is in place, and you need to ...
Explanation We are often being paged by development teams talking about locks, blocks or deadlocks and some people make ...
Recently I was playing with the SQL Server 2016 CTP 2 and noticed that there was a new feature introduced - Basic ...
I am presenting here on behalf of my colleague Fabiano Amorim (he is busy resolving other exciting performance ...
Introduction The Levenshtein Distance, as discussed in my last post, is a way to measure how far two strings are ...
It is a common auditing requirement to log user connection events, including whether or not authentication was ...
This blog post is a quick introduction to Containers in the Windows world, and a walk-through on installing SQL Server ...
When my current task is to optimize a particular SQL statement, I find it quite useful if I can determine if the ...

Intro With Microsoft releasing SQL Server on Linux and a lot of SQL Server DBAs coming from a predominantly Windows ...
Troubleshooting SQL server stack dumps: A practical guide As a SQL Server production DBA, at some point in time you ...
Like many organizations, yours is likely under pressure to reduce costs and resources, while increasing storage ...

Fuzzy Search in SQL Server is not done very well. This post will cover how to implement Fuzzy Search capabilities using ...
The mission: Tell every DBA around the world about a secret formula that will give them powers. What power do you think ...
The basics If you're a Microsoft SQL Server DBA or developer and have not been introduced to the Microsoft Azure Data ...

Recently, checking Amazon Web Services, I stumbled upon a service I hadn't tested before. It was Data Migration Service ...