Good reads from around the Web.
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week.
Regular readers know that I’m a big believer of using any available opportunity during the busy day to get my learn on. I find audiobooksare a splendid way to achieve this. Each day I commute roughly for two hours, a perfect opportunity to turn otherwise wasted downtime into a productive and enjoyable experience. I use Audible.com and right now they’re offering 50% off of subscriptions for a limited time only. An opportunity I encourage you take advantage of.
This week I’m listening to Chris Hadfield’s amazing: An Astronaut’s Guide to Life on Earth: What Going to Space Taught Me About Ingenuity, Determination, and Being Prepared for Anything. Who knew that being an astronaut has so much in common with being a DBA!
Here’s your weekly roundup of SQL Server Blog Posts, News and Technology Stuff. Enjoy….
From the SQL Server blogs
- Reporting in Production: SQL Server (video) – Jeremiah Peschka (Blog|Twitter) is your host, discussing methods to provision support for reporting workloads against your production environment. Brent is also offering up a hat-tip (unintentional?) to Mr Bigglesworth.
- Building Concurrency Tests – Michael J. Swart (Blog|Twitter) continues his excellent series on building a framework for testing concurrent activity in SQL Server. I think I’ll be borrowing this.
- Disaster recovery 101: restore master or rebuild master – The results are in! Here’s Paul Randal (Blog|Twitter) on why every DBA should be familiar with this administration task.
- Using Powershell with SQL Server Clusters – Getting Information – PowerShell, it’s magic. Go learn some. Here’s Sean Gallardy(Blog|Twitter) on how you can simplify working with SQL Server Clusters.
- Exploring the Magic of the Plan Cache – Identifying optimization opportunities via the Plan Cache, with Jeremiah Peschka (Blog|Twitter).
- SQL Server Hekaton (XTP) in-memory tables: Choosing the correct BUCKET_COUNT for a Hash Index – Continuing his insightful series on Hekaton, it’s Tony Rogerson (Blog|Twitter).
- UPDATE STATISTICS: the Secret IO Explosion – Making the case for keeping a closer handle on your SQL Server Statistics management with Kendra Little (Blog|Twitter).
- Final Service Packs for SQL Server 2008 and SQL Server 2008 R2 – Glenn Berry (Blog|Twitter) on whether we can expect to see SP 3.
- What Do You Ask the Leaving DBA? – How much? Brent Ozar (Blog|Twitter) ran a Twitter discussion to find out and here he shares the community’s wisdom. Some jolly good stuff here.
- Watch Brent Tune Queries – Ever wonder how someone else does it? Peer over the shoulder of Brent Ozar (Blog|Twitter).
- Inside the Statistics Histogram & Density Vector – A very well presented walk-through, courtesy of Klaus Aschenbrenner (Blog|Twitter).
Other Stuff Worth Reading
- Apple’s iPod: is the end nigh? – BBC News
- What does “challenging” really mean? – Colleen Morrow
- Experience Comes from Mistakes – Chris Shaw
- Oracle releases ‘lite’ virtual Big Data appliance – TheRegister
- Amazon stock slides 10% on earnings miss – BBC News
- 10 Reasons to Stop Working So Hard – Inc.com
SQL Community Forum
Conversations happening right now in the SQLBrit Community Forum
Like these links? Subscribe to get them every week! Thanks and have a great weekend.