Dates and Times in SQL Server: DATEADD()
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure SQL Database. This week we… Read More »Dates and Times in SQL Server: DATEADD()
T-SQL
String or binary data would be truncated: get the full picture in SQL Server 2017
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server for many years, but was… Read More »String or binary data would be truncated: get the full picture in SQL Server 2017
Bulk insert issue with UTF-8 fixed-width file format
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as well. Let’s say you have… Read More »Bulk insert issue with UTF-8 fixed-width file format
Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the hint AT TIME ZONE. In… Read More »Dates and Times in SQL Server: AT TIME ZONE
A software architect replaces a relational database with a relational database
Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is no doubt biased. It might… Read More »A software architect replaces a relational database with a relational database
Relational databases aren’t the problem
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is no doubt biased. It might… Read More »Relational databases aren’t the problem
Why you should not use SELECT *
A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we shouldn’t use SELECT *, which… Read More »Why you should not use SELECT *
Don’t do these things in SQL Server
Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored for a SQL Server audience.… Read More »Don’t do these things in SQL Server
Performance as a feature, software developer edition
Relational database management systems (RDBMS) like SQL Server and Azure SQL Database are very good at managing normalized data. Efficient storage and retrieval of data… Read More »Performance as a feature, software developer edition
Dates and Times in SQL Server: DATENAME()
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many similarities between DATEPART and DATENAME.… Read More »Dates and Times in SQL Server: DATENAME()
Dates and Times in SQL Server: DATEPART()
In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the specific part of a date… Read More »Dates and Times in SQL Server: DATEPART()
T-SQL aside: replace PRINT with RAISERROR
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in the proverbial forehead. I even… Read More »T-SQL aside: replace PRINT with RAISERROR
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed previously that some people have… Read More »Dates and Times in SQL Server: the problem with DATETIME
Dates and Times in SQL Server: more functions you should never use
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL Database using Transact-SQL (T-SQL). We… Read More »Dates and Times in SQL Server: more functions you should never use
Dates and Times in SQL Server: What about TIMESTAMP?
It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP is the Windows Millennium Edition… Read More »Dates and Times in SQL Server: What about TIMESTAMP?