Sites anglophones


Efficient Table Migration to a New Schema in T-SQL

Publié le 3 novembre 2023 sur sqlservercentral.com
 

Introduction Efficiently migrating tables to a new schema in T-SQL is a common task for database administrators and developers. Whether you’re reorganizing your database structure, improving security, or simply enhancing organization, understanding the …

SQL Server Fragmentation Impact with Modern Hardware

Publié le 3 novembre 2023 sur sqlservercentral.com
 

The post SQL Server Fragmentation Impact with Modern Hardware appeared first on SQLServerCentral.

Microsoft at the PASS Data Community Summit 2023

Publié le 3 novembre 2023 sur sqlservercentral.com
 

It’s gearing up to be an exciting week November 14th – 17th as we prepare for this year’s Microsoft Ignite and PASS Data Summit all happening at once! While across the way we’ll be sharing the latest from Microsoft all up, taking place at the Conventio …

The Black Friday Sale is Live!

Publié le 1 novembre 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. …

Why Database Discussions Have Moved From the Backroom to the Boardroom

Publié le 1 novembre 2023 sur sqlservercentral.com
 

The post Why Database Discussions Have Moved From the Backroom to the Boardroom appeared first on SQLServerCentral.

SQL Server Central Is Upgrading Our Servers

Publié le 1 novembre 2023 sur sqlservercentral.com
 

The Short Story We will be upgrading our systems on Thur, Nov 2, from around 930a GMT to 1000a GMT. We do not anticipate much downtime, but there will be a short period where a the site will be behind a maintenance page. The Longer Story We have been r …

Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics

Publié le 1 novembre 2023 sur sqlservercentral.com
 

Introduction In this article, we will talk about Azure Data Factory’s newly introduced Pipeline return value features. We can return value from a pipeline using the Set Variable Activity and retrieve the value in another pipeline using the Execute pipe …

 

SQL Endpoints and Lakehouse UI Differences and Access Secrets

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

There are some differences and secrets between the UI of a SQL Endpoint and the UI of a Lakehouse. I believe the lakehouse UI was changed recently, otherwise you can blame me for being distracted to this level. Let’s analyze the differences and p …

 

[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 …

 


Pages :