Sites anglophones


SQL ASCII Function Use and Examples

Publié le 16 mai 2025 sur sqlservercentral.com
 

The post SQL ASCII Function Use and Examples appeared first on SQLServerCentral.

[Video] Office Hours at the Hoover Dam

Publié le 15 mai 2025 sur brentozar.com
 

Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of myself for that one. Here’s what we covered: 00:00 Start 02:20 The Princess and the Frag: On SQL Server 2019 or later, are …

 

MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL Performance)

Publié le 15 mai 2025 sur simple-talk.com
 

Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered essential topics like configuring MySQL, optimizing memory and CPU usage, and enhancing disk I/O performance. These are important building bl …

 

Predicting When SQL Server Will Hit the CPU Wall

Publié le 14 mai 2025 sur brentozar.com
 

Most of the time, we use wait stats to identify SQL Server’s bottleneck and focus on what to tune. However, let’s say you’ve got a really well-tuned SQL Server where: Queries finish in milliseconds (think 5-20 milliseconds, super quick) Everything your …

 

Introduction to PostgreSQL for the Data Professional

Publié le 13 mai 2025 sur simple-talk.com
 

Learning something new has elements of bliss and terror. We all know the bliss of learning something new. The first time you figure out how to do something is a magical feeling that one never tends to lose. Stuck in the back of your mind is the first t …

 

SQL ConstantCare Badges

Publié le 13 mai 2025 sur brentozar.com
 

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

Publié le 13 mai 2025 sur simple-talk.com
 

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

Publié le 13 mai 2025 sur simple-talk.com
 

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

Publié le 12 mai 2025 sur brentozar.com
 

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

Publié le 12 mai 2025 sur sqlservercentral.com
 

The post Evaluating the Randomness of SQL Server Random Number Functions appeared first on SQLServerCentral.

 

Parent – Child Task Automation in Snowflake via Task Graph

Publié le 9 mai 2025 sur simple-talk.com
 

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

Publié le 9 mai 2025 sur sqlservercentral.com
 

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

Publié le 8 mai 2025 sur simple-talk.com
 

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!

Publié le 8 mai 2025 sur brentozar.com
 

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.

Publié le 7 mai 2025 sur brentozar.com
 

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 …


Pages :