SQL Server 2008 and 2008 R2 is end of life on 9 July 2019

Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You really should be upgrading to SQL Server 2017 at the very least, with some serious consideration to the unreleased SQL Server 2019. My reasoning for suggesting
-> Continue reading SQL Server 2008 and 2008 R2 is end of life on 9 July 2019

Calendar

Dates and Times in SQL Server: DATE

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and times in a more intelligent way than the DATETIME and SMALLDATETIME types that we looked at previously. The first one we look at this week is DATE. Whereas DATETIME uses eight
-> Continue reading Dates and Times in SQL Server: DATE

Post image

Should I upgrade SQL Server 2008 / R2, or migrate to Azure?

[Last updated July 13, 2018] Brent Ozar Unlimited runs a website called SQL Server Updates which comes in really handy for keeping your on-premises SQL Server up to date. In October 2016 I noticed something interesting: if you’re running SQL Server 2008 or 2008 R2, Microsoft’s extended support for it ends on 9 July 2019.
-> Continue reading Should I upgrade SQL Server 2008 / R2, or migrate to Azure?

Post image

Data Efficiency in SQL Server: DATETIME

This is the first in a short series of posts about how I assign efficient data types when designing a new table or database. Use less space with DATETIME2 We all know that the DATETIME column uses 8 bytes of space to store the date and time, to an accuracy of a paltry 3 milliseconds. This
-> Continue reading Data Efficiency in SQL Server: DATETIME