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 …
Artificial Intelligence with Power BI
Executive Summary Artificial intelligence is transforming businesses across the world. There are several tools and technologies to realize the benefits of AI efficiently and effectively. However, one software package that most organizations already hav …
SSIS Bad Habits: Decreasing SSIS Package Performance
The post SSIS Bad Habits: Decreasing SSIS Package Performance appeared first on SQLServerCentral.
Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back
The post Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back appeared first on SQLServerCentral.
Deploy and Configure Azure SQL Managed Instance
The post Deploy and Configure Azure SQL Managed Instance appeared first on SQLServerCentral.
How to create a Power BI report using REST API data
Introduction In this article, we will learn how to create a Power BI report using a REST API. REST API is an Application Program Interface that uses HTTP requests to get data. Usually, the data is sent in JSON format. For example, you can use REST API …
[Video] Office Hours: Great Questions, Part 2
Every time I think, “There can’t be any more SQL Server questions left,” y’all post more great ones at https://pollgab.com/room/brento! Here’s what we covered: 00:21 MattC: Hi Brent. Have you check out ChatGPT’s abil …
Updated First Responder Kit and Consultant Toolkit for December 2022
Santa’s elves took a break from building toys and shipped a new version of the First Responder Kit. There are some great improvements in here, like a makeover for sp_BlitzLock and much better PSPO compatibility for sp_BlitzCache. Wanna watch me u …
Reviewing SQL Migration Files Before a Flyway Migration
The post Reviewing SQL Migration Files Before a Flyway Migration appeared first on SQLServerCentral.