I hope you’ve had a great week!
I want to say a big thank you to everyone involved with SQLBits this week. The calibre of speakers and the quality of the presentations delivered was excellent. The highlight for me personally was the opportunity to meet with so many great SQL people and already I cannot wait for the next SQLBits!.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Important things for DBAs to consider – Great list here from Paul Randal, that provides a lot of excellent references to further reading for each consideration.
- SQL Server 2008 R2 Release Date: May 21 2010 – Some thoughts from Brent Ozar on the upcoming SQL Server 2008 R2 release.
- A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records – Continuing this excellent post series, Paul Randal dispels yet another myth.
- A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core – Administrators who design and manage how the tempdb database is configured in SQL Server need to read this! Interestingly this also came up as a heated discussion point at SQLBits this week so clearly there it quite a lot of confusion in the community about this topic.
- T-SQL Tuesday #005: Focus on Users when Reporting – A reminder here from Michael J Swart about the importance of understanding what the end user wants to achieve from your BI project.
- The case of the additional indexes – Real life support experiences from the SQL Server CSS team.
- How to Avoid Some Common Developer and DBA Mistakes – It’s always good to know what NOT to do as well as what you should be doing.
- Mirroring: what happens if principal loses contact with both mirror and witness? – Tibor Karaszi discusses.
SQL Server Upcoming Events
- PASS European Conference – 21-23rd April 2010 – Germany
- 24 Hours of PASS 2010 – 19th May, Global.
- Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.
If there is an upcoming SQL Server event that I’ve not included?
Misc. Technology News
- Opera iPhone app downloaded a million times in 24 hours
- Twitter used to predict box office hits
- Icelandic ash cloud to keep UK skies closed ’til Saturday