Did you know that installing certain Windows features could impact the way that SQL gets installed on your server? Me either. When performing some installs recently I came across a problem whereby I was not able to change the shared tools location. The option was greyed out. This didn’t make any sense to me. The…
Month: May 2011
How To Interview–A Quick Guide
This post was originally going to be called “Interview Dos and Dont’s” but I didn’t want it to get confused with interviewing on DOS, or to start a grammar war on the use of Do’s or Dos. I had the chance to interview a couple of candidates for a senior developer position today. Each one…
SQL Clustering–Network Binding Order Warnings
In setting up my Windows 2008 R2/SQL 2008 R2 cluster this week I came across a warning in the Setup Support Rules stating that “The domain network is not the first bound network.” This didn’t make any sense to me as I had been very careful in setting the binding order in the network…
T-SQL Tuesday #18–CTE A Simpler Form Of Recursion
It’s T-SQL Tuesday time folks. Bob Pusateri (blog|twitter) is the host and has chosen Common Table Expressions (CTEs) as the topic of the month. Several ideas came to mind for writing about CTEs, one of the best uses I’ve seen for one recently was to grab the name of the most recent backup file for…