Sites anglophones


 

XML Performance Tuning and Added Options

Publié le 21 juin 2024 sur simple-talk.com
 

SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes less space, all while ensuring efficient access to critical data. At its core, the metadata-styled XML format runs counter to the data that SQL Serve …

 

How I Used PostgreSQL RLS To Avoid Code Changes During a Migration

Publié le 21 juin 2024 sur sqlservercentral.com
 

Overview Our application is a microservice that stores metadata for actual data and is backed by Amazon Postgres RDS. It is deployed in a multi-tenant/multi-region/multi-cell environment. The Gateway handles the multi-region aspect of the system. That …

[Video] Office Hours: Database Answers from a Hotel Room

Publié le 20 juin 2024 sur brentozar.com
 

I went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver. Here’s what we covered: 00:00 Start 01:43 Poul J: Hi Brent. Can you give some examples of how a CHECK() constraint is used …

Query Exercise Answer: Beating ChatGPT at Finding Good Question Times

Publié le 19 juin 2024 sur brentozar.com
 

For this week’s Query Exercise, I asked you to write a better query than ChatGPT wrote. Your goal was to find the best days and times to post questions on Stack Overflow. I found it interesting that a lot of the initial answers focused on the tim …

SQL Server TRY CATCH, RAISERROR and THROW for Error Handling

Publié le 19 juin 2024 sur sqlservercentral.com
 

The post SQL Server TRY CATCH, RAISERROR and THROW for Error Handling appeared first on SQLServerCentral.

Unzipping Word Documents in T-SQL

Publié le 19 juin 2024 sur sqlservercentral.com
 

In the databases I am currently working with, there are some tables containing Word documents stored as binaries and I was wondering if it would be possible to perform some server-side processing on these documents. Modern Word documents (.docx) are no …

Join Me in San Diego for SQL Saturday!

Publié le 18 juin 2024 sur brentozar.com
 

I’m coming to San Diego on Sept 13-14 for SQL Saturday San Diego! I’m teaching a one-day pre-conference workshop on Friday, September 13th. Tuning Databases In One Day – You’ve got production databases in SQL Server or Azure SQL …

Working with SQL Server in Visual Studio Code

Publié le 17 juin 2024 sur sqlservercentral.com
 

Introduction Visual Studio Code (VSCode) is a free and light source code editor created by Microsoft. It can be installed in Windows, macOS, or Linux. Note that Visual Studio is not the same as Visual Studio Code. Visual Studio Code is a light software …

Fine-grained Access Control for Stored Procedures

Publié le 14 juin 2024 sur sqlservercentral.com
 

Synopsis Modern relational databases have comprehensive security mechanisms to enforce fine-grained access control for tables and views. But when it comes to stored procedures, access control is rudimentary: either you can execute a stored procedure, o …

Power BI Treemap Chart Step-by-Step Tutorial

Publié le 14 juin 2024 sur sqlservercentral.com
 

The post Power BI Treemap Chart Step-by-Step Tutorial appeared first on SQLServerCentral.

[Video] Creepy Office Hours in Vancouver

Publié le 13 juin 2024 sur brentozar.com
 

While in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to take your top-voted questions from https://pollgab.com/room/brento. Somehow, the latest Vision OS update gave me a 1980s 3rd Bass haircut. Here’s what …

Query Exercise: Beat ChatGPT at Finding Good Question Times

Publié le 12 juin 2024 sur brentozar.com
 

What are the best days of the week and times of the day to post a question at StackOverflow.com? It seems like a simple question, but it’s surprisingly nuanced. I asked ChatGPT’s latest version, 4o, and its answer made me laugh out loud. Fi …

Memory Grant Feedback Persistence in SQL Server 2022

Publié le 12 juin 2024 sur sqlservercentral.com
 

As a SQL Server DBA, effectively controlling memory allocations is essential to guaranteeing optimal query performance. In SQL Server 2022, Microsoft enhanced a powerful feature called Memory Grant Feedback Persistence, which allows SQL Server to bette …

PostgreSQL is Now Faster than Pinecone, 75% Cheaper, with New Open Source Extensions

Publié le 12 juin 2024 sur sqlservercentral.com
 

NEW YORK – June 11, 2024 – Timescale, the PostgreSQL cloud database company, has unveiled two groundbreaking open-source extensions, pgvectorscale and pgai, which significantly enhance PostgreSQL’s scalability and ease of use for AI applications. Licen …

There’s a 6-Month Statute of Limitations on “The Last Person.”

Publié le 11 juin 2024 sur brentozar.com
 

“The last person must have set it up that way.” “The last person wrote that code.” “The last person just didn’t configure it right.” You can use that excuse for 6 months. For six months, you’re allowed to …


Pages :