Sites anglophones


[Video] Halloween Office Hours in Salem, MA

Publié le 30 octobre 2023 sur brentozar.com
 

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

Publié le 30 octobre 2023 sur sqlservercentral.com
 

The post Mastering a cloud migration: 10 video tips appeared first on SQLServerCentral.

Improve Query Performance when SQL Server Ignores Nonclustered Index

Publié le 30 octobre 2023 sur sqlservercentral.com
 

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

Publié le 30 octobre 2023 sur sqlservercentral.com
 

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

Publié le 27 octobre 2023 sur sqlservercentral.com
 

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

Publié le 27 octobre 2023 sur sqlservercentral.com
 

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

Publié le 26 octobre 2023 sur simple-talk.com
 

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!

Publié le 26 octobre 2023 sur brentozar.com
 

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

Publié le 25 octobre 2023 sur simple-talk.com
 

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!

Publié le 25 octobre 2023 sur brentozar.com
 

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

Publié le 25 octobre 2023 sur sqlservercentral.com
 

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

Publié le 25 octobre 2023 sur sqlservercentral.com
 

The post Top 10 Methods to Improve ETL Performance Using SSIS appeared first on SQLServerCentral.

Announcing Live Online Mastering Classes!

Publié le 24 octobre 2023 sur brentozar.com
 

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

Publié le 23 octobre 2023 sur simple-talk.com
 

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

Publié le 23 octobre 2023 sur sqlservercentral.com
 

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 …


Pages :