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 […]
Sites anglophones
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.
Different Ways to Populate the List of Tables
A database administrator has various tasks and responsibilities. Managing and keeping track of the database is one of […]
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 […]
[Video] Office Hours at the Arctic Circle
Just after passing the Arctic Circle marker and celebrating with a glass of champagne, I took your top-voted […]
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
[Video] Office Hours Off the Coast of Norway
Come join me in my cabin aboard the Hurtigruten Nordlys, sailing up the coast of Norway, and we’ll […]
Something’s Up with Parallelism in Azure SQL DB Serverless
Or perhaps another way to phrase that is, Microsoft is up to something with parallelism. I don’t know […]
SQL Server Row Level Security Deep Dive. Part 6 ...
As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. […]
Normalize strings to optimize space and searches
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. […]
Which of These Azure Courses Would You Attend?
A member of the community (no, it’s not me) is thinking about offering a live training course and […]
Getting Started with Power Query M Language in Excel
The post Getting Started with Power Query M Language in Excel appeared first on SQLServerCentral.
Sentiment Analysis with IA
Introduction In this article, we will do sentiment analysis of text stored in SQL Server with comments about […]
PostgreSQL 101: A guide to PostgreSQL documentation & useful resources
In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant […]