The PASS Data Community Summit First Timer Guide
Edwin Sarmiento has been producing a first-timer’s guide for the PASS Data Community Summit since 2016. He has updated this for 2023 and you can see Edward’s announcement of the guide on Twitter here. Download the guide and you’ll find some amazing inf …
Time-Series Data Analysis with Apache Druid
In the era of data-driven decision-making, the ability to efficiently analyze and derive insights from time-series data is of paramount importance. Apache Druid, a cutting-edge open-source data store and analytics platform, has emerged as a compelling …
[Video] Office Hours: Having a Bad Day Edition
The first day back after a long vacation is always rough, and today’s no exception. I took your questions from https://pollgab.com/room/brento in an effort to turn things around and get back in the groove: Here’s what we covered: 00: …
The NTILE Function
The SQL NTILE() is a window function that allows you to break a table into a specified number of approximately equal groups, or <bucket count>. For each row in a grouping, the NTILE() function assigns a bucket number representing the group to whi …
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 …