DataOps for Power BI
Have you ever overwritten a Power BI report in the service before realizing that you haven’t edited the latest version of it? I think this has happened a few times to all But why? Let’s mention some inherent particularities to the product: …
The Importance of a Good Data Model in Power BI Desktop
The post The Importance of a Good Data Model in Power BI Desktop appeared first on SQLServerCentral.
T-SQL Language Changes in SQL Server 2022 Part 3
SQL Server 2022 is in preview and I wrote a previous article on the T-SQL language changes. This article is a second part, covering a few more of the changes in T-SQL that are coming with this new version of the database platform. The first article loo …
Secure File Transfer Protocol (SFTP) support for Azure Blob Storage
The post Secure File Transfer Protocol (SFTP) support for Azure Blob Storage appeared first on SQLServerCentral.
Enabling digital transformation – and data modernization – with DevOp
The post Enabling digital transformation – and data modernization – with DevOp appeared first on SQLServerCentral.
[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 …