Free Webcast: How to Think Like the Engine, Live
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it works, how SQL Server and Azure SQL DB turn your queries into results. You know there are execution plans, but … you’re u …
Who’s Hiring in the Microsoft Data Platform Community? November 2023 Edition
Is your company hiring for a database position as of November 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must i …
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 …