I hope you’ve had a great week!
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Alternative to restoring to a point in TIME – Another fantastic post this week from Janice Lee, providing a detailed walk through with good clear examples. Janice is a relatively new Blogger on the scene and is consistently delivering great content so be sure to add her to your Reader.
- Powershell Remoting with SQL Server – I really need to spend some more time with Powershell because posts like this, from the Scary DBA (oooh), illustrate how it can increase the productivity of a DBA.
- Count(*) or Count(1) ? – This post produced some lively discussions this week on Twitter.
- Hit and miss – Some excellent troubleshooting tips for investigating usage of the Plan Cache, courtesy of Gail Shaw.
- Return of the 24 Hours of PASS – Brilliant news! Previous events have been simply awesome and it looks like the format will be slightly different this time around.
- Finding Key Lookups In Cached Execution Plans – An awesome performance tuning query here from Kendal Van Dyke. This is the second time in as many weeks that harnessing the XML plan from the plan cache has come up as an awesome performance tuning method. Just last week Brent Ozar(@BrentO) kindly pointed me in the direction of a SQL Server Pedia article Queries with Index Scans Due to Implicit Conversions, to use as the basis of a query I was writing. My goal was to identify queries that perform Full Table or Index Scans and so you can see just how versatile this query method is!
- Installing SQL Integration Services after SQL Cluster Setup has Completed – A sneaky little gotcha here to watch out for when installing SSIS on a SQL Server 2008 SP1/Windows 2008 Cluster.
- So I Got Promoted, Now What? Stop Doing Your Old Job – Professional development post with some great advice for you Senior DBA’s or those who manage Data Professionals.
- The TechNet Wiki and Updated Security Checklists – TechNet has a Wiki? Apparently so and with some great content to boot.
- How I Prepared to Run for the PASS Board – Jack Corbett describes how he prepared for the challenge.
- Inside the Optimiser: Constructing a Plan – The first in a series of posts that look at how the Query Optimizer uses rules to build an execution plan, courtesy of Paul White.
SQL Server Upcoming Events
Make sure you vote for the sessions that you want to to see at SQLBits. Simply login to the site, go to the sessions page and click on the ones you want to see for the Saturday lineup.
- SQLCruise – 2nd August
- UK SQL Server Usergroups
- Leeds – July 20th – AGI Northern Group meeting: Using geospatial data in the Microsoft world.
- Manchester – 5th August – Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008.
- Kent – 18th August – This is a new SQL Server Usergroup.
- Leeds – 15th September – Using XML data in SQL Server with Anthony Brown, and Martin Bell explores change management in SQL Server 2008 and Iain Kicks from Quest Software.
- Manchester – 16th September – Agenda to be confirmed
- SQLBits 7 – 30th September – 2nd October – The Seven Wonders of SQL. Pricing
- Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.
Misc Technology News
Seen a great blog post this week that I might have missed? Share it with us using the comments form below.