Bad Habits to Kick : Thinking a WHILE loop isn't a CURSOR
Talking about the common misconception that a while looper is faster than a cursor (and why it's still a cursor).
Monthly Archive: January 2012
Use SQL Server Code Snippets to encourage consistent conventions
Tip : Use SQL Server Code Snippets to encourage consistent conventions
SQL Server 2012 : The "Launch Date" is not what you think it is
I see a lot of people getting really excited. There is a "virtual launch event" for SQL Server 2012 being held on March 7, 2012. You can read more about the event at http://sqlserverlaunch.com/....
Bad Habits to Kick : Using AS instead of = for column aliases
See why I prefer alias = expression over the more standards-compliant expression AS alias syntax.
Blog Post #500 : 2011, a year in review
In early 2012, I review some of my community contributions and travels from 2011.
New cumulative Updates for SQL Server 2008 SP2/SP3 are available!
On Monday, I completely missed that the SQL Server Release Services team published two cumulative updates for SQL Server 2008. I'd blame jury duty, but that didn't start until Tuesday, and only lasted two...
Get Alerts for Specific SQL Server Login Failed Events
Tip : Get Alerts for Specific SQL Server Login Failed Events
A quick reaction to the PASS board appointments
First of all, I want to congratulate both Kendal van Dyke (@SQLDBA) and James Rowland-Jones (@jrowlandjones) on their recent appointment to the PASS Board of Directors. I have no doubt they will go above...
T-SQL Tuesday #26 : Second Chances
This month's T-SQL Tuesday is being hosted by Dave Howard (@DaveH0ward), and the topic is "Second Chances." What he's letting us do is look back at all the previous T-SQL Tuesdays and pick a...
Connect Digest : 2012-01-09
Hide databases from users who shouldn't be able to see them This is a long-standing request from Erland Sommarskog which I've highlighted in previous digests. But the underlying problem keeps coming up in multiple...
Comparing multiple plans in SQL Sentry Plan Explorer
I’ve seen the question a few times now: “How do I compare two plans side-by-side in Plan Explorer?” Management Studio allows you to view multiple graphical plans that are visible simultaneously, either by generating...