Pike’s Market to Pikes Peak: The PASS Summit is Worth the Journey
Recently I spoke at SQL Saturday Denver. The day after the conference we went to visit Pikes Peak Mountain. You have a couple of choices of how you can get to the top of Pikes Peak Summit: hike, drive, or take the Cog railway. Each method has its own a …
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 deals. You don’t get a training budget at work, so anything you invest in your own career has to come out of your own pocket. That kinda sucks, b …
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 …