I hope you’ve had a great week.
You may have noticed that I have not been around quite so much these last few weeks. Well I can promise you won’t hear any excuses for posting less content from me, that’s just not my style (Apology Accepted). Aside from having enjoyed a well deserved (yes I do say so myself) vacation in Florida, I will very soon be embarking on a new SQL Server adventure. One that will almost certainly provide the fuel for some awesome SQL Server performance tuning and administrative focused content. That’s all that I can give away right now but what I will say is that I’m stupendously excited about this opportunity and will be sure to share my experiences and antics with you.
I’m not sure what has been added to the water this past week but the volume of excellent content seems to have jumped up a notch and then some! Perhaps it has something to do with the phenomena that is #Passawesomeness
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- The Complexity of the Query Optimization Process – Ben Nevarez discusses.
- SQL University Hoops Practice – If you have not heard of the SQL University then you need to pull your head out of the sand. Basically it’s FREE grass roots SQL Server mentoring from the Pro’s. Thomas LaRock (SQLRockstar) heads this practice session.
- Performance Counters Missing – Handy to know Tip here from Jason Crider, covering the use of performance counters for SQL Server 2000 when run on a Windows Server 2003 R2 x64 operating system.
- Best Practices for Applications Login to SQL Server? – Barry Young provides his thoughts on this, in response to a recent MSDN question.
- High Availability – Frequently Asked Questions about Failover Clustering and Reporting Services – Some interesting points covered here. If you’re a DBA responsible for Scale Out Reporting Services deployments then be sure to take a look at this.
- Conor vs. UNIQUE in Index Definitions – An interesting point regarding the different query plans produced here.
- SSMS Tools Pack 1.7 is out! New feature: SQL Snippets – If you are not already using this awesome tool then get it now!
- Report Viewer in Visual Studio 2010 – Here’s some news for the BI/Report Developer folk out there.
- Are You Using Scalable Shared Databases? – Are any DBA’s using this little known feature of SQL Server 2005, asks Ben Nevarez. Perhaps it is little known for good reason?
- Query Optimizer: Genius or Bonehead? – An interesting and detailed piece of query tuning analysis here from Brad Schulz.
Misc Techie Stuff
- Don’t be a DBA – Be a Data Professional – Some interesting thoughts here from Buck Woody.
- How to Use Twitter Lists – Do you know how to use this new Twitter feature? Brent Ozar reveals all…
- Call for Rethink on Data Storage – An interesting article from the BBC News this past week.
- Travel Tips for Non-Frequent Flyers – Flying to the SQL Server Pass Summit? Be sure you make the most of your journey and maximize the comfort of your flight by following these excellent tips.