[Video] Halloween Office Hours in Salem, MA
I visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is a great place to visit around Halloween! There were tours, characters in costume, witch gear shops, and all kinds of spooky-themed happenings. I sat dow …
Mastering a cloud migration: 10 video tips
The post Mastering a cloud migration: 10 video tips appeared first on SQLServerCentral.
Improve Query Performance when SQL Server Ignores Nonclustered Index
The post Improve Query Performance when SQL Server Ignores Nonclustered Index appeared first on SQLServerCentral.
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch execution mode works and how you can use it to get faster query results on rowstore data. We’ll go over the restrictions and the prerequisites fo …
Trigger the Execution of an ADF Pipeline from an Email
Introduction The problem statement is to execute a Data Factory Pipeline automatically every time an email is received with a predefined subject and an attachment file. The attachment file needs to be used in the Azure Data Factory Pipeline execution. …
Power Query Editor in Power BI for Formatting Text Columns
The post Power Query Editor in Power BI for Formatting Text Columns appeared first on SQLServerCentral.
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 …