Creating an Azure PostgreSQL cluster and connecting to it
One of the technologies that my new job brought with it was learning about all the various database platforms that are not Microsoft SQL Server. Not that I don’t still spend time learning about SQL Server, as it will happily remain one of our lar …
Getting connected to PostgreSQL for the first time
PostgreSQL continues to be all the rage in 2023, whether in “vanilla” form of the fully open-source distribution or a variant like Amazon RDS, Neon, Yugabyte, and others. If you’re interested in trying PostgreSQL but only have experie …
Efficient Table Migration to a New Schema in T-SQL
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
The post SQL Server Fragmentation Impact with Modern Hardware appeared first on SQLServerCentral.
Microsoft at the PASS Data Community Summit 2023
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!
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
The post Why Database Discussions Have Moved From the Backroom to the Boardroom appeared first on SQLServerCentral.
SQL Server Central Is Upgrading Our Servers
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
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
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
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. …