#microsoft

FOLLOW ME:

RECENT POSTS:

Forgot my SA password, and I don't have sysadmin rights...

Page Splits, should I worry?

Capture Query Information with Extended Events

DBCC CheckDB on a large Database

New TempDB TraceFlag

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server. When not working I like to lift weights, play music, and travel with my wife.

How do I encrypt Social Security Numbers in SQL Server?

So, your manager wants you to figure out how to encrypt sensitive Data? Well Microsoft has introduced a fairly easy way to configure...

No Backups, No Logs, No Dice...

It's becoming less surprising, but no less scary when I find shops not taking regular database backups. This happens quite often in...

Query Store Overview

It's amazing that we never had a built in feature that logged historical record of queries. Sure we had the plan cache, but that was...

The importance of RPO and RTO

It is unbelievable how common it is to walk into a new organization only to find that they have no database backups. But when having a...

Using Diskspd To Test Storage

It's important to test your storage performance especially prior to installing or deploying a new SQL Server. Microsoft has provided us...

TSQL Tuesday: Folks Who Have Made a Difference

Today's post was prompted by SQL On Ice. He proposed that we take this week's TSQL Tuesday to show our appreciation of people who have...

AlwaysOn Series: Monitoring with SQL Agent Alerts

There are several ways to monitor your Availability Groups using native SQL tools. In this particular article I'm going to cover a few...

Build an AlwaysON Availability Group Part 1: Build the Windows Failover Cluster

Build the cluster right so you don't run around frantically like this guy does for a living. So most DBA's know that AlwaysOn...