SQL Server A to Z – Waits

• by Colleen M. Morrow

• Cleveland DBA

In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running;...

2011-11-28

863 reads

Optimizing Backup Performance

• by Colleen M. Morrow

• Cleveland DBA

If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are...

2011-11-22

1,170 reads

SQL Server A to Z – Views

• by Colleen M. Morrow

• Cleveland DBA

Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to...

2011-11-16

1,037 reads

Creating a Transaction Log Full Alert

• by Colleen M. Morrow

• Cleveland DBA

When I was a kid, my mom had an old cookie-tin in which she kept her sewing supplies. On the...

2011-11-10

1,195 reads

SQL Server A to Z – User-Defined Functions

• by Colleen M. Morrow

• Cleveland DBA

The alphabet is quickly winding down (so sad).  We’re up to the letter U and that stands for User-defined functions.
What...

2011-11-07

1,325 reads

SQL Tribal Knowledge

• by Colleen M. Morrow

• Cleveland DBA

Ever felt like trying your hand at writing?  November is National Novel Writing Month (or NaNoWriMo for our savvy readers). ...

2011-11-04

519 reads

DDL Auditing presentation – feedback

• by Colleen M. Morrow

• Cleveland DBA

Well, I finally got the feedback from my SQL Audit presentation last month, and I’m very pleased. Ok, more than...

2011-11-03

756 reads

PASS Summit 2012

• by Colleen M. Morrow

• Cleveland DBA

Yes, I know you just got back from the 2011 Summit.  Kinda like I just got back from vacation.  But...

2011-10-31

1,451 reads