L'actualité technique MS SQL Server en France (et ailleurs)

Recherche

/* ----------------------------------------- */ /* Vue : Recherche : début */ /* ----------------------------------------- */ .recherche-bouton { display: inline-block; padding: 4px 12px; margin-bottom: 0px; font-size: 14px; font-family: "Helvetica Neue",Helvetica,Arial,sans-serif; line-height: 20px; text-align: center; vertical-align: middle; cursor: pointer; border-width: 1px; border-style: solid; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; border-radius: 4px; box-shadow: 0px 1px 0px rgba(255, 255, 255, 0.2) inset, 0px 1px 2px rgba(0, 0, 0, 0.05); color: #FFF; text-shadow: 0px -1px 0px rgba(0, 0, 0, 0.25); background-color: #363636; background-image: linear-gradient(to bottom, #444, #222); background-repeat: repeat-x; border-color: rgba(0, 0, 0, 0.1) rgba(0, 0, 0, 0.1) rgba(0, 0, 0, 0.25); } .js-wpv-loop{ margin:0px;padding:0px; width:100%; border-collapse: separate; } @media only screen and (min-width : 768px) { .flex-row.row { display: flex; flex-wrap: wrap; margin-bottom:1%; } .flex-row.row > [class*='col-'] { display: flex; flex-direction: column; } } .row-fluid [class*="span"] { margin-left: 1%; margin-bottom:1%; } .row-fluid [class*="span3 cell"]{ vertical-align:top; word-wrap: break-word; overflow-wrap: break-word; background:-o-linear-gradient(bottom, #cccccc 5%, #ffffff 100%); background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #cccccc), color-stop(1, #ffffff) ); background:-moz-linear-gradient( center top, #cccccc 5%, #ffffff 100% ); filter:progid:DXImageTransform.Microsoft.gradient(startColorstr="#cccccc", endColorstr="#ffffff"); background: -o-linear-gradient(top,#cccccc,ffffff); background-image: -ms-linear-gradient(top, #cccccc 5%, #ffffff 100%); background-color:#cccccc; /*border:1px solid #000000;*/ border-width:0px 0px 0px 0px; /* 0 1 1 0 */ /*border-top : 5px solid #F78C40;*/ text-align:left; padding:20px; -moz-box-shadow: 10px 10px 5px 0px #656565; -webkit-box-shadow: 10px 10px 5px 0px #656565; -o-box-shadow: 10px 10px 5px 0px #656565; box-shadow: 10px 10px 5px 0px #656565; filter:progid:DXImageTransform.Microsoft.Shadow(color=#656565, Direction=134, Strength=5); -moz-border-radius: 10px; -webkit-border-radius: 10px; border-radius: 10px; font-size:14px; /*font-family:Arial;*/ font-weight:normal; line-height:22px; /*color:#000000;*/ } /* ----------------------------------------- */ /* Vue : Recherche : fin */ /* ----------------------------------------- */

.NET
@SQLServer
#Basic Always-On
#dataanalytics
#invalidObject
#sql interview questions
#sql server interview questions
#SQL Standard
#SQLPass
2022
2023
2024
AAS
Accelerated Data Recovery (ADR)
access denied
Access Predicate
accounting
ADF
Administration
Adoption
ADS notebooks
Advanced Querying
Advanced SQL
Adventure Works Schema
AdventureWorks
AdventureWorks 2019
AdventureWorks 2022
AdventureWorks database
AG
Aggregate
Aggregates
AI
AishaBukar_MySQL_PostgreSQL
Always On Availability Group
Always On Availability Groups
AlwaysOn
amazon
Amazon Athena
Amazon EC2 Instance
Amazon RDS
amazon rds instance
Amazon Redshift
Amazon Web Services (AWS)
aMS
Analyse
Analysis Services (SSAS)
Analytics
Announcements
Apache Druid
Apache Spark
APPLY
Architecture
Archivage
ARM template
Artificial Intelligence
Artificial Intelligence (AI)
AsAzureRedirection
ASP.NET
assign new shared disk to SQL role
Attach Database
Attach/Detach
audit
Auditing
auto-incréments
automate database attachment
automatedlab
Automatic tuning
Automating tornado alerts for policyholders using SQL Server
Automation
Availability Group (AG)
availability groups
AWS
AWS RDS SQL Server
azsure sql database
Azure
Azure - Cloud
azure acloud shell
Azure Active Directory
azure ai
Azure Automation
Azure BLOB Storage
Azure Cognitive Services
Azure Cosmos DB
Azure Data Explorer (ADX)
Azure Data Factory
Azure Data Studio
Azure Data Studio (ADS)
azure database
azure database auditing
Azure DevOps
Azure DevOps Git
Azure Fabric
Azure Functions
Azure IaaS VM
Azure Key Vault
Azure Logic App
Azure SQL
Azure SQL Database
Azure SQL DB
Azure SQL maintenance
Azure SQL Managed Instance
azure sql server
AZURE SQL SERVERLESS
Azure Storage
azure synapse
Azure Synapse (formerly Azure SQL Data Warehouse)
Azure Synapse Analytics
Azure VM
AzureAnalysisServices
azureautomation
B-Tree Indexes
Back to Basics
BACKUP
Backup and Recovery
Backup and restore
Backup-Restore
backups
bar
bard
barisopen
baropen
Base de données
Basket Analysis
Batch Execution Mode on Rowstore in SQL Server 2022
batch size
batch update
beer
benJohnston_Audit
BenJohnston_DynamicDataMasking
BenJohnston_ETL
BenJohnston_RLS
Best Practices
BestPractice
BI
Big Data
Big Data Search
BigQuery
binary data
binary operations
Bing chatbot
BIT
BIT_COUNT
bitcoin
bitwise operations
bitwise operations in SQL Server
bitwise shift
bitwise shift examples
BlazeSQL
Blob storage
blocage
blockchain
blocking
Blocking in SQL Server
Blogging
Blogs
bonnes pratiques
books
BPA
branching strategy
BreachDirectory.com
Bronze
bulk insert
bulk logged
bulk update
business intelligence
C#
cache
Calandar
calculated columns
Cardinalities
Career
Career Growth
CASE Equivalent
cassandra
CassandraDB
CEIP
Certification
Certifications
CETAS
Change Data Capture
Chatbots
ChatGPT
ChisomKanu_MySQLShell
CHOOSE function
CI/CD
Claims triaging with SQL Server STIntersects() function
Classes
Claude
clonage d'une base
cloud
cloud analytics
Cloud Computing
Cloud Data Management
cloud database
cloud migration
Cloud Performance Testing
cloud security
cloud services
cloud shell
cloud strategy
cloud technology
Club Power BI
ClubPowerBI
cluserting
Clustered Index
co-pilot
Coalesce()
code snippets
coeurs
collation
colonne
Columnstore Indexes
Combine
Common Table Expressions (CTE)
Community
Company News
comparaison
compatibilité
Composite Index
computer security
Concurrency
conditional logic
Conference
Conferences
Conferences and Classes
Conferences, Classes, Events, and Webinars
Configuration
Configuration Settings
Consulting
Consulting Lines
containers
Containers and Virtualization
continuité
Convert latitude and longitude to SQL Server GEOGRAPHY
Copilot
Copy Job
Core Site Pages
Corruption
Cosine function
CosmosDB
covering index
CPU
CPU usage
create C# objects
CREATE OR ALTER
cross apply
crowd
CSA
CSV files
CTE
Culture
Cumulative updates
Custom Logging
custom scripts
Customer Stories
Cyber Security
Cyber Security Training
cybersecurity
dalle
Dark Mode
Data
data analysis
Data Analytics
Data API Builder (DAB)
Data Chouette
Data Conversion
Data culture
data engineering
Data Exploration
Data Factory
data files
Data Generation
data governance
data in the cloud
Data Joins
Data Lake
Data Lakes
data lineage
Data Loading
data manipulation
Data Migration
Data Mining
Data Modeling
data platform
Data Science
Data Security
Data Storage
data studio
Data Type Conversion
Data Types
Data Warehouse
Data Warehouses
Data Warehousing
Data WarehousingBusiness Intelligence
Data Wrangler
Data Wrangler Extension
dataandanalytics
Database
Database Administration
database as a service
database attachment
Database Availability
Database Books
Database Conference
Database Deployment
Database Design
Database Design and Implementation
Database Development
Database DevOps
Database Frontiers
database installation
Database Integrity
Database Maintenance
database management
database migration
database modelling
database monitoring
Database objects
Database Optimization
Database Performance
Database Project
database querying
Database Reporting and Administration
database restore
Database Security
Database Space
database testing
Database Theory
Databases
databases managment
Databricks
DataChouette
dataflow
datagrillen
DataLake
datalakehouse
Datamarts
DataOps
datawarehouse
Date Calculations
Date computation
date conversion
date dimension
date expressions in SQL
Date Formatting
Date Functions
Date Metadata
Date Range
DATEADD
DATEDIFF
DATEPART function
datetime
DAX
DBA
DBA tips
DBA Tools
DBAs
dbatools
DBCC CHECKDB
DBCC CHECKPRIMARYFILE
DBCC IND
DBCC PAGE
DBFrontiers.net
dbt
DDL Triggers
deadlocks
Deepseek
Default Trace
Degrees
DELETE
DELETE Statement
Delta
Delta Tables
DENSE_RANK()
dependent columns
Deployment Pipelines
deployments
desastre
Descending Index
Design
Design and Theory
Detach Database
Developer
development
DevOps
DevOps and Continuous Delivery (CI/CD)
Dijkstra
DimDate
Dimensions
DirectLake
disk I/O
DMV
docker
Document Retrieval
Document Search
drapeau de trace
Drop Column
drop columns
Dynamic SQL
Edition spéciale
editorial
Editorials
Efficient spatial indexing for large-scale risk modeling
EKM
Elastic Jobs
ElasticSearch
elt
Email
embeddings
Empowering Users
Encryption
Erase Hive Tables
ERPNext
Error Handling
Error Handling in SQL
error resolution
EsProc SPL
Estimateur de Cardinalité
Ethical Hacking Tutorial
ETL
ETL (Extract Transform and Load)
ETL/SSIS/Azure Data Factory
Evènements
Events
eventstream
Excel
Execution Plan
Execution plans
execution time
expert
Extended Events
Extended Stored Procedures
External SQL Tools
External Table
Extract, Transform, Load (ETL)
fabric
Fabric Capacity
Fabric Databases
failover
Failover Clustered Instance (FCI)
Failover Clusters
FAISS
Feature Flags
Featured
file permissions
Files
Filtered Index
Filtered Indexes
Fin de saison
Find homes at risk of tornado damage with SQL queries
Find properties in a tornado warning using SQL Server
finops
First Responder Kit
First Responder Kit Updates
FIRST_VALUE
Fiscal Year
Floating-point precision
flyway
Folders
Forced_Plan
forecast
Fragmentation
Framework
Frappe
Free Stuff
Full Load Code
Full Load Concept
Full-Text Search
Fulltext Indexes
functions system
Fuzzy Match
Fuzzy Search
gamma
Gateway
GCP
GCS
Gemini
General
General Analytics
GENERATE_SERIES()
generative ai
Generative AI (GenAI)
geocode
Geospatial analytics for P&C insurance using SQL Server
GET_BIT
ghost cleanup
Girhub Copilot
GIS-based catastrophe modeling for property insurance
Gist Indexes
Git
GitHub
Gold Layer
Google
Google Cloud
google cloud platform
Google Cloud SQL
gourneur de ressources
Graph databases
GraphQL
graphs
greenit
GREP
grillen
Group Managed Service Accounts
guardduty
Guides de plan
HA
HA/DR/AG/FCI/Clustering/Business Continuity
Hacking MySQl
HADR
Hardware
Hash Index
Haute disponibilité
hierarchical data
hierarchies
HierarchyID
High Availability (HA)
hiring
Histoire
historisation des données
Homepage
hors série
hot standby
How insurers use SQL Server to track tornado damage
How to check if a location is inside a polygon in SQL Server
How to use SQL Server GIS functions for insurance analytics
How would you design this
Humor
Hyper-V
Hyperscale
Hyperscale database
HyperV
IA
IaaS
Identifying tornado path exposure in SQL Server databases
identity
IIF function
images
In-Memory OLTP (Hekaton)
Incremental Load
Incremental Load Code
Incremental Load Concept
Index
Index Maintenance
Index Tuning
indexes
indexing
Indicateurs de jointure
Indicateurs de requête
indicateurs de table
informatica
INFORMATION_SCHEMA
Initialization
Initialization Files
INSERT
Install
install AdventureWorks
Installation
Instant File Initialization
instantané de bases de données
integration
integration service development
Integration Services
Integration Services (SSIS)
Intelligent Query Processing
internals
Interviewing
IQP
ISNULL
Isolation Levels
java web development
Javascript
Jeff Moden
John F. Miner III
JSON
JSS
Jupyter Notebook
Kafka
Key Vault
kql
L&D
LAG
LAG function
lakehouse
langage SQL
Laravel
large datasets
Large Language Model
Large Language Models
large pages
LAST_VALUE
LDF files
LEAD
Learn
Learn SQL Server
LearningPostgreSQLWithGrant
LEFT_SHIFT
Licensing
ligne
like
lingen
linked server
Linked Servers
Livy Session
LLM
load patterns
Lock page in memory
Locking
locking and blocking
locking contention
Locking, Blocking, and Isolation Levels
log files
LogAnalytics
logging
Louis Travel
LouisDavidson_LLMTechEditing
LukasVileikis_MySQLBasics
M Langauge
Machine Learning
Machine Learning (ML)
Machine Learning Services (MLS)
Magasin de requête
Manage elastic jobs in Azure
Managed Identity
Managed Instances
Managed Tables
Management Data Warehouse
Management Studio (SSMS)
MariaDB
MariaDB Server
Market Based Analysis
Master Data Management (MDM)
Mathematical functions in SQL
MDF File
MDF files
MDS
MDX
Medallion architecture
Meetup
mémoire
Mémoire compressée
Memories
Memory Grant Feedback Persistence
memory usage
Mes sessions
messaging
Meta Data Driven Design
metadata
Microsoft
Microsoft Azure
Microsoft Fabric
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
Microsoft Spark Utilities
Microsoft SQL Server
Microsoft SQL Server (MSSQL)
Microsoft SQL Server 2022
microsoftfabric
migrate ssis environment
migration
Minimal Logging
minimal path
Mirroring
modélisation
MongoDB
MongoDBSeriesRobertSheldon
monitoring
MS SQL
MS SQL Server
MS SQL Server Agent
msbuild
MSDTC
msfabric
MSFTAdvocate
MSSQL administration
MSSQLSERVER
multithread
MySQL
MySQL Books
MySQL Database
MySQL Server
Nantes
Natural Language Processing
New database
new feature
New Feature of SQL Server
News
NewSQL
niveau d'isolation
Non classé
Normalization
NoSQL
notebook
Nouveautés
ntile
NULL
NUMA
object storage
OLTP database
One Lake Explorer
onedrive
OneLake
openai
OpenRowSet
opensource
Opinion
Opinion Pieces
Optimisation
optimiseur
optimiste
optimization
Optimized Plan Forcing
Oracle
Other Development
OVER()
parallelism
parallelisme
Parameter Sensitive Plan Optimization
Parquet
Parquet files
PARSE Function
Parsing
partitioning
PASS
PASS Data Community Summit
PASS Data Summit
PASS Summit
PassDataSummit2023
PASSSummit2024Posts
PCA
Peforfmances
Percona
Percona Server
Performance
performance analysis
Performance and Tuning
performance enhancement
performance metrics
Performance Tuning
Performances
performnces
Personal
pessimiste
PGConf
PGConfEU
pipeline
Plan Cache
PlanetPostgreSQLGrantFritchey
PlanetPostgreSQLHenriettaDombrovskaya
PlanetPostgresqlRyanBooz
plotly
Podcast
Polyglot
postgres
PostGreSQL
PostGreSQL vs SQL Server
Power Automate
Power BI
Power BI datamarts
Power BI Embedded
Power BI Premium
Power Query
PowerBI
powerbipremium
PowerPivot/PowerView/PowerQuery/PowerBI
Powerpoint
PowerShell
PPU
PRA
Premium
Presentation
Presentations
Primary Key
Primary Key (PK)
Processes and Practices
Product News, Releases, and Upgrades
Production Database Administration
Productivity
Professional Development
Programming
Programming Language
programming standards
project
PSP optimization
PySpark
Python
python tutorial
Quality Zones
queries
query
Query Exercise Answers
Query Exercises
query inte.ligence
query optimization
query optimizer
Query performance
query plan
Query plans
Query Store
query tuning
queryperformance
Queue
Queue processing
Queues
R Language
rabbitmq
Radians
Radians function
RAG
raiserror
RAM
RANK()
Ranking Functions
Raw
RDBMS
RDS
RDS SQL Server
Real-Time Intelligence
recherche
recompile
Recursive CTE
RedGate
Redgate Software
Registered Servers
réglage au scope de la base
relational database service
rename
repère de plan
Replication
Reporting
Reporting Services (SSRS)
requetes ad hoc
requirements analysis
Resources
REST API
Restore backup
restore database
Retail analytics
Retrieval Augmented Generation
RIGHT_SHIFT
Risk aggregation for tornado-prone properties using SQL Server
RLS
RLS Performance
RLS Troubleshooting
ROW_NUMBER
row-by-row update
Row-Level Security (RLS)
Rust
S3
Sails.js
Salary
Sales
sauvegarde
Sauvegardes
Scala
Scale-Out
ScaleOut
schema
Schemas
scripts SQL
Search Architecture
Search Performance
Sécurité
Sécurité au niveau ligne
Security
Security and Compliance
Security Audit
Security Policy
Semantic Model
Semantic Search
semantic-link-labs
sempy_labs
Sentence Embeddings
Sentence Transformers
sequence
Sequence Object
Serverless
SET_BIT
Sharding
SharePoint
Side-channel attack
Silver
Similarity Search
Simple-Talk
SimpleTalk
single row table
snowflake
Snowflake Change Data Caputre
snowflake schema
Snowflake Security
Snyk
Software Architecture Conference
Software Delivery
Software Development
software testing
Software Tools
Source Control
sp_configure
sp_rename
Spark
Spark SQL
Spatial
Spatial Data
Spatial Data Types
Spatial Indexes
Speaking
Sponsoring
sponsorship
springboot
SQL
SQL 2022
SQL Analyhtics Endpoint
SQL Azure
SQL best practices
SQL binary functions
SQL Books
sql cluster
SQL Clustered Instance
sql commands
SQL Compare
SQL ConstantCare
SQL conversion errors
SQL Data Exploring
SQL Database
SQL DBA
sql developer
SQL Development
SQL Endpoint
SQL function usage
Sql Functions
SQL Index
SQL Injection
SQL Jobs
SQL Management Studio
sql monitor
SQL optimization
SQL Performance
SQL programming
SQL Prompt
SQL Queries
SQL Query
SQL Query Examples
SQL Query Optimization
SQL Saturday
SQL Script
SQL Security
SQL Server
SQL Server 2012
SQL Server 2016
SQL Server 2016 Performance
SQL Server 2017
SQL Server 2017 on Linux
SQL Server 2019
SQL Server 2022
SQL Server 2022 Blogging Series
sql server 2022 new feature
SQL Server 2023
SQL Server 2025
sql server auditing
SQL Server backup
SQL Server CEIP
SQL Server commands
SQL Server Data Services
SQL Server Data Tools (SSDT)
SQL Server Development
SQL Server Examples
SQL Server Graph Database
SQL Server guide
SQL Server Instance
SQL Server internal storage
SQL Server Management Studio
SQL Server Migration
SQL Server on Azure Virtual Machines
SQL Server on Linux
SQL Server polygon intersection for home location mapping
SQL Server Population Report
SQL Server Queries
SQL Server Resumable Index Operations
SQL Server sample database
SQL Server Security
SQL Server spatial data for risk assessment in insurance
SQL Server spatial functions for tornado risk analysis
SQL Server spatial indexing for faster catastrophe modeling
SQL Server spatial queries for disaster preparedness
SQL Server spatial queries for insurance catastrophe modeling
SQL Server STIntersects() example for geographic data
SQL Server tips
SQL Server tuning
SQL Server tutorial
SQL Server update operations
sql server update statement
SQL Server Upgrade
sql server views
SQL testing
SQL Tips
SQL Toolbelt
SQL Tools
SQL troubleshooting
SQLBits
sqlcmd
SQLEndpoint
SQLFamily
SQLSaturday
SQLServerCentral
SSAS
SSAS Tabular
SSIS
SSIS Catalog migration
SSIS deployments
SSISDB
SSMS
SSMS21
SSRS
stack overflow
star schema
State of the Business
stateofdatabaselandscapesurvey
statistics
Statistiques
steps to add new shared disk to WSFC
STGeomFromText SQL Server example for polygons
Storage
stored procedures
streamlit
strings parsing
Strong File Format
STUFF
Subqueries
Subquery
SummitSpeaker2023ItzikBenGan
surveillance
svn
Synapse
sysadmin
System Prompt
system resources
System Versioned Temporal Tables
system_internals_partition_columns
t-sql
T-SQL Challenges
T-SQL Coding
T-SQL functions
T-SQL Programming
T-SQL tips
tab coloring
table
Table Migration
Table Structure
Table Valued Function (TVF)
Table-Valued Parameter
tables
tables temporaires
tables temporelles
Tech Editing
tempdb
TEMPLATE
Temporary Stored Procedures.
Test Data
Test database
Test Driven Development (TDD)
Testing
Text Embeddings
The Curious Case of...
The Query Store
Theory and design
THROW
time intelligence
time series
Time Series Analysis
Time Series Data Warehouse
Tools
Tools for development
Tornado exposure analysis for home insurance claims
Training
Transact SQL
transaction log
transactions
tree
Trigonometric functions
TRY_CONVERT Function
TRY_PARSE Function
TRY..CATCH
TSQL
TSQL Tuesday
tSQLt
Tuning
type de données
Uncategorized
Underwriting automation with SQL Server geospatial analysis
Unicode
UNION
UNION ALL
Unique Index
Unmanaged Tables
UNPIVOT
Unstructured Data
updatable views
Update
update statement
Upgrades
upgrading
User Prompt
Using SQL Server geography data type for disaster risk mapping
Using SQL Server to assess tornado impact on insured homes
valeur
variables
Vector Database
vector databases
VEEAM
Vendors/3rd-party Products
verrou
verrouillage
Vettabase
Videos
Views
viol de la 1FN
Virtualisation
Virtualization, containers, and k8s
Visual Studio
Visual Studio Code
Visual Studio SSDT
VM
vmware
vorder
VS Code
vues indexées
warehouse
Weak File Format
Web
Web development
Web Frameworks
web service
Webinar
Webinars
What Counts For A DBA
Who's Hiring
Window Functions
Windows 2022
Windows Cluster
Windows Server
WSFC
XMLA
XtraBackup
youtube