#TSQL2sday Roundup: The Most Recent Issues You Closed.
For this month’s TSQLTuesday, I asked y’all to describe the most recent issues you closed. If you ask […]
Sites anglophones
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. […]
Tutorial: Using the hierarchyid Data Type
The post Tutorial: Using the hierarchyid Data Type appeared first on SQLServerCentral.
[Video] Office Hours: Ask Me Anything About Microsoft Databases
Post your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the […]
JQ – Tool for Querying JSON documents using the CLI
In my role as a Data Engineer, I have an ever-increasing need for Querying JSON documents using the […]
Functions and Procedures: Learning PostgreSQL with Grant
One of the most useful constructs in SQL Server is the stored procedure. It gives you a […]
Query Exercise: Finding Long Values Faster
Our developers have come to us with a problem query that isn’t as fast as they’d like. Using […]
Improving Cardinality Estimation: Answers & Discussion
Your challenge for last week was to take this Stack Overflow database query to show the top-ranking users […]
Attention SQLBits 2024 Attendees!
Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote […]
Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, ...
The post Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more appeared first on […]
The Last Ticket/Issue I Closed #TSQL2sday
For this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that […]
SQL ConstantCare® Population Report: Winter 2023
The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. […]
Leave it better than you found it
This is for the folks who still have to log into remote machines and do work manually […]
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting […]
Planning a Database Testing Strategy for Flyway
The post Planning a Database Testing Strategy for Flyway appeared first on SQLServerCentral.
Automating BCP with PowerShell
I was talking with a good friend that has an environment with terabytes of information and to […]
[Video] Office Hours: Lumberjack Edition
On a chilly January day, I went through your top-voted questions from https://pollgab.com/room/brento. Yes, it actually gets cold […]
Fun with Powershell
The post Fun with Powershell appeared first on SQLServerCentral.
Use a Table Variable for Logging Entries that Need to ...
Introduction Table variables are special types of local variables that can be used to store data temporarily, similar […]
LangChain Prompt Templates with OpenAI LLMs
The post LangChain Prompt Templates with OpenAI LLMs appeared first on SQLServerCentral.
Query Exercise: Improving Cardinality Estimation
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows […]
Database Changes to Find Tagged Questions Faster: Answers and Discussion
In the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find […]
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, […]
#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 […]
Resolving the MERGE statement attempted to UPDATE or DELETE the ...
The post Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error […]
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 […]
Fixing the Synapse Error « Available workspace capacity exceeded error (Livy ...
If you are working with Notebooks in Azure Synapse Analytics and multiple people are using the same Spark […]
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 […]
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 […]
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 […]
Who’s Hiring in the Microsoft Data Platform Community? February 2024 ...
Is your company hiring for a database position as of February 2024? Do you wanna work with the […]
Feature Flags in Data Projects
My motivation for writing this summary was an interaction with a project owner that didn’t understand why […]
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 […]
Gracefully Handle Errors using TRY CATCH Logic in SQL Server ...
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
State of the Database Landscape 2024: Shifting skills to match ...
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 […]
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 […]
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 […]
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, […]
Code Visibility: Browsing through Flyway Migration Files
The post Code Visibility: Browsing through Flyway Migration Files appeared first on SQLServerCentral.
Save 5% on SQLBits Registration with BRENT5.
Going to the SQLBits conference in March? Whether you’re registering in-person or attending virtually, save 5% on your […]
State of the Database Landscape Results 2024
Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This […]
Querying MongoDB Documents
MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […]
Understanding the Importance of Data Lineage in Modern Data Management
The post Understanding the Importance of Data Lineage in Modern Data Management appeared first on SQLServerCentral.