I hope you’ve had a great week!
Make sure you catch all my posts by Subscribing to the Blog Feed. You can also receive posts via Email.
One of drawbacks to a Blog site layout is that it can be easy for good content to get buried and go unnoticed. I try to get around this by keeping the Popular Posts section up to date, highlighting both the last months most popular content alongside my all time most popular posts. What about all the stuff in between though? Well I’ve now simplified and organized all my post categories, which you can see on the right hand menu widget on the blog. I hope this will improve your experience of the site and maybe even introduce you to some content you’ve yet to enjoy.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Non use of persisted data – Discoveries from a recent client engagement, Dave Ballantyne (Blog|Twitter) demonstrates how a persisted column may not always be chosen by the optimizer.
- T-SQL Script for Estimating Compression Savings – A handy T-SQL script shared courtesy of Michelle Ufford(Blog|Twitter).
- SQL Server and Soft NUMA – Jonathan Kehayias (Blog|Twitter) continues his excellent post series on NUMA technology and it’s application within SQL Server.
- T-SQL Tuesday #19 – Beyond Backups – Talking on this months theme it’s Robert L. Davis(Blog|Twitter).
- Dipping My Toes Into SQL Azure – Part 2 – Protection Mechanisms – CSS SQL Server Engineers (Blog)
- Resolving Conflicts in the Database – The Replication technology debate is up for discussion this week by Jeremiah Peschka (Blog|Twitter). Replication can be an awesome technology but it must be integrated with the complete application platform design in order to ensure you don’t run into trouble.
- Rebind and Rewind in Execution Plans – I’m sure you’ve seen these mentioned in your execution plans but do you know what they actually mean? Grant Fritchey (Blog|Twitter) explains.
- Rankings Updated – Updating his very own chart of the Top SQL Server bloggers in our community, it’s Thomas Larock (Blog|Twitter). This is a great resource to find out which SQL Server bloggers you should be following.
- Enforcing Business Rules Vs. Avoiding Triggers: Which Is Better? – The business logic debate continues, Michael J. Swart (Blog|Twitter) discusses.
- You Probably Already Have a “Private Cloud” – This week Buck Woody (Blog|Twitter) proclaims that many of us are in fact already leveraging the power of the Cloud and that we may not know it just yet.
- Service Broker, not ETL – An interesting discussion of a recent customer project with a difference, that Jamie Thomson(Blog|Twitter) worked on.
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.
- LONDON – Mon 20 Jun – Multi Day Seminar – SQLskills Immersion Event on Internals and Performance – 5 day event 20th June – 25th June
- Tue 21 Jun – SQLskills hosts in London: Tips for Query Tuning with SQL Sentry Plan Explorer and More!
- Wed 22 Jun – Fusion-io will present: SQL at the speed of FLASH
- LONDON – Tue Jun 21 – London UG meeting on BI topics including spatial data support & other topic (TBC)
- EDINBURGH – Thu 23 Jun – Scottish Area User Group Meeting
- 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
- LulzSec hackers claim CIA website shutdown
- Man says he lost $500,000 in virtual currency heist
- Facebook denies losing users
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 onTwitter(@JohnSansom).