Azure Function and User Assigned Managed Identities
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity. When we build Azure functions, they usually need …
Announcing the 2023 Data Professional Salary Survey Results.
Are your peers being paid more this year? Are they switching job roles? Are they planning on leaving their companies? To find out, I run a salary survey every year for folks in the database industry. Download the raw data here and slice & dice ’em …
Who’s Hiring in the Microsoft Data Platform Community? January 2023 Edition
Was your New Year’s resolution to get a new job? Heads up: the comments in this post are for you. Is your company hiring for a database position as of January 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up …
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.