#Devleopment

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.

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

Triggers

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

Powershell: Failover a SQL Service in a Failover Cluster

Is this where clusters go when they die? A great way to test failover or to simply move disable a clustered SQL Service is to utilize...

T-SQL Tuesday: The OVER Clause

Not quite... The OVER clause was first introduced to us in SQL 2005. It is often used as a supplement to other functions to provide which...