Database Projects for Microsoft Fabric Data Warehouse
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC (Software Development Life Cycle). Microsoft released the Database Projects around 2010 and have they evolved since that year. The original name was a tool ca …
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 blog regularly, subscribed to the free newsletter, watched some of my YouTube videos, maybe even watched me on Twitch or followed me on Instagram. …
How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone
The post How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone appeared first on SQLServerCentral.
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 has changed a lot! SQL Server 2019 has achieved widespread adoption, meaning more of your servers have access to more tuning tools SQL Server 2019 has …
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 out of SQL Server. Some tools are built by Microsoft, such as SSIS or Azure Data Factory. Others are created by third parties, such as Databricks or Snowfla …
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 soccer match between Brazil and Germany. The 2014 World Cup was won by Germany, and Brazil lost heartbreakingly in the semifinals. Acco …
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 see inside some user databases. Those efforts continue this month with a lot of work from Montro1981. Wanna watch me use it? Take the class. T …
What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples
Background A Common Table Expression (CTE) in T-SQL is like a versatile tool in the toolbox of a SQL developer. It’s a way to create a temporary result set that you can reference within a larger SQL statement. Think of it as a query-within-a-query that …
Azure Databricks Tables – Delta Lake, Hive Metastore, TempViews, Managed, External
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 took the hot seat: Here’s what we covered today: 00:00 Start 03:15 Marek: Hi Brent, what is the best solutio …
SQL ConstantCare® Population Report: Fall 2023
The short story for this quarter: SQL Server 2019 is on fire, dominating the market. For the long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? …
What I Wish Everyone Knew About ETL Processes – Traditional to Modern Cloud Solutions
The post What I Wish Everyone Knew About ETL Processes – Traditional to Modern Cloud Solutions appeared first on SQLServerCentral.