#sqlserver

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.

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

So, say you're at a new client site, or maybe even an old client site, and someone brings to your attention that they have this old SQL...

DBCC CheckDB on a large Database

Running CheckDB regularly is important for the integrity of your database. It's suggested that we run this as often as possible, so that...

New TempDB TraceFlag

In the past we're used to enabling Traceflags 1117 and 1118 in order to help with TempDB Contention. With the release of SQL 2016, these...

Availability Groups and Session Timeouts across WAN?

What is a session timeout? This is a property that dictates how many seconds an availability replica waits for a (ping) response from...

Does SQL Server need more memory? Page Life Expectancy

Page Life Expectancy is the number of seconds the average page of data has been in the buffer pool.SQL server keeps data pages in memory...

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

Use Cases for Query Store

Why should I use Query Store? Query store can be used for a number of things. For example: Find out what was happening on my server last...

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

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

2 3 4