Jan 30, 2010
Something for the weekend: SQL Server Links 29/01/10
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?