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, …
Server Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can custom …
Adding a new AI usage policy to Simple-Talk
I used to think plagiarism was my worst thing to deal with as an editor. That is only sort of true now. Now the biggest headache has become figuring out who has used AI to do their writing and to what extent. Often that is even less easy than it even s …
What PowerBI Questions Do You Have for Eugene Meidinger?
Eugene Meidinger, aka SQLGene.com, makes Power BI concepts easy and accessible. He’s got a free introduction to Power BI performance tuning here. People come to him with questions like: What kind of tools are there for performance tuning Power BI …
State of the Database Landscape 2024: Shifting skills to match constant demands
The post State of the Database Landscape 2024: Shifting skills to match constant demands appeared first on SQLServerCentral.
Django's ORM vs. Raw SQL: When to Use Which
When it comes to building websites, how you work with your database can make a huge difference in how well your site runs. That’s especially true if you’re using Django, a popular tool for making websites with Python. Django comes with something called …
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data available in Microsoft Fabric. This allows the data to be used in lakehouses or data warehouses. One major question that arises is, …
Query Exercise: Find Tagged Questions Faster.
For this week’s Query Exercise, we’re going to start with an existing query that has performance problems from time to time, depending on how it’s used. This query’s goal is to find the top-voted Stack Overflow questions for any …
Finding the Best Time for Maintenance: Answers & Discussion
Your Query Exercise was to find the best time to do database maintenance by querying the Users table, looking for a one-hour window with the lowest number of created users. We kept this one pretty simple by looking at the data in just one table, and we …