Building Visual Calendars with SQL and CSS – Part 3
In the final part of this series, I convert my T-SQL code to MySQL, so you can build a fancy archives page in WordPress.
Yearly Archive: 2023
Simulating TRY_PARSE in SQL Server 2008
Certainly not to encourage people to stay on ancient versions if they don't have to, I took a crack at replicating TRY_PARSE on older versions.
Regular SQL Server on Apple Silicon? Yes you can!
I show that a new experimental feature in Docker 4.16+ lets you run "real" SQL Server on Apple M1+ chips.
Find 40 Problems in this Stored Procedure
For my first post on Simple Talk, I rip apart a made-up stored procedure as if I had encountered it during a code review.
Building Visual Calendars with SQL and CSS – Part 2
In the second part of this series, I show how to use a calendar table to simplify rendering an archives page.
A Minor Bandwidth Upgrade
I recently added a switch and an adapter to take much better advantage of AT&T's 5-gig service.
February 2023 : Many updates for SQL Server
A good round of updates for most modern versions of SQL Server, including the first cumulative update for SQL Server 2022.
Building Visual Calendars with SQL and CSS – Part 1
I started a short series on building visual calendars, like those seen in the monthly archives page here.
Protecting personal information in the GDPR era
I discuss an organization’s responsibility for protecting personal information.
T-SQL Tuesday #158 : Worst Practices
For T-SQL Tuesday #158, I talk about a couple of justifiable worst practices.
And then there were shirts…
The story behind new SQLBlog-branded clothing (with proceeds going to The Trevor Project and Black Lives Matter).