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.
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 Edition
Is your company hiring for a database position as of October 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must in …
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 Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watchi …