BLOG

sql bits logo
Why You Should Attend SQLBits 2025
SQLBits is undoubtedly one of the best events for the Data Community. Whether you’re looking to deepen your knowledge, expand your professional network, or simply have a great time away from the office,...
A man standing on a mountain looking at the sunset
10% off Brent Ozar’s Black Friday Sale!
Take Your SQL Server Skills to the Next Level with Brent Ozar’s Black Friday Sale! Brent Ozar is running his annual Black Friday sale all November, and I’m excited to offer you an additional 10% discount...
Random colourful lines
Insert rows faster using explicit transactions
When working with SQL Server, there are times when we need to insert a large number of rows into a table. This might be to populate test data in a non-production environment or to pre-load a new table...
A calendar on a shelf
Tuning Date Range Queries
SQL Server has been around for many years and does a pretty good job of optimising queries. While there are ways we can help enhance performance, there are also plenty to inadvertently degrade it. A common...