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 …
KQL: The top of a group in an easy way
When learning something new, we always compare it with what we know. In this case, we end up comparing KQL with SQL. In SQL, when we need to get the top rows based on a grouping, the process is not easy. For example, let’s say that in a table con …
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Representational State Transfer (REST) is a software architectural design that has been employed throughout the software industry to create stateless web applications. An application that adheres to the REST may be informally described as RESTful. Thi …
Relationships with Microsoft Fabric GraphQL API
The post Relationships with Microsoft Fabric GraphQL API appeared first on SQLServerCentral.