Jun 24, 2011
Something for the Weekend – SQL Server Links 24/06/11
I hope you’ve had a great week!
This weeks post comes to you live from the SQLskills Immersion Event in London. It’s been a fantastic week jam packed full with learning SQL Server Internals and Performance, although technically right this moment I’m currently slacking in the middle of class so I had better get back to it before I’m caught out. You see the risks I take for you readers! I’ve acquired a mountain of great knowledge to takeaway and put to work back at the office. I’ll be sure to share more in the coming weeks. In the mean time……
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Undocumented Query Plans: Equality Comparisons – More quality content from Paul White (Blog|Twitter).
- Nine Reasons Developers Should Learn SQL – This week Jeremiah Peschka (Blog|Twitter) shares why he thinks Developers should learn SQL. What do you think?
- How to Get Budget Approval for Conferences – Convincing the big man to part with hard cash in order to let you attend a conference can be a prickly subject. Brent Ozar (Blog|Twitter) offers advice on how to secure the deal.
- Make the Optimizer Work Harder – I’m all for making SQL Server work harder so that I don’t have to. Grant Fritchey (Blog|Twitter) highlights a little known execution plan detail that provides insight into the query optimizers efforts.
- Understanding Software Options for your Datacenter Infrastructure - Failover Clustering and Network Load Balancing Team Blog (Blog)
- Why can’t I attach a database to SQL Server 2008 R2? - Microsoft SQLCAT (Blog)
- Are all updates split into delete-insert? – Looking at the internals of the transaction log this week from Gail Shaw (Blog|Twitter). I had the privilege to sit along side Gail this week at the SQLskills event, although how she managed to find the time to squeeze in yet more sql stuff I have no idea
- Removing Auto-Shrink From Maintenance Plans – Thomas Larock (Blog|Twitter) may have won his crusade. Funnily enough this exact subject came up in conversation during the SQL Immersion class this week.
- MAXDOP configuration survey results - It’s the latest survery results courtesy of Paul Randal (Blog|Twitter). I was actually surprised by these results because I’m in the habit of adjusting these settings for the majority of my servers.
- Ozar’s Hierarchy of Database Needs – Here’s Brent Ozar (Blog|Twitter) with a spin on the famous business/lifestyle model.
UK SQL Server Upcoming Events
Use the SQL Server Event Calendar to keep informed of all upcoming SQL Server events, User Groups, and training opportunities here in the UK. You can also add this calendar alongside you existing Google calendar.
- READING – 27 – 28 June – Microsoft Business Intelligence - Discover SQL Server “Denali” with SSAS (Days 1-2)
- KENT – Tue 5 July - A SqlServer focused event with not one but two sql server MVPs. Tony Rogerson & Chris Testa-O’Neill
- SOUTHAMPTON - Wed Jul 6 – SQL User group evening of Matt Whitfield (@atlantis_uk) and Alex Whittles (@PurpleFrogSys)
- CARDIFF – Thu Jul 14 – Cardiff User Group. Agenda TBA
- LONDON - Fri 15 Jul – SQL in the City
- LONDON - September 12 – 14 - Advanced SQL Server Troubleshooting Workshop
Misc Technology Posts
- Google facing US antitrust probe
- Google apps split with Google File System
- Government plans to block piracy websites criticised
That’s it for this week. What was your favourite post? If I’ve missed anything that you think deserves a mention then be sure to let me know! You can leave your comments below, send me an email and find me on Twitter(@JohnSansom).