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: January 2014

What does “challenging” really mean?

I had lunch with an old friend last week.  We hadn’t spoken in a while and we were catching up on everything that was going on in our lives.  She mentioned that she was looking for a new job, and we got to talking about what she was looking for. Read more

3 comments, 585 reads

Posted in Cleveland DBA on 27 January 2014

SQL Server 2014 – Buffer Pool Extension

Wanted: more RAM

In an ideal world (well, a DBA’s ideal world, anyway) all database servers would have enough memory to hold every last byte of data we would need to store. We wouldn’t worry about disk latency, and PAGEIOLATCH waits would be nothing more than a distant memory. But… Read more

0 comments, 868 reads

Posted in Cleveland DBA on 20 January 2014

SQL Server 2014 – Delayed Durability

Pop quiz: What does ACID stand for?

That should be a pretty easy question for database professionals:

  • Atomicity
  • Consistency
  • Isolation
  • Durability

It’s that last property, durability, that I want to talk about today. Durability guarantees that, when a transaction is committed, it stays committed. The changes made by that… Read more

4 comments, 2,294 reads

Posted in Cleveland DBA on 13 January 2014

Cleveland rocks in February!

Heading to SQLSaturday #241

It’s a brand new year, so start it off right.  Cleveland is hosting its third SQLSaturday on February 8, 2014 at Hyland Software in Westlake, OH.  (Because where else would you rather be in February than Cleveland, Ohio?)  This is one SQLSaturday you won’t want to… Read more

0 comments, 940 reads

Posted in Cleveland DBA on 6 January 2014