SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Cleveland DBA

Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data.

Archives: December 2011

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

1 comments, 2,062 reads

Posted in Cleveland DBA on 29 December 2011

SQL Server A to Z – YEAR


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, 2,279 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
	SELECT @bells = POWER(@tiers,2), @hohoho = ' '
	WHILE @bells < 12*@tiers

Read more

1 comments, 772 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, 1,194 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, 605 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,719 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

3 comments, 1,228 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, 716 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, 1,115 reads

Posted in Cleveland DBA on 1 December 2011