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… … Read more

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.

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 … Read more

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

sql server restore

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 … Read more

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.). … Read more

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 … Read more