I hope you’ve had a great week!
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Rebuilding system databases in 2008 R2 – Apparently it can’t be done at this time so ensure you have a file level backup.
- SQL University – HA/DR Week – This weeks lesson at the SQL University brings clarity to two often misunderstood concepts in database technology. Make sure you understand the difference and can educate others in your workplace of the same. I see this confusion a lot and it’s important the distinction is made for the safety of your data.
- Purging Data – Nice write up here from Bart Duncan that presents a walk-through of the various methods available to your for Deleting data efficiently.
- Reporting Services, Scale Out and Clusters… – Some good advice and technical info here from the SQL Server CAT (Customer Advisory Team).
- Sargability: Why %string% Is Slow – A clearly presented walk through here courtesy of Brent Ozar.
- SQL Server 2008 R2 Standard Supports Less Memory – An interesting observation here.
- What is a good way to run CHECKDB on a very large database?
- Optimising wildcard prefixed LIKE conditions – A good query performance tuning article here from AdaTheDev.
- Whitepaper on high-availability architectures published – Looking forward to getting stuck into this…
SQL Server Upcoming Events
- SQL Server Master Class – 17th June – Paul Randal and Kimberly Tripp are coming over to the UK! I can’t wait for this and I will be bringing a few chums from work along too.
- SQLCruise – 2nd August – This will be awesome!
- Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.
Misc Technology News
I want to hear about your iPad experiences. Have you bought one and what version? Are you pleased with your purchase? Let me know…..
- ITV HD viewers miss England’s first World Cup goal – Seriously, this is a big deal for us Brits!
- US debates its broadband future