Sites anglophones


Free Webcast Next Thursday: Tuning Indexes to Avoid Blocking

Publié le 17 juin 2025 sur brentozar.com
 

Indexing can make or break your SQL Server performance. You need just the right balance: enough indexes to speed up your queries, but not so many that they drag down your inserts, updates, and deletes. Join me as I introduce the “5 & 5 indexing gui …

 

DevOps vs. SRE: Bridging the Gap, Not Building Walls (Part 1)

Publié le 17 juin 2025 sur simple-talk.com
 

Understanding the Divide — DevOps vs. SRE Explained The conversation around DevOps versus Site Reliability Engineering (SRE) is becoming increasingly common in modern software and platform engineering teams. These two frameworks aim to optimize how we …

 

How to process images and analyze charts with AI

Publié le 16 juin 2025 sur sqlservercentral.com
 

In this article, we will see how to handle images with AI. Sometimes we need to import the text from images into SQL Server. In this article, we will use ChatGPT to convert text from images into text. If you want to know more about ChatGPT, you can rea …

 

Replicating MySQL databases in Docker Containers

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

In my prior article, “Running a relational database with Docker”, I showed how to spin up a Docker container with an instance of MySQL running in it. I also showed how you can persist data even when you blow away the container and recreate it by connec …

 

Dimensional Modeling Case Study Part 3 – Dynamic Days Dimension

Publié le 13 juin 2025 sur sqlservercentral.com
 

Background In this case study series, we’ve explored how to use age and tally tables to support various forms of banding by denormalizing them into a single dimension table. Each banding, such as age groups or day ranges, is built upon a base level of …

 

Load Data into Snowflake Using Native Snowflake Connector for Python: From Small to Large Datasets

Publié le 12 juin 2025 sur simple-talk.com
 

In our ongoing exploration of Snowflake data loading strategies, we’ve previously examined how to use pandas with SQLAlchemy to efficiently move data into Snowflake tables. That approach leverages pandas’ intuitive DataFrame handling and works well for …

 

[Video] Office Hours at the Barcelona Pavilion

Publié le 12 juin 2025 sur brentozar.com
 

I’ve always wanted to see the Barcelona Pavilion by Mies van der Rohe, and by happy coincidence, I ended up walking right past it while visiting Barcelona! It’s one of the most important beginnings of modern architecture, and I loved it. I brought you …

Query Exercise Answers: Returning Routes in the Right Order

Publié le 11 juin 2025 sur brentozar.com
 

In your most recent Query Exercise challenge, I gave you these two tables: DROP TABLE IF EXISTS dbo.Stations; CREATE TABLE dbo.Stations (StationId INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, StationName VARCHAR(50), StationPhysicalOrder INT); INSERT INTO …

 

SQL Server 2025 : Zstandard Backup Compression

Publié le 11 juin 2025 sur simple-talk.com
 

This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once 2025 has been released, posts will be kept if the feature hasn’t changed for the final release. For other posts in this series, you can find them in this collect …

 

Guide to Decoding SQL Server Bulk Insert Error Files

Publié le 10 juin 2025 sur sqlmag.com
 

Learn how to work with SQL Server’s ERRORFILE option to isolate problem records, decode cryptic error messages, and avoid duplicate imports when dealing with bulk data loading errors.

 

TempDB Resource Governor Space Controls in SQL Server 2025

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

TempDB is a system database in SQL Server that manages temporary objects for all databases on a server. Because it is a shared resource, it can easily become a performance bottleneck., as well as an opportunity for a single database or even a single qu …

 

SQLBits Added More Capacity to My Workshop! Move Quick.

Publié le 9 juin 2025 sur brentozar.com
 

I’m coming to London this month for SQLBits, and my Thursday workshop “Faster, Cheaper Cloud Databases” workshop sold out right away when it was announced. There’s been a waitlist for months. The short story: they added more capacity to my room! If you …

 

The good, the bad, and the awful taste muscle memory can have

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

When I was traveling a while back, I grabbed a small white metal tube out of my toiletry bag. Opened it up and then squeezed a small amount of this white cream on my toothbrush. A few seconds later my power toothbrush was whirring along and I had a tho …

 

Azure SQL Performance Tuning: Mastering Indexes, Partitioning, and Clustered Columnstore

Publié le 9 juin 2025 sur sqlservercentral.com
 

Performance tuning in Azure SQL Database can feel like solving a puzzle—get it right, and your queries fly; get it wrong, and you’re stuck waiting. Whether you’re dealing with sluggish reports or slow transaction processing, the right indexing strategy …

 

Sponsoring Scenic City Summit

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

For the second year in a row, Simple Talk will sponsor Scenic City Summit in Chattanooga, TN, which will be held June 19-21.  What is awesome about this year’s Scenic City Summit is that is expanding and will pull from several of the area’s well-establ …

 


Pages :