Sites anglophones


 

Managed Instance Gotchas – Error Conditions

Publié le 31 mars 2025 sur simple-talk.com
 

I was recently on a project to migrate a very transactional installation of SQL Server to Azure SQL Managed Instance (MI). SQL Managed Instance is a good stepping stone between a full, on-prem SQL instance / Azure VM and an Azure SQL Database. It has m …

 

DeepSeek: What is new with this AI technology?

Publié le 31 mars 2025 sur sqlservercentral.com
 

Introduction I was happily resting in Samaipata, a pre-Inca temple admiring the ruins with our guide when a colleague wrote me. Dan, you need to watch this! Then he showed me the news about DeepSeek. It was the most interesting news of the year, so I s …

 

Load Data into Snowflake Using Python with Pandas

Publié le 30 mars 2025 sur simple-talk.com
 

Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals. Whether you’re pulling data from a relational database, wrangling a CSV file, or prototyping a new pipeline, this combination lever …

 

Basic Regex Emulator for SQL Server

Publié le 28 mars 2025 sur sqlservercentral.com
 

The post Basic Regex Emulator for SQL Server appeared first on SQLServerCentral.

Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions

Publié le 28 mars 2025 sur sqlservercentral.com
 

In February 2025, Microsoft introduced new T-SQL functions in Azure SQL Database and SQL Database in Microsoft Fabric to enhance fuzzy string matching capabilities. You can visit Exciting new T-SQL features: Regex support, Fuzzy string-matching, and bi …

[Video] Office Hours: Back in the Home Office

Publié le 27 mars 2025 sur brentozar.com
 

I’m back home after a 2-week Iceland vacation. Let’s catch up with your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:04 Suresh: Hi Brent . Question about 128 GB memory limit for SQL …

 

The CREATE DOMAIN Statement

Publié le 27 mars 2025 sur simple-talk.com
 

One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does not exist in SQL Server as of SQL Server 2022, but it has been a part of PostgreSQL since 7.3. Some definitions from other smart people Chris Date defined a doma …

 

 

Fabric: Query a SQL Endpoint from a Notebook

Publié le 26 mars 2025 sur simple-talk.com
 

Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how to make a query to a SQL Endpoint. We use notebooks to connect directly to lakehouse. Except by the T-SQL notebook, the notebooks have a default …

 

Query Exercise Answer: Finding Email Addresses

Publié le 26 mars 2025 sur brentozar.com
 

For this week’s Query Exercise, your mission had two parts: Do a first pass search through the Users table looking for columns where people had snuck in email addresses where they didn’t belong Write a more high-quality query to identify ex …

Improving the Performance of UPDATE Statements in SQL Server

Publié le 26 mars 2025 sur sqlservercentral.com
 

Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. The efficiency of such operations is influenced by various factors, including batch size, disk I/O, memory usage, C …

 

The Wide World of GiST Indexes

Publié le 25 mars 2025 sur simple-talk.com
 

  In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of this series, we used the GiST index type – and its lesser known cousin: SP-GiST – to turbocharge the performance of overlap queries. …

 

Why Your Azure SQL DB Hyperscale Bill is Higher Than You’d Expect

Publié le 25 mars 2025 sur brentozar.com
 

tl;dr: if you use Azure SQL DB Hyperscale’s auto-scaling, it’s probably not cutting your bill down because like SQL Server, Hyperscale doesn’t automatically relinquish memory, and it’ll be up to you to manually manage your own m …

SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG

Publié le 24 mars 2025 sur sqlservercentral.com
 

The post SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG appeared first on SQLServerCentral.

Dynamic T-SQL Script Parameterization Using Python

Publié le 24 mars 2025 sur sqlservercentral.com
 

When working with SQL Server, there are times when you need to build SQL scripts dynamically. In many cases, the logic behind your query depends on variables that aren’t known until runtime. Building these scripts in Python gives you flexibility, but y …

Fabric Analytics for SQL folks: Part 1 – Fabric demystified

Publié le 21 mars 2025 sur sqlservercentral.com
 

Summary In a landscape abundant with AI innovations and promises, a crucial question arises: « Is leveraging SQL and structured data genuinely beneficial for your business in today’s environment? » SQL and structured data have been pivotal in shaping con …


Pages :