Nov 26, 2010
Something for the Weekend – SQL Server Links 26/11/10
Brrrr it’s cold out and I hope you’ve had a great week!
It’s as if the PASS summit has injected the community with a dose of renewed enthusiasm this past few weeks as a flurry of Blog activity ensues. About time too if you ask me, as some of you have clearly been slacking
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Unexplained Latency in the Distribution Agent using Named Pipe – Another sneaky case of a replication performance anomaly here, as a result of the Named Pipes protocol being used. Includes details of how to go about identifying the problem, thanks to those clever chaps in the Microsoft SQL Server Replication Support Team.
- Performance Tuning Made Easy – Well sort of as nothing is really easy right, Thomas Larock(@SQLRockstar) explains all.
- Pruning backup history taking too long to complete? Read on – I only just stumbled across this Bloggers awesome material for the first time this week and it looks great! I give you Pradeep Adiga.
- A Second in the Life of a Query Operator – Bringing to life the hidden story of your execution plans, brought to you by the unique mind of Brad Schulz.
- Do Foreign Key Constraints Help Performance? – Hmmm sounds like a trick question but is it? SQL Server MVP Grant Fritchy discusses.
- Virtualizing SQL on VMware Reference List – With virtualization becoming an ever more prominent technology partnership with SQL Server it’s important for a DBA to understand as much as possible in this area. Here’s a brilliant collection of references and resources collated thanks to the efforts of Jonathan Kehayias.
- Some Thoughts on Clustering SQL Server Virtual Machines – The second post this week on virtualization from Jonathan Kehayias and be sure to read the comments as we had some great discussion.
- Want to Make Your SQL Server Run Faster for Free? – A reminder from David Levy on the importance of managing the number of Virtual Log Files (VLF’s) within your Transaction Log.
- Get Drive Space Including Mount Points – Via the wonders of PowerShell.
- How Do I Change SSRS Report Credentials with Powershell? – More PowerShell magic, yes there really is such a thing kids.
- Create Your Own SQL Server Server Roles – New to SQL Server 2011 Denali, Mike Walsh walks us through this feature.
- Recompiles – Another brilliant and detailed walk-though from Gail Shaw via her fantastic Blog SQL in the Wild.
- Solid State Drives – Jim McLeod shares his thoughts on Gred Linwood’s presentation of the same.
- Windows Azure Learning Plan – Laying the way forward Buck Woody(@BuckWoody) shares how you too can learn the wonder that is SQL Azure.
- Using SQL Sentry Plan Explorer – A nifty little tip here for working with SQL Sentry’s Plan Explorer tool, courtesy of Jonathan Allen(@fatherjack)
UK SQL Server Upcoming Events
UK SQL Server Usergroups
- LEEDS – Wed 8 Dec – Tony Rogerson and Neil Hambly explores indexed views and computed columns.
- MANCHESTER - Thu 9 Dec – User group evening – Agenda to be confirmed.
- EDINBURGH - Thu 9 Dec – SQL Server Internals (Tony Rogerson); SQL Server 2008 R2 :: a X factor for DBA’s life (Satya Jayanty)
- LEEDS - Wed 19 Jan – Chris Burns and the Resource Governor and Policy Based Management with Chris Testa-O’Neill
Misc Technology Posts
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).