SQL EVO - AAMIR SYED | Page 2 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.

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.

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

Backup Encryption

If you're storing any of your database backups off site or in the cloud, you might want to look into encrypting your backups. This...

Clear cache for a single Stored Procedure

Sometimes for testing purposes (or an emergency) one might find it useful to remove query plan for a single stored procedure. This way...

RESOURCE_SEMAPHORES

I know, it sounds like it could be a desert. But it's poison! You ever have one of those Saturday morning emergencies and come face to...

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

Use DBATools Powershell module for Migrations

Happy Thanksgiving! If you're not familiar with DBAtools.io I suggest you head over to the site and see what you're missing. The amount...

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

Partition Tables in SQL Server

This post is meant to be a quick primer on Table Partitioning in SQL Server. What is it? Let's say you have a large table that is...

13 4 5