I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- XML Validation in SQL Server Intergration Services – A nice walkthrough here from Simon Sabin.
- SQL Azure Frequently Asked Questions – So what’s this SQL Azure all about then? Brent Ozar answers the most frequently asked questions about this young technology.
- Improvement in minimizing lockhash key collisions in SQL Server 2008R2 and its impact on concurrency – Some indepth SQL Server technical discussions here from the SQL Server Storage Engine team.
- DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 – As the title describes, the legend that is Paul Randal notifies us of this latest bug fix.
- Benchmarking: 1-TB table population (part 1: the baseline) – Awesome first installment to this series of intricately detailed performance analysis from Paul Randal.
- Tuning ‘cost threshold for parallelism’ from the Plan Cache – Interesting discussion here from Jonathan Kehayias about consistently producing a parallel query plan.
- Changes to sp_estimate_data_compression_savings stored procedure in SQL2008R2 – Another great contribution from those clever chaps in the SQL Server Storage Engine Team.
- SQL Server – Find the most expensive operations in Execution plans – Now this is cool! I will be adding this my collection of handy DBA scripts.
- Setting a Dedicated Login To Run DMV Queries in SQL Server 20052008 – Frustrated with permissions required to access SQL Server DMV’s. Check out Glenn Berry‘s solutions to your woes.
- Index Defrag Script Updates – Beta Testers Needed – Michell Ufford – Needs you!
- Cross Apply – What is it and how does it work. SQL Agent Man reveals all.
- Question: Is NT AUTHORITYSYSTEM a sysadmin in your SQL Server and Why? – A very interesting question posed by Jonathan Kehayias here. Have you removed yours?
Misc Technology News
- Apple Unveils iPad Tablet device – BBC news coverage. Really unexcited about this. Will it be on your Christmas list this year?
- Windows 7 upgrades Vista laptops to lower battery life – “I can-ne find the power captain!”
- Russia Tests Stealth Fighter Jet – More BBC News coverage. Is it just me or does this video look fake?
- How secure are virtual desktops, really? – With the increasing uptake of virtualisation technologies, how much thought have you given to their security?
That’s it for this week. If I’ve missed anything that you think is worth mentioning then be sure to let me know. Fire me an email or Follow me on Twitter.