This is the seventh post in my retrospective attempt to answer every T-SQL Tuesday invitation. In the beginning of June 2010, Jorge Segarra invited us to write about our favourite hot new feature in SQL… T-SQL Tuesday Retrospective #007: Summertime in the SQL
One of my hobbies is trying to break technology so that you don’t have to. I don’t consider myself a professional or hobbyist hacker, though if the shoe fits… Last year when Windows Server 2019… Unsupported but working versions of SQL Server on Windows Server 2019
My co-authors and I recently wrapped up the book SQL Server 2019 Administration Inside Out, which should be hitting the shelves in the next week or two. At the end of Chapter 1 I have… Deprecated and discontinued features in SQL Server
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… SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
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… Dates and Times in SQL Server: DATE
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… Data Efficiency in SQL Server: DATETIME