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.

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, 457 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, 1,471 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

10 comments, 463 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, 740 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, 652 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, 294 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, 1,830 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, 479 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, 430 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, 296 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, 512 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,319 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, 486 reads

Posted in Cleveland DBA on 22 March 2012

RYO Maintenance Plan – Integrity Checks

Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it was here in Cleveland.

Today’s piece of RYO Maintenance Plan deals with database integrity checks; a critical component second only to backups in my book.  The procedure I’ve written is… Read more

0 comments, 413 reads

Posted in Cleveland DBA on 19 March 2012

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

Every month the folks of the SQL Server community get together for a virtual block party of sorts called T-SQL Tuesday.  This month’s party is being hosted by Argenis Fernandez (b|t).  The topic: specialization.  Some folks wear many hats within an organization, others wear only one… Read more

1 comments, 211 reads

Posted in Cleveland DBA on 13 March 2012

March Madness – SQL Server style

Bodypaint not required

It seems that March is another great month for getting your geek on without having to leave the comforts of your desk. Here are some of the SQL Server events still coming up this month:

March 14

Read more

0 comments, 277 reads

Posted in Cleveland DBA on 8 March 2012

RYO Maintenance Plan – Index Maintenance

It’s been a couple of weeks since my last post, but I swear I have a good excuse. I’ve been busily working on a separate writing project, but I’m back now and ready to continue rolling my own maintenance plan. To recap, so far I’ve covered backups, backup cleanup Read more

0 comments, 784 reads

Posted in Cleveland DBA on 5 March 2012

RYO Maintenance Plan – Update Statistics

Another key component of any good maintenance plan is updating statistics. Statistics are what help the SQL Server optimizer choose the best execution plan for your queries. Let your stats get too far out of date, and watch your query performance tank.

For me, the biggest shortcoming of the update… Read more

2 comments, 1,381 reads

Posted in Cleveland DBA on 21 February 2012

Using Powershell to Deploy Performance Monitor

As good little DBAs, we should be gathering baseline statistics for our database servers. These stats can give us insight into what’s changed when performance is suddenly in the toilet. They can also provide a basis for determining what systems can be consolidated, downsized, or virtualized, which has become quite… Read more

2 comments, 1,313 reads

Posted in Cleveland DBA on 13 February 2012

RYO Maintenance Plan – Enhancement Request

In response to my last post, I got a very interesting comment from Philip:

“I would love to see a way to add logic that will verify at least X backup files for a given DB remain. Specifically, in my organization, I would like to delete all but the most…

Read more

0 comments, 872 reads

Posted in Cleveland DBA on 9 February 2012

Newer posts

Older posts