Storm Ciaran Analysis with Microsoft Fabric
Always looking for Open Source data to highlight the capabilities of Microsoft Analytics solutions, I have: In 2013, analyzed the number of travelers boarding Transiliens station: Power Query & Power BI In 2015, wrote an article on the analysis of …
Analyse de la tempête Ciaran avec Microsoft Fabric
Toujours à la recherche de données Open Source afin de mettre en exergue les capacités des solutions Analytics Microsoft, j’ai : – En 2013, analysé le nombre de voyageurs montant en gare des Transiliens : Power Query & Power BI – En 20 …
Moving SQL Server To The Cloud: Modernizing Stack Overflow for Teams
Earlier this year, we migrated the entire Stack Overflow for Teams platform to Azure. This was a lengthy endeavour and Wouter de Kort, one of our core engineers, wrote about multiple technical aspects of the project in these posts: Journey to the cloud …
SQL Server and Python Tutorial
Introduction In this article, we will see how to connect SQL Server with Python using the pyodbc library. If you are a SQL DBA, we strongly recommend running Python scripts in SSMS. However, we have some Python developers who want to work with Python d …
Five database DevOps practices for boosting team productivity
The post Five database DevOps practices for boosting team productivity appeared first on SQLServerCentral.
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 …