Sites anglophones


Creating a Date Dimension (Calendar Table) in SQL Server

Publié le 14 avril 2025 sur sqlservercentral.com
 

Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to perform operations like calculating business days between two dates or analyzing data over time (e.g., year-over-year, month-to-month). In …

The Waitlist is Open Now for My SQLBits Workshop!

Publié le 13 avril 2025 sur brentozar.com
 

I’m excited to return to London for SQLBits again this year! I’ve written about why SQLBits is my favorite conference, and it’s hard to believe it’s been over a decade since I wrote that post. I still feel the same way about Bit …

The complexity of using Power BI in US Sovereign Clouds

Publié le 11 avril 2025 sur sqlservercentral.com
 

The post The complexity of using Power BI in US Sovereign Clouds appeared first on SQLServerCentral.

Elements of the SQL Server Update Statement

Publié le 11 avril 2025 sur sqlservercentral.com
 

Introduction This article explores a very common construct in standard SQL and Transact-SQL – the SQL Server Update Statement. The standard SQL language as defined in the original standard is composed of just a few declarative commands. SQL is describe …

[Video] Office Hours in North Bay, Canada

Publié le 10 avril 2025 sur brentozar.com
 

Every year, Aaron Bertrand runs a curling tournament up in scenic North Bay where he grew up. I joined in this year, and before the tournament, sat on the shores of Lake Napissing to answer your top-voted questions from https://pollgab.com/room/brento. …

 

Working with MongoDB Shell

Publié le 10 avril 2025 sur simple-talk.com
 

This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Throughout this series, I’ve provided a number of examples of how to run commands in MongoDB Shell (mongosh). However, the exampl …

 

Tap Tap Tap – Short, Silent SQL Server Tutorials

Publié le 9 avril 2025 sur brentozar.com
 

One of the things I love about TikTok is that it exposes me to wildly new video ideas like this: @tiipititap ? original sound – tiipititap There’s a whole genre of videos in that style – people using tapping plastic pointer fingers on …

Killing a SPID and Checking Rollback progress in SQL Server

Publié le 9 avril 2025 sur sqlservercentral.com
 

The post Killing a SPID and Checking Rollback progress in SQL Server appeared first on SQLServerCentral.

Free Webcast: Avoiding Deadlocks by Query Tuning

Publié le 8 avril 2025 sur brentozar.com
 

Deadlocks used to scare me. I’d get the alert from a monitoring tool, and I’d look around to see if anyone was watching me. If the coast was clear, I’d… delete the notification. Deadlocks were a mystery to me because I didn …

 

Data Elements on a Nominal Scale

Publié le 8 avril 2025 sur simple-talk.com
 

“On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan on a T-shirt This is one of my favorite T-shirt gags because it teaches something about data types, scales and measurements. When you hear it, you automaticall …

 

Free Webcast Tomorrow: Fundamentals of Columnstore

Publié le 7 avril 2025 sur brentozar.com
 

It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m teaching Fundamentals of Columnstore, and we’re going to be covering the internals o …

Navigating Your Test Data Challenges: Insights and Solutions

Publié le 7 avril 2025 sur sqlservercentral.com
 

The post Navigating Your Test Data Challenges: Insights and Solutions appeared first on SQLServerCentral.

Introduction to GitHub Actions Part 1: Getting Started

Publié le 7 avril 2025 sur sqlservercentral.com
 

The post Introduction to GitHub Actions Part 1: Getting Started appeared first on SQLServerCentral.

Understanding UNION and UNION ALL in SQL Server

Publié le 7 avril 2025 sur sqlservercentral.com
 

Have you ever needed to combine data from two different tables or queries in SQL Server? Maybe you’ve got similar data sitting in different places and you want to see all the unique values, or maybe you want to see everything, even the repeats.  UNION …

DAX CASE Statement Functionality using IF, SWITCH and SWITCH True

Publié le 4 avril 2025 sur sqlservercentral.com
 

The post DAX CASE Statement Functionality using IF, SWITCH and SWITCH True appeared first on SQLServerCentral.


Pages :