End of Lifecycle for Windows 2003 R2 and SQL Server 2005

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.

Continue reading “End of Lifecycle for Windows 2003 R2 and SQL Server 2005”

Management Studio Query Templates

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.

Continue reading “Management Studio Query Templates”