Archives de l’année : 2025

[Video] Office Hours in My Vegas Backyard

I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second […]

23 janvier 2025 dans Sites anglophones étiqueté Videos par brentozar.com

Azure SQL Serverless: Discover What’s new and Increase Your Savings

Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]

22 janvier 2025 dans Sites anglophones étiqueté Azure / Azure SQL Database / AZURE SQL SERVERLESS / Blogs / Database / Database Administration / SQL / SQL Server par simple-talk.com

Navigating the Database Landscape in 2025 Livestream on Feb 12

The post Navigating the Database Landscape in 2025 Livestream on Feb 12 appeared first on SQLServerCentral.

22 janvier 2025 dans Sites anglophones par sqlservercentral.com

Can AI Rewrite Bad Queries in Seconds? Kinda.

When I see horrific code, stuff that would take a lot of manual labor to fix, I like […]

22 janvier 2025 dans Sites anglophones étiqueté development par brentozar.com

How to Install SSIS in Visual Studio 2019

The post How to Install SSIS in Visual Studio 2019 appeared first on SQLServerCentral.

22 janvier 2025 dans Sites anglophones étiqueté ETL/SSIS/Azure Data Factory par sqlservercentral.com

Why Standards are Important

Throughout my career I have seen arguments as to which IT standard in a particular area, is the […]

22 janvier 2025 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com

SQL Server Integration Services (SSIS) Microsoft Connector for Oracle deprecation
In July 2025, Microsoft will discontinue support for the Microsoft Connector for Oracle in SQL Server Integration Services […]

21 janvier 2025 dans Sites Microsoft par SQL Server Blog

Un GREP pour les bases de données MS SQL Server
Comment rechercher dans toutes les tables et toutes les colonnes une valeur précise ? C’est ce que propose […]

21 janvier 2025 dans Sites francophones étiqueté colonne / GREP / ligne / recherche / scripts SQL / SQL Server / table / valeur par mssqlserver.fr

Nostalgic Memory Loss

Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am […]

20 janvier 2025 dans Sites anglophones étiqueté editorial / Editorials / Memories par simple-talk.com

Loading Models from Source Data with dbt

The data transformation tool dbt (data build tool) has become more and more popular over the past […]

20 janvier 2025 dans Sites anglophones étiqueté dbt / Featured / General Analytics par simple-talk.com

Influencing a Local AI
I set up a local AI LLM to run and then conducted some experiments. This post shows a […]

20 janvier 2025 dans Sites anglophones étiqueté Artificial Intelligence (AI) par sqlservercentral.com

Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real ...

The post Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD appeared […]

20 janvier 2025 dans Sites anglophones étiqueté DevOps and Continuous Delivery (CI/CD) par sqlservercentral.com

MySQL Shell and Basic Configuration Management (Part 2 – Memory ...
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first […]

17 janvier 2025 dans Sites anglophones étiqueté Featured / MySQL par simple-talk.com

Chiffrement des sauvegardes via clés extensible Azure Key Vault
Il est des situations où utiliser une clé de chiffrement asymétrique stockée dans un module de gestion de […]

17 janvier 2025 dans Sites francophones étiqueté Azure / BACKUP / EKM / Key Vault / SQL Server par conseilit.wordpress.com

Vector DB implementation using FAISS

Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a […]

17 janvier 2025 dans Sites anglophones étiqueté Artificial Intelligence (AI) / Chatbots / Document Retrieval / Document Search / FAISS / Large Language Models / Machine Learning / Natural Language Processing / Python / Semantic Search / Sentence Embeddings / Sentence Transformers / Similarity Search / Text Embeddings / Unstructured Data / Vector Database par sqlservercentral.com

Using Snyk for CI/CD Security Scanning
Security is important regardless of your industry, whether it’s finance, retail, e-commerce, or the broader world of […]

16 janvier 2025 dans Sites anglophones étiqueté Security / Security and Compliance / Snyk par simple-talk.com

I’m Coming to Croatia!

A few things lined up perfectly for a European trip this summer. I’m on a European cruise in […]

16 janvier 2025 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com

Fabric Copy Job: What’s new in it
At first sight, the new Copy Job may seem only one more redundancy: Why do we need […]

15 janvier 2025 dans Sites anglophones étiqueté Blogs / Copy Job / Data Factory / Incremental Load / Microsoft Fabric par simple-talk.com

The year ahead for SQL Server: Ground to cloud to ...
As we begin a new year in 2025, many of you are looking at new projects, new applications, […]

15 janvier 2025 dans Sites Microsoft par SQL Server Blog

Does Separating Data and Log Files Make Your Server Faster?
I’ve already explained that no, it doesn’t make your database server more reliable – and in fact, it’s […]

15 janvier 2025 dans Sites anglophones étiqueté Storage par brentozar.com

Announcing the 2025 Data Professional Salary Survey Results.
We’ve been running our annual Data Professional Salary Survey for almost a decade, and I was really curious […]

14 janvier 2025 dans Sites anglophones étiqueté Salary par brentozar.com

FinOps pour Microsoft Fabric
Version de l’article en Anglais sur LinkedIn : Le FinOps et Microsoft Fabric, deux sujets qui m’intéressent […]

13 janvier 2025 dans Business Intelligence / Sites anglophones étiqueté Azure - Cloud / Database / DAX / fabric / finops / GraphQL / greenit / Microsoft Fabric / notebook par www.pulsweb.fr

VIEW Objects

A view is a virtual table, created when it’s invoked by the < view name>. The goal […]

13 janvier 2025 dans Sites anglophones étiqueté Database Theory / Featured / Theory and design par simple-talk.com

How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions ...

Introduction When working with T-SQL trigonometric functions in SQL Server, it’s important to be aware of potential pitfalls […]

13 janvier 2025 dans Sites anglophones étiqueté Administration / Cosine function / Degrees / Floating-point precision / Mathematical functions in SQL / Radians / Radians function / SQL best practices / SQL conversion errors / SQL function usage / SQL Server / SQL Server tips / SQL troubleshooting / t-sql / T-SQL tips / Trigonometric functions par sqlservercentral.com

Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, ...

The post Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines appeared first on […]

13 janvier 2025 dans Sites anglophones étiqueté Microsoft Fabric (Azure Synapse, Data Engineering, etc.) / partitioning / Performance and Tuning par sqlservercentral.com

I Wrote a Book on How You Broke Your Database ...

Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about […]

10 janvier 2025 dans Sites anglophones étiqueté Blogs / books / Database Availability / Database Books / Database Performance / Database Security / Databases / Hacking MySQl / MariaDB / MySQL / MySQL Books / Percona Server / Resources / SQL Books par simple-talk.com

Customizing the Export and import of Parquet Files in SQL ...
Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an […]

10 janvier 2025 dans Sites anglophones étiqueté Featured / SQL Server par simple-talk.com

Resolving Access Denied Errors During SQL Server Database Attachment

Introduction Database administrators regularly detach and attach databases as part of their daily tasks. During this process, they […]

10 janvier 2025 dans Sites anglophones étiqueté access denied / Administration / Attach/Detach / Database Administration / database attachment / error resolution / file permissions / LDF files / MDF files / SQL Server / sysadmin / t-sql par sqlservercentral.com

Comparing Groups for Similarities in Power Query – Using Cosine ...

The post Comparing Groups for Similarities in Power Query – Using Cosine Similarity appeared first on SQLServerCentral.

10 janvier 2025 dans Sites anglophones étiqueté Power Query par sqlservercentral.com

[Video] Office Hours: Long Answers Edition

Today’s questions from https://pollgab.com/room/brento require a little bit longer answers: Here’s what we covered: 00:00 Start 03:20 Josef: […]

9 janvier 2025 dans Sites anglophones étiqueté Videos par brentozar.com

I Feel Sorry for Untrained Developers Using Entity Framework.
Most of the time, I love Entity Framework, and ORMs in general. These tools make it easier for […]

8 janvier 2025 dans Sites anglophones étiqueté development par brentozar.com

A Use Case for Memory-Optimized Tempdb Metadata
I recently had an interesting production SQL Server issue that turned out to be very easy to […]

8 janvier 2025 dans Sites anglophones étiqueté Blogs / Configuration / SQL Server / tempdb par simple-talk.com

SQL Server OPTION RECOMPILE for Simple Queries

The post SQL Server OPTION RECOMPILE for Simple Queries appeared first on SQLServerCentral.

8 janvier 2025 dans Sites anglophones étiqueté Performance and Tuning / recompile / t-sql par sqlservercentral.com

How to Load a Fabric Warehouse: Data Engineering with Fabric
The data warehouse in Microsoft Fabric was re-written to use OneLake storage. This means each and every table […]

8 janvier 2025 dans Sites anglophones étiqueté Microsoft Fabric (Azure Synapse, Data Engineering, etc.) par sqlservercentral.com

Who’s Hiring in the Microsoft Data Platform Community? January 2025 ...

Is your company hiring for a database position as of January 2025? Do you wanna work with the […]

7 janvier 2025 dans Sites anglophones étiqueté Who's Hiring par brentozar.com

Data Documents and Common Sense

The post Data Documents and Common Sense appeared first on SQLServerCentral.

6 janvier 2025 dans Sites anglophones étiqueté Design and Theory par sqlservercentral.com

Why you should avoid Implicit Measures in your Power BI ...
Everyone who has dabbled around with Power BI knows probably the concept of measures (if not, here’s a […]

6 janvier 2025 dans Sites anglophones étiqueté Power BI par sqlservercentral.com

Improved RCSI Ghost Cleanup in SQL Server 2022

The post Improved RCSI Ghost Cleanup in SQL Server 2022 appeared first on SQLServerCentral.

3 janvier 2025 dans Sites anglophones étiqueté ghost cleanup par sqlservercentral.com

Leveraging the “STUFF” Function for Enhanced Data Representation and String ...

Abstract In the realm of data management and business intelligence, effective data representation becomes crucial for deriving actionable […]

3 janvier 2025 dans Sites anglophones étiqueté STUFF / Uncategorized par sqlservercentral.com

Oracle Architecture Overview
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways […]

2 janvier 2025 dans Sites anglophones étiqueté Featured / Oracle par simple-talk.com

Five changes to SQL Server I’d love to see

I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very […]

1 janvier 2025 dans Sites anglophones étiqueté Featured / SQL Server / T-SQL Programming par simple-talk.com

[Video] Office Hours in Tokyo, Japan

For the last Office Hours of the year, I’m coming to you from Tokyo, the last stop on […]

1 janvier 2025 dans Sites anglophones étiqueté Videos par brentozar.com