It’s a last day of my combined summer vacation and paternal leave and for the last week my thoughts have, now and then, drifted momentarily to work related things like trying to remember my laptop password. This is, at least for me, a common occurrence. With the end of the vacation approaching my mind starts to get back to the “work mode”. And a blog post seems like a good way to end my vacation.
I’m finally getting back to the “Tools of the Trade” series with a third post on some of my favorite (and free) SQL Server tools. This time on the spotlight is the Diagnostic Scripts by Glenn Berry. The scripts can be found from his blog, here. The whole package is 6 different T-SQL scripts, one for each version of SQL Server starting from 2005 and going to 2016. There’s also a blank Excel to go with each one.
Microsoft Ignite is currently happening in Chicago, IL and there’s already been a some rather interesting news coming in. For us who work with the SQL Server the datasheet for SQL Server 2016 release is now available online. I spotted some rather delicious improvements listed there, especially when it comes to high availability and security (multiple synchronous replicas, round robin load-balancing, always encrypted data and tables “stretched” to cloud!). It was also announced that the public preview for SQL Server 2016 will be coming available this summer.
Just a friendly reminder to everyone that just like all good things come to and end so does the extended support for these two Microsoft products. First will be the Windows 2003 R2 with the end of lifecycle date set to July 14 2015 and soon after that SQL Server 2005 with it’s end of lifecycle date set to April 12 2016.
You can still run these products after these dates of course but it’s definitely not recommended and the reason is simple. End of the extended support means that neither of these products will be receiving any patches or security updates, ever. So if you’re not already working on upgrading them, now would be a good time to start.
Did you know that SQL Server Management Studio comes with a number of ready made templates for writing queries? If not, don’t worry, you’re not alone. Lot of people I’ve talked with aren’t familiar with these, even though they’re not all that well hidden secret.
Let’s take a look at where they are and how they can be used for making your life just a bit easier.
PerfMon is a great tool for collecting performance data from your servers, but it has a few shortcomings when it comes to reporting these results. One of the biggest issues that I also mention in one of my older posts here is, that the graphical presentation becomes hugely inaccurate when you collect data over a long period. While this might not bother you personally, if you’re writing that report to your manager or a customer, it makes sense to show information that is correct.
Let’s look at a simple example.
Just a quick tip this time, but one that can save you lot of time and manual work.
One of the information sources that all administrators, both Windows and SQL Server alike, should follow is the Microsoft Knowledge Base. However as there are new articles coming in daily, going to Knowledge Base and manually searching for them isn’t really a viable option. Even less so if you’re responsible for administering multiple versions of Microsoft software.