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
@@DATEFIRST
@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 Predicate
accounting
ADF
ADF Dataflow
ADF Interview Questions
ADF Mapping Dataflow
ADF Questions
Administration
Adoption
ADS notebooks
Advanced Querying
Advanced SQL
Adventure Works Schema
AdventureWorks
AG
Aggregate
aggregate function
Aggregates
aggregation
AI
Always On Availability Group
AlwaysOn
amazon
Amazon EC2 Instance
Amazon RDS
amazon rds instance
Amazon Redshift
Amazon Web Services (AWS)
aMS
Analyse
Analysis Services
Analysis Services (SSAS)
Analytics
Announcements
Apache Druid
Apache Spark
APPLY
Architecture
ARM template
Artificial Intelligence
Artificial Intelligence (AI)
AsAzureRedirection
ASP.NET
Assert transformation
audit
Auditing
auto-incréments
automate
Automated Deployments
automatedlab
Automatic tuning
Automation
Autour de l'auteur
Availability Group (AG)
availability groups
AWS
AWS DMS
AWS RDS SQL Server
azsure sql database
Azure
Azure - Cloud
azure acloud shell
Azure Active Directory
Azure AD
azure ai
Azure Automation
Azure BLOB Storage
Azure Cognitive Services
Azure Cosmos DB
Azure Data
Azure Data Explorer (ADX)
Azure Data Factory
Azure Data Factory Interview Questions and Answers
Azure Data Lake
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 Policies
Azure Policy
Azure Purview
Azure SQL
Azure SQL Database
Azure SQL DB
Azure SQL maintenance
Azure SQL Managed Instance
azure sql server
Azure Storage
Azure Storage Monitoring
azure synapse
Azure Synapse (formerly Azure SQL Data Warehouse)
Azure Synapse Analytics
Azure VM
AzureAnalysisServices
azureautomation
azurerm
azuresql
B-Tree Indexes
Back to Basics
BACKUP
Backup and Recovery
Backup and restore
Backup-Restore
backups
bar
bard
barisopen
baropen
Base de données
bases de données exemple
Basket Analysis
Batch Execution Mode on Rowstore in SQL Server 2022
beer
benJohnston_Audit
BenJohnston_DynamicDataMasking
BenJohnston_ETL
BenJohnston_RLS
Best Practices
BestPractice
BI
Big Data
Bing chatbot
BIT
bitcoin
blocage
blockchain
blocking
Blocking in SQL Server
Blogging
Blogs
books
BPA
branching strategy
Breaking News
Bronze
bulk insert
bulk logged
business intelligence
business logic
Business Rules
C#
cache
Calandar
calculated columns
calendar
Calendar Function
Calendar Table
Cardinalities
Career
Career Growth
CASE Equivalent
cassandra
CassandraDB
CEIP
Certification
Certifications
CETAS
Change Data Capture
ChatGPT
CI/CD
Classes
Claude
clonage d'une base
cloud
cloud analytics
Cloud Computing
cloud computing costs
Cloud Data Management
cloud database
cloud migration
Cloud Performance Testing
cloud security
cloud services
cloud shell
cloud strategy
cloud technology
CLR
Club Power BI
ClubPowerBI
cluserting
Clustered Index
co-pilot
code
coeurs
collation
ColumnStore Index
Columnstore Indexes
Combine
Common Language Runtime (CLR)
Common Table Expressions (CTE)
Community
Company News
comparaison
compatibilité
Composite Index
computer security
Concurrency
Conference
Conferences
Conferences and Classes
Conferences, Classes, Events, and Webinars
Configuration
Configuration Settings
ConnectionString
Consulting
Consulting Lines
containers
Containers and Virtualization
continuité
Convert
Copilot
Corruption
CosmosDB
covering index
CPU
create C# objects
CREATE OR ALTER
cross apply
crowd
CSA
CSV files
CTE
Culture
Customer Stories
Cyber Security
Cyber Security Training
cybersecurity
dalle
Data
data analysis
Data Analytics
data analytics tools
Data Conversion
Data culture
data engineering
Data Exploration
Data Factory
Data Factory Questions
Data Generation
data governance
data in the cloud
Data Joins
Data Lake
Data Lakes
data life cycle
data lineage
Data Loading
Data Masking
Data Migration
data mine
Data Mining
Data Modeling
data platform
data protection
Data Quality Services (DQS)
data residency
data retention
Data Science
Data Security
data security in the cloud
Data Storage
data studio
Data Types
Data Validation
Data Virtualization
Data Warehouse
Data Warehouse ETL simplification
Data Warehouses
Data Warehousing
Data WarehousingBusiness Intelligence
Data Wrangler
Data Wrangler Extension
dataandanalytics
Database
Database Administration
database as a service
Database Design
Database Design and Implementation
Database Development
Database DevOps
Database Maintenance
database management
database migration
database modelling
database monitoring
Database objects
Database Performance
Database Project
Database Reporting and Administration
Database Security
Database Space
database testing
Database Theory
Databases
Databricks
DataChouette
dataflow
datagrillen
DataLake
datalakehouse
Datamarts
DataOps
datawarehouse
date
Date Calculations
Date computation
date conversion
Date Difference
Date Functions
DATEADD
DATEDIFF
DATENAME
DATEPART
Dates
datetime
Datetime conversions
Datetime Functions
DAX
DBA
DBA tips
DBA Tools
dbatools
DBCC IND
DBCC PAGE
DDL Triggers
deadlocks
DELETE
DELETE Statement
Delta
Delta Tables
DENSE_RANK()
dependent columns
Deployment Pipelines
deployments
Descending Index
Design
Design and Theory
Developer
development
DevOps
DevOps and Continuous Delivery (CI/CD)
Dijkstra
DimDate
Dimensions
DirectLake
Disk
DMV
docker
Drop Column
drop columns
Dynamic Data Masking
Edition spéciale
editorial
Editorials
Elastic Jobs
elt
Email
embeddings
Empowering Users
Encryption
Erase Hive Tables
Error Handling
Error Log
EsProc SPL
Ethical Hacking Tutorial
ETL
ETL (Extract Transform and Load)
ETL/SSIS/Azure Data Factory
Evènements
Events
eventstream
Excel
Execution Plan
Execution plans
Explicit Transactions
Extended Events
External SQL Tools
Extract, Transform, Load (ETL)
fabric
Fabric Capacity
Failover Clustered Instance (FCI)
Failover Clusters
Feature Flags
Featured
FILEPROPERTY()
Files
Filtered Index
Filtered Indexes
Fin de saison
finops
First Responder Kit
First Responder Kit Updates
FIRST_VALUE
Flowlets
flyway
fnTally
Folders
Forced_Plan
forecast
format
Fragmentation
Framework
Free Stuff
Free tools
Full Load Code
Full Load Concept
Fulltext Indexes
functions system
gamma
Gateway
GCP
GCS
Gemini
General
GENERATE_SERIES()
Generating Data
generative ai
Girhub Copilot
Git
GitHub
Go Lang
golang
Gold Layer
Google Cloud
google cloud platform
Google Cloud SQL
Graph databases
graphs
GREP
grillen
group by
guardduty
HA
HA/DR/AG/FCI/Clustering/Business Continuity
Hacking MySQl
HADR
Hash Index
Haute disponibilité
HierarchyID
High Availability (HA)
hiring
Histoire
historisation des données
Home Office
Homepage
hors série
hot standby
How would you design this
Humor
Hyper-V
Hyperscale
Hyperscale database
HyperV
IA
IaaS
iac
identity
Idera
images
In-Memory OLTP (Hekaton)
Incremental Load Code
Incremental Load Concept
Index
Index Maintenance
Index Tuning
indexes
indexing
informatica
INFORMATION_SCHEMA
Initialization
Initialization Files
INSERT
INSERT EXEC
Inside the Storage Engine
Install
Installation
Instant File Initialization
instantané de bases de données
integration
integration service development
Integration Services
Integration Services (SSIS)
Intelligent Query Processing
internals
Interview
interview questions
Interviewing
inutiles
Isolation Levels
J'améliore mon travail
java web development
Javascript
Jeff Moden
John F. Miner III
JSON
JSS
Jupyter Notebook
Kafka
kql
L&D
LAG
LAG function
lakehouse
langage SQL
Large Language Model
large pages
LAST_VALUE
LEAD
Learn
Learn SQL
Learn SQL Server
LearningPostgreSQLWithGrant
Licensing
lingen
linked server
Linked Servers
Livy Session
LLM
load patterns
Lock and Connection Management
Lock page in memory
Locking
locking and blocking
Locking, Blocking, and Isolation Levels
Log
Log File
log monitoring
LogAnalytics
LukasVileikis_MySQLBasics
M Langauge
Machine Learning
Machine Learning (ML)
Machine Learning Services (MLS)
Manage elastic jobs in Azure
Managed Identity
Managed Instances
Managed Tables
Management Data Warehouse
Management Studio (SSMS)
MariaDB Server
Market Based Analysis
Master Data Management (MDM)
MDS
MDX
Meetup
mémoire
Mémoire compressée
Memory Grant Feedback Persistence
Mes sessions
messaging
Meta Data Driven Design
metadata
Microsoft
Microsoft 365
Microsoft Azure
Microsoft Fabric
Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
Microsoft Learning
Microsoft Server Integration Services
Microsoft Spark Utilities
Microsoft SQL Server
Microsoft SQL Server (MSSQL)
Microsoft SQL Server 2022
microsoftfabric
migrate ssis environment
migration
Minimal Logging
minimal path
mm/dd/yyyy date format
modélisation
MongoDB
monitor
monitoring
motif
MS SQL Server
MS SQL Server Agent
MSBI
MSBI- SSIS
msbuild
msfabric
MSFTAdvocate
MSSQL administration
multithread
MySQL
MySQL Database
MySQL Server
Nantes
New database
new feature
New Feature of SQL Server
News
Non classé
Normalization
NoSQL
notebook
Nouveautés
ntile
NULL
NUMA
object storage
Office 365
OKR
One Lake Explorer
onedrive
OneLake
openai
OpenRowSet
opensource
Opinion
Opinion Pieces
Optimisation
optimiste
optimization
Optimized Plan Forcing
Oracle
other da
Other Development
Outlook
OVER()
paas
parallelism
parallelisme
Parameter Sensitive Plan Optimization
parameter sniffing
Parameters
Parquet files
Parsing
partitioning
PASS
PASS Data Community Summit
PASS Data Summit
PASS Summit
PassDataSummit2023
PCA
Peforfmances
Percona
Percona Server
perfmon
Performance
performance analysis
Performance and Tuning
performance enhancement
performance testing
Performance Tuning
Performances
performnces
Personal
pessimiste
PGConf
PGConfEU
PII data
pipeline
Plan Cache
PlanetPostgreSQLGrantFritchey
PlanetPostgreSQLHenriettaDombrovskaya
PlanetPostgresqlRyanBooz
plotly
Pluralsight
Podcast
postgres
PostGreSQL
PostGreSQL vs SQL Server
Power Automate
Power BI
Power BI datamarts
Power BI Desktop
Power BI Embedded
Power BI Goals
Power BI Metrics
Power BI Premium
Power BI Report Server
Power Query
PowerBI
powerbipremium
PowerPivot
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
Professional Development
Programming Language
PSP optimization
Publishing
PySpark
Python
python tutorial
Qlik
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
Quest
Queue
Queue processing
Queues
R Language
rabbitmq
RAG
raiserror
RAM
Randomness
RANK()
Ranking Functions
Raw
RBAR
RDBMS
RDS
RDS SQL Server
Real-Time Intelligence
recherche
Recursive CTE
RedGate
Redgate Software
Registered Servers
relational database service
rename
Replication
Report Builder
Reporting Services
Reporting Services (SSRS)
requetes ad hoc
Requêtes de métadonnées
Requetes MS SQL Server
requirements analysis
Resources
REST API
Restore backup
Retail analytics
Retrieval Augmented Generation
RLS
RLS Performance
RLS Troubleshooting
Row Versioning
ROW_NUMBER
Row-Level Security (RLS)
Rust
S3
Sails.js
Salary
Sales
Scale-Out
ScaleOut
schema
Schemas
script activity
Scripts
scripts SQL
secure data
Sécurité
Sécurité au niveau ligne
Security
Security and Compliance
Security Policy
SELECT *
Semantic Model
semantic-link-labs
sempy_labs
sequence
Sequence Object
Serverless
Sharding
SharePoint
Shrinking Database
Side-channel attack
Silver
Simple-Talk
single row table
snowflake
Snowflake Change Data Caputre
snowflake schema
Software Architecture Conference
Software Delivery
Software Development
software testing
Software Tools
Source Control
sp_configure
sp_rename
Spark
Spark SQL
Spatial Indexes
Speaking
splunk
splunk DB connect
springboot
SQL
SQL 2022
SQL Analyhtics Endpoint
SQL Azure
SQL Backup
SQL CLR
sql cluster
SQL Column
sql commands
SQL Compare
SQL ConstantCare
SQL Data Exploring
SQL Database
SQL DBA
sql developer
SQL DMV
Sql Functions
SQL in Sixty Seconds
SQL Index
SQL IO
SQL Jobs
sql ledger
SQL Log
sql monitor
SQL Performance
SQL Prompt
SQL Query
SQL Restore
SQL Saturday
SQL Script
SQL Scripts
SQL Security
SQL Server
SQL Server 2016
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 CEIP
SQL Server Configuration Manager
SQL Server Data Files
SQL Server Data Services
SQL Server Data Tools (SSDT)
SQL Server Files
SQL Server Graph Database
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 Population Report
SQL Server Resumable Index Operations
SQL Server Security
SQL Server Upgrade
sql server views
SQL Server; Performance
SQL Tips and Tricks
SQL Toolbelt
SQL Tools
SQL Video
SQLAuthority News
SQLBits
SQLCLR
sqlcmd
SQLFamily
SQLSaturday
SQLServerCentral
SSAS
SSAS Tabular
SSIS
SSIS Catalog Compare
SSIS Catalog migration
SSIS deployments
SSIS Integration Runtime
SSISDB
SSMS
SSRS
stack overflow
star schema
State of the Business
stateofdatabaselandscapesurvey
statistics
Statistiques
Storage
storage spaces
stored procedures
strings parsing
Strong File Format
Subqueries
Subquery
summit
SummitSpeaker2023ItzikBenGan
suppression
surveillance
svn
Synapse
System Database
system functions
System Prompt
system_internals_partition_columns
t-sql
T-SQL Coding
T-SQL Programming
tab coloring
Table Migration
Table Structure
Table Valued Function (TVF)
Table-Valued Parameter
tables
tables temporaires
tables temporelles
Tech Editing
tempdb
TEMPLATE
Temporary Stored Procedures.
terraform
Test Data
Test database
Test Driven Development (TDD)
Testing
The Curious Case of...
The Query Store
Theory and design
THROW
time series
Time Series Data Warehouse
Tips and tricks
Tools
Tools for development
Transact SQL
transaction log
Transparent Data Encryption (TDE)
tree
Triggers
Troubleshooting
TRY..CATCH
TSQL
TSQL Tuesday
tSQLt
TSQLUnit
Tuning
type de données
Uncategorized
Unicode
Unique Index
Unit Test
Unit Testing
Unmanaged Tables
UNPIVOT
updatable views
Update
Upgrades
upgrading
User Prompt
variables
vector databases
Vendors/3rd-party Products
verrou
verrouillage
Version Control Systems (VCS)
Videos
Views
viol de la 1FN
Virtual Machines
Virtualisation
Virtualization, containers, and k8s
Visual Studio
Visual Studio Code
Visual Studio SSDT
Viva Goals
VM
vmware
vorder
VS Code
vues indexées
Wait Stats
warehouse
Weak File Format
Web
Web development
Web Frameworks
web service
Webinar
Webinars
WEEK
Weeks
What Counts For A DBA
Who's Hiring
Window Functions
Windows
Windows Cluster
Windows Server
Writing
WSFC
XMLA
XtraBackup
youtube