Dimensional Modeling Case Study Part 2 – Days Dimension
Introduction In our second case study on dimensional modelling, we delve into the intricacies of managing time-related dimensions, focusing specifically on the « days » dimension. Unlike the date dimension, where each row signifies a specific point in ti …
#TSQL2sday Invitation: Describe the Most Recent Issue You Closed.
T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting this month’s episode. Your readers wonder what kinds of jobs are out there in the database world, what exactly it is that you do, and …
Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error
The post Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error appeared first on SQLServerCentral.
Announcing the first Microsoft Fabric Community Conference!
We are excited to welcome attendees to the 1st Microsoft Fabric Community Conference (previously known as the Data & AI Conference). This event will bring together community experts, Microsoft leaders, and engineers and it’s happening soon! Worksho …
Fixing the Synapse Error « Available workspace capacity exceeded error (Livy session) »
If you are working with Notebooks in Azure Synapse Analytics and multiple people are using the same Spark cluster at the same time then chances are high that you have seen any of these below errors: « Livy Session has failed. Session state: error code: …
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templa …
Adding an AI Policy for Authors
In the last few months, we’ve noticed quite a bit of content submitted that seems overly structured in certain ways. I collaborate with Louis Davidson at Simple Talk, and he’s seen similar issues. With some research and checking, we both concluded that …
Office Hours: PowerBI & Fabric Q&A with Eugene Meidinger
Today’s Office Hours has a different topic. Eugene Meidinger dropped by to answer your business intelligence questions. Follow Eugene on YouTube and TikTok Subscribe to his 5-link weekly newsletter Check out Eugene’s new Power BI classes Re …
Who’s Hiring in the Microsoft Data Platform Community? February 2024 Edition
Is your company hiring for a database position as of February 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 i …
Feature Flags in Data Projects
My motivation for writing this summary was an interaction with a project owner that didn’t understand why we couldn’t use feature flags directly in Power BI to control the user interface. This was different from our other deployments, so it …
Finding Tagged Questions Faster: Answers & Discussion
Your query exercise was to take this Stack Overflow query to find the top-voted questions for any given tag:SELECT TOP 100 * FROM dbo.Posts WHERE Tags LIKE ‘%<sql-server>%’ ORDER BY Score DESC; That’s currently using this index in its execu …
Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures
The post Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures appeared first on SQLServerCentral.
Install SSMS using Powershell DSC
Introduction In the previous article, we have seen how to install the SQL Server database engine using Powershell DSC with multiple configurations. We have covered setting up service account credentials, custom installation directories, configuring Tem …
Free Video Training: Estimation and Statistics by Dave Ballantyne
It’s hard to find good 400-500 level SQL Server training at any price, let alone free. Dave Ballantyne’s past sessions from SQLBits are great examples of those. Today, I’m going to review Dave’s most recent session on Estimation …
Lancement de la chaine YouTube Data Chouette
Nous avons démarré une nouvelle chaîne YouTube pour les passionnés de données : https://www.youtube.com/@DataChouette Apprenez, explorez et découvrez le monde fascinant des données avec des experts passionnés de la Data L’idée est de vulgariser, …