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.

SQLSaturday #164 Cleveland – Tick tock, people!

If you haven’t already heard, Cleveland is hosting SQLSaturday #164 on August 18.  That date is coming up fast and right now we need you (yes you!).  The call for speakers is open for 2 more weeks, so if you’re interested in presenting, submit an abstract.

Cleveland’s last SQLSaturday Read more

4 comments, 483 reads

Posted in Cleveland DBA on 6 June 2012

Testing backups – Is RESTORE DATABASE…VERIFYONLY good enough?

Is it just me, or does there seem to be a lot of discussion these days about testing backups and having a good restore plan in place, before you need it.  You don’t want to be “testing” your backups at 3am during a critical restore operation.

Verify Backup Integrity (aka…

Read more

2 comments, 1,101 reads

Posted in Cleveland DBA on 4 June 2012

Building a SQL Server Inventory – Part 2

Last time I went through my script to gather server information for my inventory. Today I’m going to go through my script to collect SQL Server instance data. So, I think I made it clear last time that I’m not a Powershell guru, and there are probably countless ways in… Read more

5 comments, 2,916 reads

Posted in Cleveland DBA on 31 May 2012

Building a SQL Server Inventory – Part 1

Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with you my script for gathering server-level information as part of my SQL Server inventory. Now, I want to make one thing perfectly clear before we begin, and I can’t… Read more

5 comments, 4,872 reads

Posted in Cleveland DBA on 29 May 2012

SQLSaturday #119 Chicago – In the Books

As I write this, I’m enjoying a margherita pizza and a Miller High Life in my room.  The SQLSaturday #119 afterparty is probably underway, and I’ll head down in a while, but for now I need some time to decompress, recharge my battery.

I’m whooped.  All-day SQL events or training… Read more

2 comments, 484 reads

Posted in Cleveland DBA on 21 May 2012

SQL Saturday #119 – One week to go

One week from today I’ll be boarding a plane for my very first visit to Chicago* (airports not included).

One week from tonight, I’ll be attending my first speaker dinner.

One week from tomorrow, I’ll be presenting at my first SQLSaturday event.  My presentation,  “So I started this blog… now… Read more

0 comments, 451 reads

Posted in Cleveland DBA on 11 May 2012

Blogging Tools: BlogDesk Review

As a blogger, you have several options available to you when it comes to writing posts.  You can write them online, directly inside whatever platform you’re using, be it WordPress, Blogger, TypePad, etc.  If you prefer to write posts offline, you can use a text editor like Word or WordPad… Read more

0 comments, 1,333 reads

Posted in Cleveland DBA on 30 April 2012

Slacking Off: Totally TED

Lately I’ve taken to watching TED talks in the evening.  They’re thought-provoking, usually entertaining, and, best of all when watching late at night, short.  I have to control myself though, I could spend hours jumping from one great topic to another.  Really, I should probably watch something less thought-provoking right… Read more

2 comments, 625 reads

Posted in Cleveland DBA on 27 April 2012

The Importance of a SQL Server Inventory

Pop quiz!

  1. It’s time to true-up with Microsoft, what are your current license counts?
  2. Operations needs to schedule maintenance on ServerY, what applications will be impacted?
  3. A developer wants to change the password for a certain login, what linked servers will be affected?
  4. Are there any databases that haven’t been…

Read more

5 comments, 2,032 reads

Posted in Cleveland DBA on 23 April 2012

Temporary Post Used For Theme Detection (a2bb2736-7786-4122-aa80-2ea5c4a91819 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (a9a8917a-7430-47c6-8534-f96e3e4e0618 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Read more

0 comments, 621 reads

Posted in Cleveland DBA on 21 April 2012

Custom TDS Endpoints: Listening on multiple ports

Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to prevent user access. Today we’ll see how we can configure SQL Server to listen on multiple ports through the use of user-defined endpoints.

Create a new TDS endpoint

There can… Read more

0 comments, 1,189 reads

Posted in Cleveland DBA on 18 April 2012

TDS Endpoints: SQL Server’s “Listener”

In the land of Oracle, if you want to prevent user access to your database, you stop the listener. Without that agent running, you can still connect to the database locally, via shared memory, but all TCP/IP connectivity is disabled. As a DBA, this is pretty handy if you need… Read more

4 comments, 1,194 reads

Posted in Cleveland DBA on 17 April 2012

So I started this blog…now what?

Date: May 19, 2012

Location: SQLSaturday #119, Chicago

Abstract:

Ever thought about trying your hand at blogging? Or maybe you’ve started a blog but struggle with what to write about. We’ll take a beginner’s look at blogging and examine what makes a great blog, finding topics, finding your voice, building… Read more

0 comments, 411 reads

Posted in Cleveland DBA on 14 April 2012

Better Living Thru Powershell: Update Statistics in Parallel

As part of a project I’m currently involved with, we’re migrating a database to SQL Server 2008 and performing some internal updates to the schema and data. Once the database portion of the upgrade is complete, we’d like to update all database statistics before continuing.

On a large database, updating… Read more

5 comments, 2,165 reads

Posted in Cleveland DBA on 12 April 2012

Thoughts on Twitter

We hear a lot about social media these days:  Facebook, LinkedIn, Google+, Twitter, etc.  More and more, we’re expected to participate, to put ourselves out there, on display for the world.  How we present ourselves online has become just as important, and in some cases more important, than how we… Read more

4 comments, 667 reads

Posted in Cleveland DBA on 9 April 2012

Slacking Off: Planes, Trains, and Automobiles

It’s finally Friday.  Grab a cup of coffee, a breakfast pastry of choice, and take a break with some non-SQL reading.

Forget hybrids, where’s my flying car??  The Terrafugia Transition made its debut at the New York International Auto Show this week.  But if history is any indication, we’re still… Read more

0 comments, 610 reads

Posted in Cleveland DBA on 6 April 2012

What’s stopping you?

I mentioned earlier this week that I’m working on a new presentation for SQLSaturday #119 next month.  The talk revolves around common issues that new bloggers face, including reasons for not blogging.  So far, I’ve compiled several common roadblocks, but I’d love to hear from you.

If you’ve thought about… Read more

5 comments, 406 reads

Posted in Cleveland DBA on 4 April 2012

Goals – 9 month checkup

Nine months down, three to go*.  It’s time once again to see where I’m at with the goals I set for myself back in July.

Certification

If you’ll recall, in my last checkup, I had shelved the idea of certification for the time being.  I had other priorities that… Read more

5 comments, 679 reads

Posted in Cleveland DBA on 2 April 2012

Backup script skipping databases – and the fix!

A real head-scratcher

I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost. One day I noticed that the backup script hadn’t backed up all of the databases on my instance. I checked the job history, no errors. I checked the SQL… Read more

5 comments, 1,545 reads

Posted in Cleveland DBA on 26 March 2012

RYO Maintenance Plan – History Cleanup

The last step in our campaign to rid the world of maintenance plans deals with housekeeping: the history cleanup step. I know. Cleanup is never the sexiest of jobs, but just like the dishes or the laundry, it still needs to be done occasionally.

If you were to create an… Read more

0 comments, 664 reads

Posted in Cleveland DBA on 22 March 2012

Newer posts

Older posts