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 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.

Exam Prep 70-463: SSIS Connection Managers

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 5,506 reads

Posted in Cleveland DBA on 11 December 2014

Exam Prep 70-463: Introduction to SSDT

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 635 reads

Posted in Cleveland DBA on 9 December 2014

Exam Prep 70-463: Columnstore Indexes and Partitioning

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 320 reads

Posted in Cleveland DBA on 4 December 2014

Exam Prep 70-463: Intro to Columnstore Indexes

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

SQL… Read more

0 comments, 4,498 reads

Posted in Cleveland DBA on 1 December 2014

Exam Prep 70-463: Just the facts, ma’am

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Today we’re exploring fact tables… Read more

4 comments, 6,558 reads

Posted in Cleveland DBA on 24 November 2014

Exam Prep 70-463: More about Dimensions

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Today we’re going to review dimension tables in more depth.… Read more

5 comments, 6,016 reads

Posted in Cleveland DBA on 20 November 2014

Exam Prep 70-463: Tables and Schemas

Well, the PASS Summit has come and gone and it was *awesome*.  What a difference from my first Summit experience, when I went to every session I could and then went back to the hotel.  This time around there was something going on every evening and I made the most… Read more

5 comments, 6,290 reads

Posted in Cleveland DBA on 17 November 2014

PASS Summit 2014: WIT Luncheon with Kimberly Bryant

Kimberly Bryant, founder of Black Girls Code

When Kimberly Bryant began studying programming at college, she found that there were few women, let alone women of color, in her program.  As a fellow woman in technology, I can certainly relate to her feelings of isolation.  IT has traditionally been a… Read more

1 comments, 3,364 reads

Posted in Cleveland DBA on 6 November 2014

Summit and something new…

Let me just say, I’m excited.

 

First of all, can you believe that the PASS Summit is next week?  Next. Week.

Are you ready…

  • to have your brain explode from all the SQL learnin’?
  • to reconnect with your SQL Family?
  • to add new members to that family?

 

Personally,… Read more

1 comments, 111 reads

Posted in Cleveland DBA on 31 October 2014

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

3 comments, 165 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, 272 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, 357 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,611 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, 699 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,793 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, 227 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,630 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, 346 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, 468 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, 461 reads

Posted in Cleveland DBA on 28 November 2012

Older posts