I hope you’ve had a great week!
How good was 24 HOP this week! I thought it was another tremendous event packed with great content and I just want to say a big thank you to each every one of you involved in making it happen. You did a fantastic job and I for one appreciate it.
Microsoft are clearly serious about their SQL Server Cloud offering. What with the recent leadership team restructuring and SQL Server celebrity Buck Woody (@BuckWoody) now also getting involved, I’m expecting to see big things from Microsoft/SQL Azure, as businesses begin to shift their focus to seriously consider how they can leverage cloud computing technology. As of this week SQL Azure has it’s very own website so be sure to check it out.
Are you or your business already using SQL Azure in production? I’d love to hear about what you are working on.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- The Cloud and Platform Independence – and Someplace Really Warm You Can Now Ice-Skate – Could it be true, has Microsoft champion and SQL Server guru Buck Woody really succumbed and purchased an iPad?
- SQL Server 2008 R2 and Nehalem Processors – Oscar Zamora provides an account of his recent performance issues whilst using CPU Hyperthreading technology. Also includes interesting details of the support case with Microsoft .
- SQL Server Virtualization: Get Your Hands Off That MAXDOP – The very first post for Brent Ozar under the banner of the SQLSkills team. This is an excellent article that kicks off a Virtualization series and this week looks at CPU configurations for SQL Server on VM’s.
- Invitation to Participate in T-SQL Tuesday #10 – Indexes – Here’s my pick of this months T-SQL Tuesday posts:
- Big Mac Index – Thomas Larock everyone’s favourite rock star Blogger, and author of the awesome DBA Survivor (I will be posting a review soon), shares his T-SQL Tuesday contribution, and it’s making me hungry.
- T-SQL Tuesday #010: Little Known Index Facts – Brought to you by Brad Schulz.
- How is Fill Factor Impacting My Indexes? – An excellent index optmization script that can be used to evaluate the most optimal Fill Factor settings for your indexes. This is an interesting look at a common performance tuning area, from a different direction.
- Guts Of An Clustered Index – Getting physical Michael J Swart reveals all.
- Rename Database Objects En Masse – A T-SQL coding tip, brought to you by SQLFool.
- Policy Based Management and the Unknown LoginMode – An excellent and detailed walk-through here provided by Jonathan Kehayias.
SQL Server Upcoming Events
- SQLBits 7 – 30th September – 2nd October – The Seven Wonders of SQL. This event has now over 600 registrations!
UK SQL Server Usergroups
- Maidstone – 22nd September – Kent User Group – Analysis Services (Andrew Calvett), TSQL Techniques (Dave Ballantyne)
- Cardiff – 23rd Septemeber – Chris Testa O’Neill will be creating a cube with SSAS, Ian Archibald from Attunity demonstrating their CDC products.
- Edinburgh – 7th October – Implementing Hierarchies using TSQL and the HierarchyId type and understanding aggregation problems (Tony Rogerson); TBD (Allan Mitchell).
- Leeds – 27th October – User group evening with Martin Bell and SQL Server and Virtualisation with Mike Kiersey.
- Manchester – 28th October – SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008.