Announcing SQL Server 2025
This week we have announced SQL Server 2025 now available in private preview. SQL Server 2025 is an Enterprise AI-ready database from ground to cloud. SQL Server 2025 has AI built-in, powered by an industry proven engine with security, performance, and …
Breaking Down Ignite: A Pragmatic Look at the Conference’s Best Innovations
The amount of news brought by Ignite is huge. I was not expecting to find so many new features, resources, and discoveries. There may be dozens of summaries of the conference, and each one focusing on different highlights and news. On this article I wi …
Updated Training Modules for SQL Server 2019 & 2022
At the PASS Summit this month, I presented a 1-day workshop called T-SQL Tuning for SQL Server 2019 & 2022. I just took that material and refactored it into a few different modules for various classes: Mastering Server Tuning – Why Query Moni …
3 Legit Signs It’s Time for Enterprise Edition
Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re wondering what you’re missing, and whether you should be on SQL Server Enterprise Edition. Here are 3 warning signs to watch out fo …
Reading and Writing Parquet Files in SQL Server
When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place for that data to reside. It is column-based, highly compressed, and supports a wide variety of optimizations for both reads and writes. When analytic d …
What’s New in SQL Server 2025
Today at Microsoft Ignite, Microsoft announced SQL Server 2025. The biggest new features focus on AI and bringing the latest Azure SQL DB features down to your own servers. Here are the top features: Call AI services like ChatGPT directly from T-SQL …
SQL ConstantCare® Population Report: Fall 2024
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. Today it’s time for the fall 2024 version of our SQL ConstantCare® population report. SQL Server 2019 is still the king of the hill w …
Help Me Help You.
In my PollGab room where y’all can ask questions, Chocolate Thunder wrote: I do genuinely wish that I could do two things at the same time: Give y’all everything for free, and Pay for the roof over my head and put food on my table I haven …
Microsoft SQL announcements at PASS Data Community Summit 2024
It was an amazing week at the PASS Data Community Summit 2024 in Seattle, Washington. Microsoft made several announcement for Azure SQL and tools showing continued innovation for our customers. SSMS 21 SQL Server Management Studio (SSMS) is hands-down …
How to Develop Custom T-SQL Code Snippets in Azure Data Studio
To get started, follow these steps to find and use the default snippets in Azure Data Studio. In a new query window, just type SQL and the list will open. Then, navigate with the UP/DOWN arrows to find the snippet you want to load. Select the item you …
Explore Pandas in Python to Analyze and Manipulate Tabular Data
The post Explore Pandas in Python to Analyze and Manipulate Tabular Data appeared first on SQLServerCentral.
MySQL vs PostgreSQL: Numeric Datatype Comparison
When you think of how to store data in a database, you think of data types. A data type represents a method of how some bit of data is stored internally. Whether it’s numbers, text, dates, or even more complex structures like JSON or geometric sh …
Making Temporal Databases Work, Part 3: Saving Data
The post Making Temporal Databases Work, Part 3: Saving Data appeared first on SQLServerCentral.
Office Hours: Guess the Theme Edition
There’s a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take the top-voted ones, but today, see if you can spot the thing they all have in common: Here’s what we covere …
SSMS v21: Dark Mode, Git, Vertical Tabs, and More
SQL Server Management Studio v21 Preview 1 is out and let’s give it a quick whirl. It’s installed with the Visual Studio installer. That doesn’t mean Visual Studio is installed or required – it’s not – it’s jus …