I Must Be an Idiot: Automatic Tuning Never Works for Me.
The post I Must Be an Idiot: Automatic Tuning Never Works for Me. appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? September 2024 Edition
Is your company hiring for a database position as of September 2024? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must …
Solving the Overlap Query Problem in PostgreSQL
Range queries are a very common task in SQL: selecting dates, numbers, or even text values that fall within some specified range. For instance: all loan applications for the month of March, or all sales transactions between $50 and $500. SQL developers …
How to Slice Data by Fiscal Month using DAX for Power BI Reports
The post How to Slice Data by Fiscal Month using DAX for Power BI Reports appeared first on SQLServerCentral.
Choosing Data Types and Column Options
An entire post on choosing the correct data types either seems like overkill or much needed and overdue. The perspective might vary based on the databases you’ve worked with recently. I decided to write this after seeing some code with data type decisi …
MySQL Index Overviews: Composite B-Tree Indexes
Indexes in MySQL are one of the primary ways to enhance query performance and they are especially useful when the primary use case of our project refers to reading data stored in a database. We‘ve already told you about the nuanced world of indexes in …
Microsoft Fabric: Using Lakehouse data in Real Time Dashboards
The post Microsoft Fabric: Using Lakehouse data in Real Time Dashboards appeared first on SQLServerCentral.
Is it still worth it to sponsor PASS Summit?
The post Is it still worth it to sponsor PASS Summit? appeared first on SQLServerCentral.
[Video] Office Hours: Abrupt Intro Edition
Today’s Office Hours had a ton of technical difficulties because it was my first live stream on both Twitch and TikTok. The first few minutes were cut off, and you can’t see the questions onscreen. Nonetheless, there are good answers in her …
The Big IT Outage: Where are we going?
As you all know about, just a few weeks ago we had the big CrowdStrike global IT outage. Some lucky IT guys like me had it in double: Microsoft was also suffered an outage in North Europe on the same week. I have worked in IT for more years than I can …
Query Exercise Answers: Solving the 201 Buckets Problem
In this week’s Query Exercise challenge, I explained SQL Server’s 201 buckets problem. SQL Server’s statistics only handle up to ~201 outliers, which means that outliers ~202-300 get wildly inaccurate estimates. In our example, I had …
Bad Data and Dirty Databases
Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under the title, “Don’t Warehouse Dirty Data!” It’s been referenced quite a few times over the decades but is nowhere to be found using Google these d …
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
The post Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level appeared first on SQLServerCentral.
Is your DevOps strategy missing a vital link?
The post Is your DevOps strategy missing a vital link? appeared first on SQLServerCentral.
About Half Of You Don’t Have Your Databases Under Control.
I ran a poll over on LinkedIn to find out if people have 100% of their databases under some kind of source control or version control. I broke the answers up into two sets, developers and non-developers, because I had a hunch that the developers’ …