The Black Friday Sale is Live!
You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the […]
Sites anglophones
Why Database Discussions Have Moved From the Backroom to the ...
The post Why Database Discussions Have Moved From the Backroom to the Boardroom appeared first on SQLServerCentral.
SQL Server Central Is Upgrading Our Servers
The Short Story We will be upgrading our systems on Thur, Nov 2, from around 930a GMT to […]
Using Pipeline Return Value in Azure Data Factory and Azure ...
Introduction In this article, we will talk about Azure Data Factory’s newly introduced Pipeline return value features. We […]
SQL Endpoints and Lakehouse UI Differences and Access Secrets
There are some differences and secrets between the UI of a SQL Endpoint and the UI of […]
[Video] Halloween Office Hours in Salem, MA
I visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is […]
Mastering a cloud migration: 10 video tips
The post Mastering a cloud migration: 10 video tips appeared first on SQLServerCentral.
Improve Query Performance when SQL Server Ignores Nonclustered Index
The post Improve Query Performance when SQL Server Ignores Nonclustered Index appeared first on SQLServerCentral.
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch […]
Trigger the Execution of an ADF Pipeline from an Email
Introduction The problem statement is to execute a Data Factory Pipeline automatically every time an email is received […]
Power Query Editor in Power BI for Formatting Text Columns
The post Power Query Editor in Power BI for Formatting Text Columns appeared first on SQLServerCentral.
Pike’s Market to Pikes Peak: The PASS Summit is Worth ...
Recently I spoke at SQL Saturday Denver. The day after the conference we went to visit Pikes […]
Announcing Buy-Now-Pay-Later, Just in Time for the Black Friday Sale!
It’s almost time for my annual Black Friday sale, and some of you are staring longingly at the […]
Database Projects for Microsoft Fabric Data Warehouse
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […]
Announcing My 2023 Black Friday Sale!
You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the […]
How We Ate Our Own Dog Food To Level-Up Internal ...
The post How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone appeared first […]
Top 10 Methods to Improve ETL Performance Using SSIS
The post Top 10 Methods to Improve ETL Performance Using SSIS appeared first on SQLServerCentral.
Announcing Live Online Mastering Classes!
In the last 2 years since I last taught my Mastering classes, the SQL Server performance tuning game […]
Exporting and Importing Data into SQL Server Using Files
There are plenty of applications and tools available that allow for the movement of data in and […]
Transform your Winning team into a Champion Team
Introduction The clearest illustration of the importance of a champion team occurred in the 2014 World Cup semifinal […]
The promise – and the perils – of GitHub Copilot
The post The promise – and the perils – of GitHub Copilot appeared first on SQLServerCentral.
Understanding Locking, Data Modification and Committing Data in SQL Server
The post Understanding Locking, Data Modification and Committing Data in SQL Server appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for October 2023
The last couple of releases have focused on running sp_Blitz with limited permissions, like not being able to […]
What Exactly Is a CTE in T-SQL? A Comprehensive Guide ...
Background A Common Table Expression (CTE) in T-SQL is like a versatile tool in the toolbox of a […]
Azure Databricks Tables – Delta Lake, Hive Metastore, TempViews, Managed, ...
The post Azure Databricks Tables – Delta Lake, Hive Metastore, TempViews, Managed, External appeared first on SQLServerCentral.
[Video] Office Hours: Back in the Vegas Home Studio
After a long trip through Scandinavia, I’m back in the desert. You posted questions at https://pollgab.com/room/brento and I […]
SQL ConstantCare® Population Report: Fall 2023
The short story for this quarter: SQL Server 2019 is on fire, dominating the market. For the long […]
What I Wish Everyone Knew About ETL Processes – Traditional ...
The post What I Wish Everyone Knew About ETL Processes – Traditional to Modern Cloud Solutions appeared first […]
Designing Databases for Distributed Systems
The post Designing Databases for Distributed Systems appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? October 2023 ...
Is your company hiring for a database position as of October 2023? Do you wanna work with the […]
Fundamentals Week is Coming. Every Day, the Price Goes Up.
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Don’t use DISTINCT as a “join-fixer”
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there […]
Explore Natively Compiled SQL Server Stored Procedure Execution Plans
The post Explore Natively Compiled SQL Server Stored Procedure Execution Plans appeared first on SQLServerCentral.
GIT Configuration and Automated Release for Azure Data Factory
Introduction Azure Data Factory resources including pipelines, datasets, linked services, etc. should be maintained in a version control […]
What Is Good Database Design?
The post What Is Good Database Design? appeared first on SQLServerCentral.
SQL Server Security Primer
SQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it […]
The SQL Developer Experience: Beyond RDBMS
SQL Server has always empowered developers through a wide variety of drivers, the robust T-SQL language, and an […]
Integrating Python with MongoDB
Introduction MongoDB has gained significant popularity as a NoSQL database solution due to its flexibility, scalability, and document-oriented […]
New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries
The post New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries appeared first on SQLServerCentral.
A Beginners Guide To MySQL Replication Part 6: Security Considerations ...
This article is part of Aisha Bukar’s 6 part series: A Beginners Guide to MySQL Replication. The […]
[Video] Office Hours with a Surprise Special Guest
I have a special guest star on today’s episode: Pinal Dave dropped by the house! We went through […]
[Video] Office Hours at the Northernmost Town in the World
Despite its location, Hammerfest, Norway attracts countless tourists eager to see the festival celebrating one of the world’s […]
Parsing a Pairs of Values in a String While Preserving ...
Introduction In a project I’m currently working on, I need to modify a stored procedure that returns a […]
Well, I’m Not Doing SQLBits After All.
I was so excited when SQLBits announced their 2024 dates & location, and I told y’all that I […]
PostgreSQL Indexes: What They Are and How They Help
In the previous blog in this series, we learned how to produce, read and interpret execution plans. […]
Alternatives To SQL Server 2022 Built-in function GREATEST
The post Alternatives To SQL Server 2022 Built-in function GREATEST appeared first on SQLServerCentral.
SQL Athena Introduction – How it works, Use Cases and ...
The post SQL Athena Introduction – How it works, Use Cases and Advantages appeared first on SQLServerCentral.
The Basics of Using GENERATE_SERIES()
First, SQL Server 2022 has many interesting new features for both DBAs and database developers. GENERATE_SERIES is one […]
Using SQLite with Flutter
Storing, retrieving, and modifying data are common tasks in many applications. In a cross-platform application, it is important […]
Power BI Workspace Permissions and Roles
The post Power BI Workspace Permissions and Roles appeared first on SQLServerCentral.