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
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
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
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…
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
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
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
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
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
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
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
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
What is a view?
A view is a “virtual table” that contains columns from one or more tables. Although… Read more
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
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
Ever felt like trying your hand at writing? November is National Novel Writing Month (or NaNoWriMo for our savvy readers). But maybe writing an entire novel is just a bit too ambitious for you. So how about a chapter? That’s a heck of a lot more doable. Well, Jen McCown… Read more
Well, I finally got the feedback from my SQL Audit presentation last month, and I’m very pleased. Ok, more than pleased, I’m downright ecstatic. Overall the feedback was great, but there was also some really helpful constructive criticism. There were 29 attendees for my session, which was a fairly good… Read more
Yes, I know you just got back from the 2011 Summit. Kinda like I just got back from vacation. But that doesn’t mean I haven’t already started thinking about my next vacation. And you should be thinking about next year’s summit. Why? Because until November 15, 2011, you can register Read more