Archive | Pet Peeve RSS feed for this section

SQL Server Join Syntax: It’s Changed!

Alright so maybe that was a little misleading of a title… SQL Server join syntax changed awhile ago, when ANSI-92 joins became the norm. And Microsoft was threatening to remove it for awhile. The older outer join syntax just doesn’t work in SQL Server 2012.  We All Knew SQL Server Joins Were Changing… I know… […]

Share

All I Want For Christmas Is…

I’m not going to let another #mememonday pass without a post – one thought came to mind. The theme this month is – What gift do you want Microsoft to leave under the tree this year? I don’t want much. Bill Gates is already taking care of the world, so no beauty pageant wish there. […]

Share

SQL meme Monday

Just came across this post by Bob Pusateri. He came across a post by Tom LaRock. I like the idea. My first Meme Monday post: Restores – Test them you must or failures you will have. Consider yourself tagged. I look forward to seeing your post.

Share

SQLU DBA Week – Set It And….

Welcome to the third day of DBA week at SQL University. On day one, I kicked off the “back to basics” journey I’ve chosen for fellow students with my post reminding you that you’re only as good as your ability to restore. Microsoft Certified Master Robert Davis brought us a good reminder on Day 2 […]

Share

SQLU DBA Week – You Can Restore It! (right?)

Welcome to my first contribution to SQL University’s Database Administration Week! I am going to go back to some basics here this week. I know you’ve probably been with us for a few semesters and you don’t want to hear that. That’s fine, Microsoft Certified Master Robert Davis is also covering DBA week and he […]

Share

You Keep Using That Word – T-SQL Tuesday Entry

Steve Jones is in the control room for this month’s T-SQL Tuesday challenge. His topic is a good one. I won’t repeat it here, just look at his post announcing this month’s topic. His topic is discussing challenges we’ve faced when dealing with “customers” (I use that to include clients, managers, colleagues, the business, etc.). […]

Share

Create Your Own SQL Server Server Roles

So you’ve heard the buzz by now –  SQL Server Denali is now available in a Community Technology Preview. This was announced, released and handed out in DVD form at the SQL PASS Summit this past week. I just got the chance to install it and I played with one feature that I could see […]

Share