Database Projects for Microsoft Fabric Data Warehouse
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC […]
Archives de l’année : 2023
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 […]
Utiliser les indicateurs de requêtes pour aider l’optimiseur
Arian Papillon, @Datafly , MVP L’optimiseur de SQL Server décide du meilleur plan d’exécution et il s’en […]
Faire cohabiter le décisionnel et le Transactionnel dans SQL Server
Amar Adghar, Microsoft et Julien Pierre, Microsoft Le but de cette session est de comprendre les principes […]
Migrer un groupe de disponibilité AlwaysOn sans perte du cluster
Stéphane Scherrer, Microsoft et Sylvain Pagès, Devoteam – Comment migrer un Cluster WSFC et AlwaysOn AG sans […]
La gestion des droits dans SQL Server
Sébastien Kobenan @azuredataarchitect5612 Lorsqu’on débute sur SQL Server, on est souvent perdu dans la gestion des permissions. […]
SQL Server Hybride Azure
Stéphane Scherrer, Microsoft et Richard Prade, Microsoft Même si vous voulez garder les données chez vous, l’hybridation […]
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 […]
SQL Server 2022 Common Criteria EAL4 Certification
After SQL’s first Common Criteria (CC) certification of version 2005 (Yukon), SQL Server 2022 (SQL22) is the […]
Cumulative Update #23 for SQL Server 2019 RTM
The 23rd cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Cumulative Update #9 for SQL Server 2022 RTM
The 9th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
Conférence Datafrogs 14 octobre 2023
Samedi 14 octobre à 14h45, j’aurai le plaisir de présenter une sessions sur les « Query Hints » ou « Indicateurs […]
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 […]
Visual Studio 2022 17.8 Preview 3
Microsoft vient de publier Visual Studio 2022 17.8 Preview 3. Une mouture dédiée au traitement des commentaires […]
Security Update for SQL Server 2022 RTM CU8
The Security Update for SQL Server 2022 RTM CU8 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2019 RTM CU22
The Security Update for SQL Server 2019 RTM CU22 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2019 RTM GDR
The Security Update for SQL Server 2019 RTM GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2017 RTM GDR
The Security Update for SQL Server 2017 RTM GDR is now available for download at the Microsoft Download […]
[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 […]