Overlapping Ranges in Subsets in PostgreSQL
In Part I of this series, we explored overlap queries and the problems that accompany them, along with ways to improve their performance. We concluded by defining an overlap query in terms of timestamp ranges, which allowed us to use a new index type – …
[Video] Office Hours: Car in the Dining Room Edition
What, doesn’t everyone park a convertible in their dining room? I address the pink elephant in the room, and then take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:03 MyTeaGotCold: Ha …
Execute Stored Procedures in the Microsoft GraphQL API
The post Execute Stored Procedures in the Microsoft GraphQL API appeared first on SQLServerCentral.
Simplify Data Loading with Fivetran (HVR): Data Engineering with Fabric
Many companies have technical debt which consists of applications and/or databases that are no longer in support or cannot be upgraded. How can we get this data in an Azure Data Lake when the size of the tables are large and there are not slowly chang …
Working with MongoDB Indexes
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Throughout this series, I’ve covered a number of topics about working with MongoDB collections and their data. One topic I have n …
Making Your Learning Plan for 2025
This week is my annual Black Friday sale, and over and over, folks buy the Fundamentals & Mastering Bundle because it’s such a good deal. But then they let it sit in their accounts. Time flies by, and next thing you know, an entire year has g …
Essential Strategies for Optimizing Snowflake Performance and Reducing Costs
In today’s data-driven enterprise environment, businesses increasingly rely on Snowflake’s cloud data warehouse for handling large-scale data analytics and storage needs. However, optimizing Snowflake performance is crucial to manage growing data wareh …
This Is It! Our Annual Black Friday Sale on SQL Server Training…
You’ve been eyeing my training classes all year long, biting your lip with lustful hunger, wishing you could get the same quality of training that over 6,000 of your friends have attended. Now’s your chance! Fundamentals$195per yearThe best …
A First Look at SSMS 21
This isn’t really a first look, per se. I’ve seen Erin Stellato present on this a few times in MVP sessions and at the PASS Data Community Summit. However, this is a look on my machine, where I’m in control. The new version preview was announced recent …
[Video] Office Hours: Ask Me Database Questions
I took your top-voted questions from https://pollgab.com/room/brento. At one point, my camera overheats – hang in there, I get it fixed in a few seconds. Here’s what we discussed: 00:00 Start 01:59 MyTeaGotCold: Your HA/DR worksheet mention …
Hiring and Motivating Technical Polyglots in Data Analytics
In this article, I will discuss hiring and motivating technical polyglots. A polyglot is a person who speaks multiple languages at a conversational level, and according to preply.com, more than three languages. When it comes to spoken languages, I’m on …
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 …