Recherche Contenu : Catégories : A la Une Business Intelligence Sites anglophones Sites francophones Sites Microsoft Videos Tags : .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 Assert transformation 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 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 computing costs 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 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 life cycle data lineage Data Loading data manipulation Data Migration 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 Type Conversion Data Types Data Validation 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 Deployment Database Design Database Design and Implementation Database Development Database DevOps 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 expressions in SQL DATEADD DATEDIFF DATEPART function datetime DAX DBA DBA tips DBA Tools DBAs dbatools DBCC CHECKDB DBCC CHECKPRIMARYFILE DBCC IND DBCC PAGE dbt DDL Triggers deadlocks Deepseek 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 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 Floating-point precision flyway Folders Forced_Plan forecast Fragmentation Framework Frappe Free Stuff Free tools 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 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é 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 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 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 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 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 springboot SQL SQL 2022 SQL Analyhtics Endpoint SQL Azure SQL best practices SQL binary functions SQL Books sql cluster 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 Prompt 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 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 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 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 series 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 Unique Index Unmanaged Tables UNPIVOT Unstructured Data updatable views Update 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 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 Cluster Windows Server WSFC XMLA XtraBackup youtube