Fixing Page Life Expectancy (PLE)

What is Page Life Expectancy (PLE), what makes it drop, and how can I manage memory better? Abusing disks slows...

Interview Candidates for Skills, Aptitude, Maybe Both

Over the years I’ve been primary a skills interviewer. In theory I know what skills are needed and in theory...

PASS Summit 2013 - You Ain't From Around Here Are Ya?

I know what y'all are thinkin', what's Charlotte got to do with SQL Server?  Just hear me out.  There's a...

Pointers For SQL Saturday Attendance

I recently got an email from another SQL Saturday organizer asking for "pointers for getting more attendees" to their upcoming...

SQL Saturday 250 – Pittsburgh – Advice for My Presentation on Monitoring and Baselines

I’ll be presenting at SQL Saturday 250 in Pittsburgh on Baselining and Monitoring. This is my first public presentation, and...

SQL Server – Get SQL Server Service Account using T-SQL

SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...

SQL Server – Why is the ‘sa’ Login Account Disabled & How to Enable ‘sa’ Login Account

Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason...

Trigger Status

Have you ever spent hours looking at an issue only to have your investigation hindered by a trigger?  I know...

Azure Changes, While I’m Working

My laptop is out for repair. I’m working currently on a Surface Pro instead. It’s spurred me to do something...

Backup your Windows Azure SQL Databases – Yes,you should !

Care about RPO’s and RTO’s?  Then you should be backing up your Windows AzureSQL Databases(Formerly SQLAzure).

Windows Azure SQL Database is...