Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Cleveland DBA

Colleen Morrow is a Database Engineer for a software company in Westlake, Ohio. She has worked in the IT industry for 15+ years, doing everything from technical support to development to database administration on Informix, Oracle, and SQL Server platforms.

PASS Summit 2014 – I’m speaking!

On June 25, 2012, I set a goal for myself.  It was this:

In the next 3 years, I want to present at the PASS Summit.

Today I am thrilled and honored to say that this November I will achieve that goal (got it in just under the wire)!  Drawing… Read more

0 comments, 92 reads

Posted in Cleveland DBA on 25 June 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, 197 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, 236 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

2 comments, 1,432 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, 616 reads

Posted in Cleveland DBA on 6 January 2014

Looking for a new SQL Server book? Look no further…

So I know it’s been a while since I last posted on this blog, but I promise I haven’t been totally slacking off.  In fact, I’m proud to announce that I am now an officially published author (I do like the sound of that.  Author).  That’s right, 14 other… Read more

4 comments, 2,718 reads

Posted in Cleveland DBA on 10 October 2013

Event Notifications 101 – Intro to Event Notifications

Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server.  And I told you all about how to use SQL Audit to monitor what’s going on in your databases.  Remember that?  If you do, you might also recall that I… Read more

4 comments, 184 reads

Posted in Cleveland DBA on 15 April 2013

I’ve got mad SQLSkills

Digging the new logo

Last week I was fortunate enough to attend SQLSkills IE1 class in Tampa. Fortunate to have an employer willing to send me to that kind of training, but also because Tampa in February is way better than Cleveland in February. Not that I really got to… Read more

5 comments, 1,562 reads

Posted in Cleveland DBA on 11 February 2013

Changes

Last month I mentioned that I’d like to start including Oracle stuff on this blog.  I’m getting back into that world again as part of the new job, and this blog has always been, first and foremost, a way for me to document and share what I’m learning.  Now I… Read more

0 comments, 306 reads

Posted in Cleveland DBA on 28 January 2013

Long time no blog…

So, you may have noticed that things have been a little quiet around here of late.  Sorry about that, I’ve kind of been dropping the ball when it comes to blogging.

So where have I been?  Well, back in October I left my job of 12 years to move on… Read more

5 comments, 429 reads

Posted in Cleveland DBA on 21 December 2012

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call to discuss and plan upcoming WIT activities, be it SQL Saturday WIT panels or the WIT luncheon at the annual PASS Summit. To help promote women in technology, I’m declaring… Read more

0 comments, 412 reads

Posted in Cleveland DBA on 28 November 2012

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call to discuss and plan upcoming WIT activities, be it SQL Saturday WIT panels or the WIT luncheon at the annual PASS Summit. To help promote women in technology, I’m declaring… Read more

0 comments, 438 reads

Posted in Cleveland DBA on 24 October 2012

SQL Audit – User-defined Audit Events

One thing I failed to touch on during my series on SQL Audit was the use of user-defined events in audits. This was brought to my attention in a comment by one of my readers. He was trying to make use of user-defined events and was having a problem getting… Read more

0 comments, 1,048 reads

Posted in Cleveland DBA on 18 October 2012

SQLSaturday #171 Pittsburgh recap

This past weekend I made the drive from Cleveland to Pittsburgh to attend SQLSaturday #171.  They picked the perfect time of year to host this event, the leaves changing color made for a really pretty drive.

The Event

The weekend started with the speaker dinner, held inside the Rivers Casino.… Read more

2 comments, 336 reads

Posted in Cleveland DBA on 9 October 2012

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call to discuss and plan upcoming WIT activities, be it SQL Saturday WIT panels or the WIT luncheon at the annual PASS Summit.  To help promote women in technology, I’m declaring… Read more

0 comments, 476 reads

Posted in Cleveland DBA on 26 September 2012

Parsing Windows event logs with PowerShell

Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possibly adding that to my Inventory scripts. I like the idea of pulling out the important errors and messages into a central place for easy viewing/reporting. Depending on what platform you’re running… Read more

5 comments, 3,210 reads

Posted in Cleveland DBA on 20 September 2012

SQLSaturday #160 – Get your SQL learn on in Kalamazoo

If you’re planning on being in the Kalamazoo, MI area this weekend, or just feel like taking a road trip, come on out to SQLSaturday #160 at Kalamazoo Valley Community College.  There are some fantastic speakers lined up, including Brent Ozar, Jeff Moden, Eddie Wuerch (giving a 2-part series on… Read more

0 comments, 444 reads

Posted in Cleveland DBA on 17 September 2012

SQLSaturday #171, Pittsburgh

Date: October 6, 2012

Title: Searching for the Holy Grail of DDL Auditing

Abstract:

Who altered this view and how? When was that index created? What happened to my stored procedure? From SQL Trace to SQL Audit and everything in between, we’ll explore various methods of auditing events in SQL… Read more

0 comments, 395 reads

Posted in Cleveland DBA on 16 September 2012

SQL Audit 302 – Deploying the Audit Solution with Powershell

This is it, ladies and gentlemen.  One last post and I promise I won’t mention the word audit for at least a week.
Before we begin, let’s take a moment to recap what we’ve covered so far:

Read more

1 comments, 1,150 reads

Posted in Cleveland DBA on 29 August 2012

SQLSaturday #164 – Cleveland – Touchdown!!

SQLSaturday #164 is in the books and the months of work and planning that went into putting this event together really paid off.  This was my first foray into the planning aspect of such an event and it was quite a learning experience.  Putting together a SQLSaturday is hard work!… Read more

8 comments, 418 reads

Posted in Cleveland DBA on 20 August 2012

Older posts