SQL EVO - AAMIR SYED | Page 3 of 5

FOLLOW ME:

All Posts 47 postsNo categories yet.
Storage 2 postsNo categories yet.
Encryption 2 postsNo categories yet.
Backups 4 postsNo categories yet.
High Availability 6 postsNo categories yet.
Disaster Recovery 5 postsNo categories yet.
Performance Tuning 12 postsNo categories yet.
TSQL 4 postsNo categories yet.
Development 4 postsNo categories yet.
Cloud 3 postsNo categories yet.
Azure 3 postsNo categories yet.
Powershell 1 postNo categories yet.
Setup 1 postNo categories yet.
Maintenance 2 postsNo categories yet.
Corruption 1 postNo categories yet.
Monitoring 4 postsNo categories yet.
Administration 2 postsNo categories yet.
Conferences 1 postNo categories yet.
Professional Development 1 postNo categories yet.
Consulting 1 postNo categories yet.

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.

Build an AlwaysON Availability Group Part 2: Setting up SQL Server and Adding a Database

Before we begin: While the gui/wizard for setting up Availability groups is super easy, I'm going to go through utilizing T-SQL. This...

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...

Deadlock Error Handling

An elegant function for a more civilized age: Another way to detect deadlocks is to utilize the TRY CATCH block to raise errors in TSQL...

Reading the Deadlock Graph

It's important to be able to analyze the deadlock graph once it's been detected. I'm going to give a brief run down on what I look at....

Deadlocks: Alerting and Information Collection

Deadlocks can be a serious plague to your existing systems. I am a fan of being proactive whenever possible. So instead of waiting for...

Triggers

What is it? A trigger is almost like a command/function that executes automatically in response to another transaction that has executed....

Powershell: Create Azure SQL Database

While Azure's web portal is quite sophisticated and streamlined, nothing beats the efficiency of powershell. Building off of my...

Script to Kill Blocked Processes

You might be turning the gun on yourself if you ever have to implement this. Disclaimer: I would never suggest running this in a...

Powershell: Stop SQL Server Cluster Resource

We could use this sign when we have approved downtime for upgrades. So this isn't exactly just for SQL, this cmdlet can be used stop and...

SQL Cruise Alaska 2017 Recap

Mendenhall Glacier SQL cruise was something I've always wanted to do ever since it's inception (years ago). Of course, no company was...

1 2

4 5