SQL ConstantCare Badges
SQL ConstantCare™, our monitoring app that gives you a simple daily email with actionable tasks to make your servers faster and more reliable, is about to start sending out monthly awards! On the first weekday of each month, we’ll email the winners wit …
Managed Instance Gotchas – Configuration Items
In my last post I described issues that might stop your migration to a SQL Server Managed Instance (SQL MI). This covers configuration items that differ or are not supported in SQL MI. These likely won’t stop your migration, but they could slow you dow …
Recovering data in SQL Server without full backup
In more than 10 years of experience, I have dealt with cases where someone has performed incorrect operations on a table, such as updating or deleting wrong rows, in a SQL Server database that does not have full backups available. There are multiple re …
Free Webcast Tomorrow: Mastering Query Tuning
This is it: the very peak of my free SQL Server Spring Training webcast series. I’ve been teaching 60-90 minutes of my most popular classes for free this spring, and now it’s time for the Mastering classes. Tomorrow I’m covering Mastering Query Tuning. …
Evaluating the Randomness of SQL Server Random Number Functions
The post Evaluating the Randomness of SQL Server Random Number Functions appeared first on SQLServerCentral.
Parent – Child Task Automation in Snowflake via Task Graph
In the fast-paced world of business, fast, effective data management is crucial. One of the places where this is the most evident is in the healthcare sector. From patient records to treatment data, every piece of information must be processed accurate …
Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD
Working with dates in SQL Server is something almost every developer runs into. You might need to figure out how many days are left in the month, get the first day of the quarter, calculate someone’s age, or add a few weeks to a deadline. Fortunately, …
Real-time Data Streaming in Snowflake
Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to process data streams from IoT sensors, financial transactions, and application events with minimal latency. Snowfla …
[Video] Office Hours: Speed Round!
Not all of y’all’s questions from https://pollgab.com/room/brento require long, thought-out answers. Let’s do a speed round: Here’s what we covered: 00:00 Start 00:34 Alain Térieur: Hi Brent. I started the restore of a (big) DB. And it took more than 2 …
Don’t Let Your Kids Drop ACID.
We’re heading towards graduation time. In just a few short months, your high school kids are going to be packing up their bags and heading off to college. It’s a time of adventure and discovery, and the first time they’ll be away from your parenting an …
Techniques to query Azure SQL’s new JSON Datatype
The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation in SQL Databases. These features are slated to be a part of SQL Server 2025 as well. Let’s analyze some practical uses of these features. C …
SQL Server Cursor Example
The post SQL Server Cursor Example appeared first on SQLServerCentral.
Jacksonville SQL Saturday 2025 Roundup
Are SQL Saturdays finally back to the way they should be? This past weekend in Jacksonville Florida things sure felt like they are. There was an energy that comes with an event that matches just right to the space allocated, and that energy grows even …
Who’s Hiring in the Microsoft Data Platform Community? May 2025 Edition
Is your company hiring for a database position as of May 2025? 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 include the …
MySQL Index Overviews: Hash Indexes
Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as well as walked you through B-tree indexes. MySQL, however, has many other index types it can offer for your use case, and one of those indexes …