Changing log growth strategy in SQL Server 2022

When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for log file growth,...

Aaron Bertrand in T-SQL Programming

One use case for NOT using schema prefixes

I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.…

Aaron Bertrand in T-SQL Programming

I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal...

Aaron Bertrand in Featured

I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data...

Aaron Bertrand in T-SQL Programming

I’ve been at this for a while now, and have a very particular set of rules and coding conventions that...