SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Cleveland DBA

Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data.

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, 762 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, 1,266 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,753 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, 1,130 reads

Posted in Cleveland DBA on 6 January 2014