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.

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

0 comments, 1,296 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, 1,970 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, 606 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, 853 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, 387 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,375 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, 940 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, 404 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, 635 reads

Posted in Cleveland DBA on 1 December 2011