Fabric Data Warehouse News you need to know
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here I’m summarizing the most recent news I looked at. Clone Table We have a specific statement to clone a table. But what exactly does it mean …
[Video] Office Hours: Yes, I’m In the Same Shirt
Why yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying attention to that, and check out the top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00 …
Timescale Launches Dynamic PostgreSQL, the Cost-Effective Alternative to Serverless and Peak-Allocation Pay Models
NEW YORK – November 6, 2023 – Timescale, the cloud database company, has announced the launch of their Dynamic PostgreSQL product for business applications to more efficiently utilize their database compute and storage resources, even with variable or …
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 …