Don’t Just Chase the Shiny
Fish are beautiful creatures, but they have one minor issue. The main thing I remember from the years I fished is that fish can be susceptible. If you have a fishing lure that shows off with a bright, colorful, shiny appearance that splashes around jus …
How to Find Missing Rows in a Table
When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table: It has Ids -1, 1, 2, 3, 4, 5 … but no 6 or 7. (Or 0.) If …
The SQL Server Posts You Read the Most in 2022
Here’s what I wrote in 2022 that gathered the most views: #10: Who’s Hiring in the Database Community? February 2022 Edition – I saw the success of Hacker News’ “Who’s Hiring” monthly posts, and I blatantly sto …
Setting up for Team-based Database Development using Flyway Desktop
The post Setting up for Team-based Database Development using Flyway Desktop appeared first on SQLServerCentral.
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.