Jeff Moden's election to the Exceptional DBA of the Year award for 2011 was a popular one. Although all the finalists were exceptional, Jeff has impressed everyone with his energy, stamina and wit, particularly with his work on SQL Server Central. In conversation with Richard Morris, Jeff comes up with several nuggets of advice and opinion that are valuable for any DBA or database developer.
On Thursday December 15th at 8PM Pacific, Jeremy will discuss the strengths and disadvantages of a row-versioned data warehouse design in the context of a real world case study, sharing lessons learnt and demonstrating some of the technologies and techniques used to build a row-versioned data warehouse
If you would like to tackle an interesting project at work or find yourself something new to do next year, read this idea from Steve Jones.
In this Level you will see how to use the ORDER BY clause to return your data in a sorted order.
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.
Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this article, Grant Fritchey looks at what you should be doing to make your restores as quick and seamless as possible.
With data stored in tables, you have a few options to protect data. Check out this tip to learn more about column level encryption.
Instagram has a complex architecture for it's technology infrastructure. The people that work there have to be jacks of all trades. Is that the type of environment you'd like to work in?
Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers