Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Cleveland DBA

Colleen Morrow is a SQL Server Consultant at UpSearch, a provider of DBA resources in northeastern Ohio. She has worked in the IT industry for 20 years, doing everything from technical support to development to database administration on Informix, Oracle, and SQL Server platforms.

Archives: November 2011

SQL Server A to Z – Waits

In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running; it’s the one getting CPU time. A runnable process has everything it needs to run, it’s just waiting for its turn on the CPU. A process that’s waiting, however, is… Read more

0 comments, 591 reads

Posted in Cleveland DBA on 28 November 2011

Optimizing Backup Performance

If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are reserved for data, logs, and tempdb. So it’s up to us squeeze every last bit of performance out of our backup jobs.  If you’re using maintenance plans to do your… Read more

0 comments, 901 reads

Posted in Cleveland DBA on 22 November 2011

SQL Server A to Z – Views

Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to you by the letter V, and V stands for vacation views!

What is a view?
A view is a “virtual table” that contains columns from one or more tables. Although… Read more

0 comments, 662 reads

Posted in Cleveland DBA on 16 November 2011

Creating a Transaction Log Full Alert

When I was a kid, my mom had an old cookie-tin in which she kept her sewing supplies. On the lid was a sticker like this. I thought that was so clever. Anyway, we all have a list of things we say we’ll take care of when we get “a… Read more

4 comments, 828 reads

Posted in Cleveland DBA on 10 November 2011

SQL Server A to Z – User-Defined Functions

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

What is a user-defined function (UDF)?

A function is a unit of code that can accept parameters, perform some action or calculation, and then return the result of that action… Read more

1 comments, 969 reads

Posted in Cleveland DBA on 7 November 2011

SQL Tribal Knowledge

Ever felt like trying your hand at writing?  November is National Novel Writing Month (or NaNoWriMo for our savvy readers).  But maybe writing an entire novel is just a bit too ambitious for you.  So how about a chapter?  That’s a heck of a lot more doable.  Well, Jen McCown… Read more

2 comments, 380 reads

Posted in Cleveland DBA on 4 November 2011

DDL Auditing presentation – feedback

Well, I finally got the feedback from my SQL Audit presentation last month, and I’m very pleased. Ok, more than pleased, I’m downright ecstatic.  Overall the feedback was great, but there was also some really helpful constructive criticism.  There were 29 attendees for my session, which was a fairly good… Read more

0 comments, 560 reads

Posted in Cleveland DBA on 3 November 2011