I know it has been awhile since I wrote my last blog and I have all the common excuses on why I have not written one in almost a month and most of them are just excuses and not really active reasons. I have had two pieces published in the February 2008 issue of SQL Server Magazine (Virtualization of SQL Server 2008 insert and The 10 Things You Need to Know about Data Protection for SQL Server 2008 supplement) as well as two articles in the March 2008 issue of SQL Server Magazine (SQL Server 2008 Boosts Built-in Encryption and another insert: SQL Server 2008 CPU and Memory Highlights). I have also created two articles for the May 2008 issue and the April 2008 issue of TechNet magazine. It is not like I haven’t been writing anything, just not blog postings.
Well it is time to get back on track and start blogging again so I thought I would write about a great little improvement to SQL Server 2008 Query Editor. SQL Server 2005 introduced the ability to save graphical execution plans as *.sqlplan. This ability allows someone to save the plan and send it to someone else so they could review the plan and suggest improvements. SQL Server 2008 adds the ability to right-click on a graphical plan and extract the query from it. This way you can receive a saved plan from someone and then regenerate the query they used for the plan. Might come in handy to find out what the query really looked like and not what the sender thought it looked like.
- AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups - November 28, 2013
- Custom Master Pages not available from Performance Point Dashboard Designer - June 19, 2012
- An introduction to Power View (code name “Crescent”) in SQL Server 2012 (code name “Denali”) - May 2, 2012