[Video] Office Hours: Holiday Speed Round
Beep beep! Here’s a speed round of Office Hours where I rip through a dozen questions in under ten minutes. Want to see your own questions answered? Post ’em and upvote the ones you like at https://pollgab.com/room/brento. 00:00 Start 00:22 …
SQL ConstantCare® Population Report: Winter 2022
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the winter 2022 version of our SQL Const …
Executing Optional Code in Flyway Callbacks
The post Executing Optional Code in Flyway Callbacks appeared first on SQLServerCentral.
[Video] Office Hours: Ham Pillow Edition
Y’all post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss, and then I artfully dodge giving you answers. At least, that’s how it feels sometimes, hahaha: Here’s what we discussed in …
The Lock Escalation Threshold – Part 3
The post The Lock Escalation Threshold – Part 3 appeared first on SQLServerCentral.
Building a SQL Computational Framework for MACD Indicators
The post Building a SQL Computational Framework for MACD Indicators appeared first on SQLServerCentral.
Flyway Desktop in Database Development Work: An Overview
The post Flyway Desktop in Database Development Work: An Overview appeared first on SQLServerCentral.
Heapq Module in Python: Using Heaps and Priority Queues
The post Heapq Module in Python: Using Heaps and Priority Queues appeared first on SQLServerCentral.
Should You Use SQL Server 2022’s GREATEST and LEAST?
If you’ve been following along with this week’s posts on DATETRUNC and STRING_SPLIT, you’re probably going to think the answer is no, but bear with me. It’s Christmas week, right? The news can’t all be bad. GREATEST and LE …
Should You Use SQL Server 2022’s STRING_SPLIT?
SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that’s the only thing they improved – there’s still a critical performance problem with it. Let’s ta …
Maintaining a Utilities Schema in a Flyway Project
The post Maintaining a Utilities Schema in a Flyway Project appeared first on SQLServerCentral.
The Mentoring Class of 2023
(Meeps, one of our seven cats, helping with the selection process…) Since my first round of community mentoring back in 2015, when I mentored 54 people for six months, I’ve been asked periodically whether I’d do it again. My answer was always som …
Should You Use SQL Server 2022’s DATETRUNC?
SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example:SELECT DATETRUNC(year, ‘2017-06-01’); Truncates everything in that date other than the year, so it returns just 2017-01-01 00:00: You might ask, …
SQL Server 2022: How Auto-Drop Statistics Work
Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table structure is not blocked by the presence of the statistic. An auto-created statistics is also dropped automatic …
Resolving to Write in the New Year
It is almost New Year’s Day, that time when the optimistic at heart start thinking about making changes in their life on that magical day that ends the year. After the glorious gluttony-fest that has only recently ended in many cultures, it does …