Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds,… Read More »Dates and Times in SQL Server: SMALLDATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and… Read More »Dates and Times in SQL Server: DATETIME
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because MySQL is predominantly used for… Read More »MySQL has this feature that SQL Server needs
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to CAST or CONVERT a datetime2… Read More »Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available on every version of Linux,… Read More »Microsoft presents: MySQL and PostgreSQL?
Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to select, insert, update, and delete… Read More »Acids and Databases: A look at ACID and transactions