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.

RYO Maintenance Plan – Database Backups, Part 3

4 out of 5 DBAs agree

I’ve covered creating my backup directories and the actual backup of the database(s). The last thing I want to do in my process is clean up any old backup files. Once again, I want to allow for some flexibility in my procedure. Much… Read more

5 comments, 1,317 reads

Posted in Cleveland DBA on 6 February 2012

RYO Maintenance Plan – Database Backups, Part 2

Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups. Today we’ll get into the meat of the database backup procedure itself. If you’ll recall, this procedure has to meet some specific criteria:

  1. It will need a minimum of…

Read more

4 comments, 947 reads

Posted in Cleveland DBA on 30 January 2012

RYO Maintenance Plan – Database Backups

Remember kids...

Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do something more than twice, it should be scripted (if not fully automated). I’ve also made it fairly clear that I’m no fan of SSIS. So with all that… Read more

5 comments, 1,974 reads

Posted in Cleveland DBA on 23 January 2012

Goals – 6 month checkup

Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself back in July.  Two introspective posts in a row is a bit tiresome, I know, but bear with me and this will be the last bit of navel-gazing for a… Read more

3 comments, 559 reads

Posted in Cleveland DBA on 17 January 2012

TSQL Tuesday #026 – Second Chances

Welcome to the first TSQL Tuesday of 2012!  This month’s soiree is being hosted by Dave Howard (blog | twitter) and he’s feeling a bit nostalgic.  As a result, we get to pick from any of the previous TSQL Tuesday topics and write about that.  He’s even included… Read more

3 comments, 375 reads

Posted in Cleveland DBA on 10 January 2012

Msg 7395: Unable to start a nested transaction

Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but I did have a developer email me with a problem she was having. (I do believe she may have been the only one actually working, can you imagine??) But… Read more

3 comments, 842 reads

Posted in Cleveland DBA on 5 January 2012

SQL Server A to Z – CPU-Z

How fitting that I should close out the A to Z series while I close out the year.  We’ve finally arrived at letter Z and that stands for the CPU-Z utility.  Yes, technically that isn’t a part of SQL Server, but if you hadn’t already noticed by Monday’s ‘Y’ post,… Read more

0 comments, 971 reads

Posted in Cleveland DBA on 29 December 2011

SQL Server A to Z – YEAR

SELECT 'Happy '+ DATENAME(dw, GETDATE())

Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to use “penultimate”). Officially, Y stands for Year, but that would be kinda boring, and quite short, so let’s run with it and talk about all sorts of date-parts-related… Read more

0 comments, 1,693 reads

Posted in Cleveland DBA on 26 December 2011

A SQL Server Christmas Card

Merry Christmas everyone!

DECLARE @hohoho char(100)
DECLARE @bells smallint
DECLARE @tiers smallint
DECLARE @maxtiers smallint

SELECT @hohoho = ' ', @tiers = 1, @bells = 1, @maxtiers = 6
PRINT @hohoho

WHILE @tiers < @maxtiers
BEGIN
	SELECT @bells = POWER(@tiers,2), @hohoho = ' '
	WHILE @bells < 12*@tiers
	BEGIN
		SET…

Read more

1 comments, 418 reads

Posted in Cleveland DBA on 22 December 2011

Pitching Pebbles – Using Certificates to Grant Privileges

If you fill the jar with pebbles first, you'll never have room for the big rocks.

I’m sure you’ve heard the story by Stephen Covey about the professor that fills a jar with rocks, pebbles, and sand as a metaphor for time management and prioritization. I’d relate it here, but… Read more

2 comments, 632 reads

Posted in Cleveland DBA on 19 December 2011

#meme15 – Why Do You Blog?

Jason Strate (blog|@StrateSQL) is starting a new blog meme: #meme15.  The overall topic of #meme15 will be social networking, obviously something that’s getting a lot of attention these days, so there should be plenty to write about.  For the inaugural #meme15 post, the subject is… Read more

0 comments, 237 reads

Posted in Cleveland DBA on 15 December 2011

SQL Server A to Z – XML

I can’t believe it’s already December.  This year has just flown by.  The rush of holiday events has already started, everyone at work is pushing to have their projects completed before the end of the year.  It’s a madhouse, I tell ya.  I’ll be honest, though, for all the running… Read more

0 comments, 1,113 reads

Posted in Cleveland DBA on 8 December 2011

T-SQL Tuesday #025 – Tips and Tricks

This month’s T-SQL Tuesday is being hosted by Allen White (blog | @SQLRunr ).  The topic:  Share your T-SQL tips and tricks.  And if this post looks familar, like something I might have mistakenly posted, say, last Tuesday, well I have no idea what you’re talking about.

This one… Read more

2 comments, 783 reads

Posted in Cleveland DBA on 6 December 2011

Get Involved – This Week In PASS

We’re all busy people.  We have jobs, families, and responsibilities out the wazoo.  Little Timmy needs to be picked up from practice, Fido needs a walk, your boss needs that documentation tomorrow, oh, and your friend needs help moving (again).  It’s easy to let our own personal and professional needs… Read more

0 comments, 260 reads

Posted in Cleveland DBA on 5 December 2011

SQL Server 2012 – Bug in sys.fn_xe_file_target_read_file?

So I finally managed to get my hands on a VM with Windows 2008 R2 SP1 so I could install SQL 2012. (Aside: one of the biggest obstacles to progress is bureaucracy.) Anywho, I plan to explore all of the new features and functionality in 2012 and, of course, blog… Read more

3 comments, 315 reads

Posted in Cleveland DBA on 1 December 2011

SQL Server A to Z – Waits

In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running; it’s the one getting CPU time. A runnable process has everything it needs to run, it’s just waiting for its turn on the CPU. A process that’s waiting, however, is… Read more

0 comments, 386 reads

Posted in Cleveland DBA on 28 November 2011

Optimizing Backup Performance

If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are reserved for data, logs, and tempdb. So it’s up to us squeeze every last bit of performance out of our backup jobs.  If you’re using maintenance plans to do your… Read more

0 comments, 515 reads

Posted in Cleveland DBA on 22 November 2011

SQL Server A to Z – Views

Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to you by the letter V, and V stands for vacation views!

What is a view?
A view is a “virtual table” that contains columns from one or more tables. Although… Read more

0 comments, 370 reads

Posted in Cleveland DBA on 16 November 2011

Creating a Transaction Log Full Alert

When I was a kid, my mom had an old cookie-tin in which she kept her sewing supplies. On the lid was a sticker like this. I thought that was so clever. Anyway, we all have a list of things we say we’ll take care of when we get “a… Read more

2 comments, 493 reads

Posted in Cleveland DBA on 10 November 2011

SQL Server A to Z – User-Defined Functions

The alphabet is quickly winding down (so sad).  We’re up to the letter U and that stands for User-defined functions.

What is a user-defined function (UDF)?

A function is a unit of code that can accept parameters, perform some action or calculation, and then return the result of that action… Read more

1 comments, 527 reads

Posted in Cleveland DBA on 7 November 2011

Newer posts

Older posts