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… Read More »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… Read More »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… Read More »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… Read More »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… Read More »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… Read More »Data Efficiency in SQL Server: DATETIME