Using the Default Trace in SQL Server
The Subtle Differences Between COALESCE and ISNULL
[Video] Office Hours in the Home Bar
An Introduction to SQL Commands, Part 1
A Method for Managing Hierarchies in PostgreSQL
Your SQL Server Needs Spring Cleaning, Too.
LLM Technical Editor Test – ChatGPT with a VERY wrong article
The Fabric Modern Data Platform
Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
Announcing Database Frontiers: a Database Conference You Haven’t Yet Heard About
Oracle’s Limited Cloud Vendor Licensing
Updated First Responder Kit and Consultant Toolkit for April 2025
New Series – Testing LLMs as Technical Editors
How to Remove Constraints from a SQL Server Table
Creating a Date Dimension (Calendar Table) in SQL Server
The Waitlist is Open Now for My SQLBits Workshop!
The complexity of using Power BI in US Sovereign Clouds
Elements of the SQL Server Update Statement
[Video] Office Hours in North Bay, Canada
Tap Tap Tap – Short, Silent SQL Server Tutorials
Killing a SPID and Checking Rollback progress in SQL Server
Free Webcast: Avoiding Deadlocks by Query Tuning
Data Elements on a Nominal Scale
Free Webcast Tomorrow: Fundamentals of Columnstore
Navigating Your Test Data Challenges: Insights and Solutions
Introduction to GitHub Actions Part 1: Getting Started
Understanding UNION and UNION ALL in SQL Server
DAX CASE Statement Functionality using IF, SWITCH and SWITCH True
Windows Clustered MSDTC and SQL Server 2019 mishap
Qu’est ce qu’un expert en informatique ? Comment le devient-on ?
Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant
Fabric Database: Advanced Vector Search Features
Fundamentals Week 2025 is Coming This Month! Get Your Tickets Now.
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Retour à chaud de la FabCon 2025
Free Webcast Tomorrow: Fundamentals of TempDB
Sponsoring SQL Saturday Richmond This Week
Managed Instance Gotchas – Error Conditions
DeepSeek: What is new with this AI technology?
Load Data into Snowflake Using Python with Pandas
Basic Regex Emulator for SQL Server
Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
[Video] Office Hours: Back in the Home Office
Fabric: Query a SQL Endpoint from a Notebook
Query Exercise Answer: Finding Email Addresses
Improving the Performance of UPDATE Statements in SQL Server
Why Your Azure SQL DB Hyperscale Bill is Higher Than You’d Expect
SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG
Dynamic T-SQL Script Parameterization Using Python
Fabric Analytics for SQL folks: Part 1 – Fabric demystified
MySQL vs PostgreSQL – String Datatypes
[Video] Office Hours: Waiting for the Hot Tub to Fill
T-SQL Has Regex. Don’t Get Too Excited.
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
AI Tools for Job Seekers – Salary
VEEAM backup et SQL Server… Le piège a con !
Query Exercise: Looking for Email Addresses
MySQL vs. PostgreSQL: Character Sets and Collations
Free Webcast Tomorrow: Fundamentals of Query Tuning
Pitfalls to avoid while feeding events into CrowdStrike
Using SQL Server Stored Procedures with the Django ORM
Data Streaming Databricks in Azure
What’s Coming in SQL Server 2025, DMV Edition
Announcing Fundamentals Week 2025!
How I Achieved Scalability in a. Amazon RDS Shared DB Connection Environment
Free Webcast Tomorrow: Fundamentals of Index Tuning
Deploy DACPAC to Azure SQL Database using Visual Studio
INFO.VIEW DAX Functions Usage and Examples
The State of the Database Landscape in 2025: Insights and trends
How to Download and Restore AdventureWorks 2019 Database
[Video] Office Hours: Philosophical Questions at the Waterfall of the Gods
How Shortcuts affect Lakehouse’s Maintenance
Free SQL Server Spring Training Live Webcasts Start Next Week.
Importing and exporting data in MongoDB Compass
Understanding the Logical Functions IIF and Choose in SQL Server 2022
The Power of Generate_series
Implementing Enterprise Data Security in Snowflake: Practical Concepts
Who’s Hiring in the Microsoft Data Platform Community? March 2025 Edition
Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
How to Download and Restore AdventureWorks 2022 Database
SQL Server Backup or Restore using Network Share with SSMS
MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization)
Office Hours: Unusual Beach Chair Edition
Finding Out What Changed in a Cumulative Update
Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric
Engineering a Lakehouse with Azure Databricks with Spark Dataframes
Vertical Partitioning Is Almost Never the Answer. Here’s Why.
Beyond Single-Cloud: A Peek into Multi-Cloud
Crazy number of Parameters… and a challenge
How to use the Azure Emulator to create blob containers, queues and tables
Upgrade and Migrate SSIS Catalog and SSISDB to a New Server
Configuring Maintenance Plans in SQL Server
[Video] Office Hours: We’ve Got the (Honda) Beat
Fabric Databases Connection Secrets
Why I Mention My Sexuality and Gender
Index Rebuilds Make Even Less Sense with ADR & RCSI
How to Resolve SQL Server Database Stuck in Recovery Pending State
I’m Doing Free SQL Server Spring Training Live Webcasts. Register Now.
MinIO : sauvegarde et tables externes SQL Server
AI in SQL Server 2025: Embeddings
SQL Server 2022 CU Updates and Error Code 0x851A0043
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022
Find Text in Stored Procedure, Function, View, or Trigger
Implementing Vector Datatype with Azure SQL Server
Fun with PowerShell Asynchronous
MySQL Index Overviews: Descending B-Tree Indexes
SQL Server External Tables : archivage et externalisation
[Video] Office Hours: Hawaiian Edition
I’m coming to Jacksonville and Raleigh for SQL Saturday! Register now.
Exploring Scalar Solutions to Complex Data Math
Using Group Managed Service Accounts with SQL Server
How to Develop Solutions with Fabric Data Warehouse: Data Engineering with Fabric
The 8 Worst Things Microsoft Ever Did to SQL Server
SQL Database Project in Azure Data Studio
SQL Server BIT_COUNT and an Alternative
Understanding Data Type Conversion Functions in SQL Server with PARSE, TRY_PARSE, and TRY_CONVERT
How to use @@ROWCOUNT in SQL Server
SQL ConstantCare® Population Report: Winter 2025
Who’s Hiring in the Microsoft Data Platform Community? February 2025 Edition
The 6 Best Things Microsoft Ever Did to SQL Server
An Effective Approach for High Volume Data in Azure Synapse
Dark Mode in SSMS 21 and overall first impressions
Frappe and Laravel: Database Management and Migrations
JSON in Microsoft SQL Server: A Comprehensive Guide
How to rename a SQL Server database
Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, Languages and Programs
[Video] Office Hours and an AI-Generated Sweatshirt
SQL Endpoint Secrets you need to know
Index Rebuilds Make Even Less Sense with ADR & RCSI.
Creating a Linked Server in Amazon RDS for SQL Server: A Step-by-Step Guide
A Practical Guide to Using Azure Key Vault in Enterprise Deployments
What If You Need to Index a Lot of Duplicate Data?
Creating Time Series Collections in MongoDB
Paires Clé-Valeur dans un contexte de sessions SQL Server
Add and Subtract Dates using DATEADD in SQL Server
Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE
Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL
[Video] Office Hours in My Vegas Backyard
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Navigating the Database Landscape in 2025 Livestream on Feb 12
Can AI Rewrite Bad Queries in Seconds? Kinda.
How to Install SSIS in Visual Studio 2019
Why Standards are Important
SQL Server Integration Services (SSIS) Microsoft Connector for Oracle deprecation
Un GREP pour les bases de données MS SQL Server
Pop Quiz, 2025 Edition: What Do These Things Cost Today?
Loading Models from Source Data with dbt
Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD
MySQL Shell and Basic Configuration Management (Part 2 – Memory and CPU)
Chiffrement des sauvegardes via clés extensible Azure Key Vault
Vector DB implementation using FAISS
Using Snyk for CI/CD Security Scanning
Fabric Copy Job: What’s new in it
The year ahead for SQL Server: Ground to cloud to fabric
Does Separating Data and Log Files Make Your Server Faster?
Announcing the 2025 Data Professional Salary Survey Results.
FinOps pour Microsoft Fabric
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines
I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It
Customizing the Export and import of Parquet Files in SQL Server
Resolving Access Denied Errors During SQL Server Database Attachment
Comparing Groups for Similarities in Power Query – Using Cosine Similarity
[Video] Office Hours: Long Answers Edition
I Feel Sorry for Untrained Developers Using Entity Framework.
A Use Case for Memory-Optimized Tempdb Metadata
SQL Server OPTION RECOMPILE for Simple Queries
How to Load a Fabric Warehouse: Data Engineering with Fabric
Who’s Hiring in the Microsoft Data Platform Community? January 2025 Edition
Data Documents and Common Sense
Why you should avoid Implicit Measures in your Power BI model
Improved RCSI Ghost Cleanup in SQL Server 2022
Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation
2024: the year in books
Five changes to SQL Server I’d love to see
[Video] Office Hours in Tokyo, Japan
Your Favorite Blog Posts & Videos from 2024
Simple Talk 2024 Year in Review
Updated First Responder Kit and Consultant Toolkit for December 2024
How to Attach and Detach Databases in SQL Server
2023 (not a typo!): the year in books
Introduction to MySQL Shell and Basic Configuration Management (Part 1)
Working Today? Take a Break to Fill Out the Annual Salary Survey.
SQL Server Forced Plans Overwite the Query Hash
How to Repair Corrupt MySQL Tables
[Video] Office Hours in Kyoto, Japan
Convert Excel Workbooks to CSV with Microsoft Fabric
Frappe’s Configuration vs Laravel’s Code-Centric Customisation
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Connecting Streamlit to Upload Data to Snowflake
Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimension Tables
[Video] Office Hours in Osaka, Japan
Why a Self-Join Requires Halloween Protection
Save the date for PASS Summit 2025!
Are You Underpaid? Let’s Find Out! My Annual Salary Survey is Open.
When Should You Employ Snowflake Materialized Views?
Feed SQL Server logs into SIEM
Build a Streaming Data Architecture with Apache Kafka and Zookeeper
PASS Summit is going on tour in 2025!
Getting Started with the Data API Builder
TSQL Tuesday #181 – The first SQL Server Feature that made me go “Wow!”
[Video] Office Hours in Zhengzhou, China
Aggregate Functions in Power BI including Running Total, Running Average and Max
Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with Fabric
A gentle introduction to dbt
How to Send Email with SQL Server’s sp_send_dbmail
T-SQL Tuesday #181: Query Store and its evolution
The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner
SQLBits is Coming Back to London in June 2025!
Calculate a Moving Average with T-SQL Windowing Functions
Introduction to Oracle Database for Database Professionals
Granting Permissions in a Fabric Data Warehouse and Lakehouse
[Video] Office Hours at the Petit Ermitage in LA
Love Your Conference Sponsors
MySQL Index Deep Dive: Clustered B-Tree Indexes
Who’s Hiring in the Microsoft Data Platform Community? December 2024 Edition
An introduction to Terraform
SQL IS NULL and SQL IS NOT NULL Examples
Overlapping Ranges in Subsets in PostgreSQL
[Video] Office Hours: Car in the Dining Room Edition
Execute Stored Procedures in the Microsoft GraphQL API
Simplify Data Loading with Fivetran (HVR): Data Engineering with Fabric
Working with MongoDB Indexes
Making Your Learning Plan for 2025
Essential Strategies for Optimizing Snowflake Performance and Reducing Costs
This Is It! Our Annual Black Friday Sale on SQL Server Training…
A First Look at SSMS 21
[Video] Office Hours: Ask Me Database Questions
Hiring and Motivating Technical Polyglots in Data Analytics
Announcing SQL Server 2025
Breaking Down Ignite: A Pragmatic Look at the Conference’s Best Innovations
Updated Training Modules for SQL Server 2019 & 2022
3 Legit Signs It’s Time for Enterprise Edition
Reading and Writing Parquet Files in SQL Server
Announcing Microsoft SQL Server 2025: Enterprise AI-ready database from ground to cloud
SQL ConstantCare® Population Report: Fall 2024
How to Develop Custom T-SQL Code Snippets in Azure Data Studio
Microsoft SQL announcements at PASS Data Community Summit 2024
Explore Pandas in Python to Analyze and Manipulate Tabular Data
MySQL vs PostgreSQL: Numeric Datatype Comparison
Making Temporal Databases Work, Part 3: Saving Data
Office Hours: Guess the Theme Edition
SSMS v21: Dark Mode, Git, Vertical Tabs, and More
KQL: The top of a group in an easy way
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Relationships with Microsoft Fabric GraphQL API
T-SQL Tuesday #180 – Good enough is perfect
Copilot in SSMS is Kinda Like IE in SSMS
Data Control Language (aka Security)
[Video] Office Hours: SQL Server Questions and Answers
A Tidy Database is a Fast Database: Why Index Management Matters
Demystifying Continuous Integration vs. Continuous Delivery: Part 2
Office Hours in the Valley of Fire
Step by step guide to setup PostgreSQL on Docker
Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part II)
PASS Keynote – Day 2 – Redgate
Data Chouette – 1 an déjà !
Data Chouette
Save money on Microsoft SQL Server licensing with Microsoft Azure Arc
Office Hours at the PASS Summit in Seattle
What’s In Your Development Database? The Answer: Production Data
The SQLskills Black Friday Super Sale!
Connecting to MongoDB through Python
Who’s Hiring in the Microsoft Data Platform Community? November 2024 Edition
Watch Me Stream at the PASS Summit for Free!
Your Personal ChatGPT Tutorial
Live webinar – Prioritizing security: Essential strategies for IT leaders
Keeping up with the 2024 PASS Summit
Our Annual Black Friday Sale Starts Now!
Cumulative Update #29 for SQL Server 2019 RTM
A Guide to SQL Security in Django
Optimize SQL LIKE Wildcard Searches
Black Friday Super Sale!
[Video] Office Hours: Let’s Have a Drink
T-SQL Notebooks: Manage Views Source Control and more
Launch Day Bonus: Free Stuff on Friday
Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
Who Actually Buys BrentOzar.com Training?
The Countdown is On: Our Black Friday Sale Starts This Friday!
Leveraging SQL Transaction Control in Python Applications
Audit SQL Server Extended Stored Procedures Usage
Microsoft at the PASS Data Community Summit 2024
[Video] Office Hours: Salem Witchcraft Edition
MySQL Index Overviews: FULLTEXT B-Tree Indexes
Using a Service Account in Microsoft Fabric
[Video] Office Hours: Open Q&A About Databases
What’s In Your Development Database? The Answer: Production Data.
Troubleshoot Chained SQL Server CTE
Microsoft at PASS Data Community Summit 2024!
[Video] SQL Server Always On Availability Groups 101
How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform
Updated First Responder Kit and Consultant Toolkit for October 2024
Data Lake Implementation – Data Lake Zones and Containers Planning
Consistency and Concurrency in NewSQL Database Systems
Uncover SQL Server Missing Indexes
PASS Summit Livestream and on-demand
[Video] Office Hours: Back at Home (Briefly)
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
Should That Be One Update Statement or Multiple?
SQL Server Performances – CHAPITRE 3 – Estimateur de Cardinalité, Intelligent Query Processing (IQP), Query Store, drapeaux de trace…
Azure Managed Instance Download and Restore SQL Server Backup
Enhancing SQL Server Searches with Elasticsearch and Python
Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster
[Video] Office Hours on a Calm Sea Day Off Canada
Poll: What’s In Your Development Database?
Security Update for SQL Server 2022 RTM CU15
Identify CPU Intensive SQL Server Queries from an Implicit Conversion
Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor
Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part I)
Finished Your Training? Get a Certificate of Completion.
[Video] Office Hours in Haines, Alaska: No Bears Here
Microsoft Fabric et Google BigQuery
Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star
How to Delete Large Amounts of Data in Microsoft SQL Server
[Video] Office Hours: Icy Strait Point, Alaska
Why customers love SQL Prompt
Who’s Hiring in the Microsoft Data Platform Community? October 2024 Edition
Announcing the Winners of the Biggest Database Regret Contest
Exploring Time Travel and Row Level Concurrency: Data Engineering with Fabric
Casino night is back at PASS Summit 2024!
The 2024 Black Friday Sale is Coming Next Month.
SQL Index Rebuild vs Reorganize Comparison
Converting Old Running Total Code to Window Functions
[Video] Office Hours: Open Q&A on Microsoft Databases
Diving Deeper into the Import Extension in Azure Data Studio
The PASS Data Community Summit Session Schedule is LIVE!
Free Webcast: How to Think Like the Engine, Big Data Edition
Cumulative Update #15 for SQL Server 2022 RTM
Yes, Cardinality Estimation Keeps Changing After SQL Server 2014.
Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes
TRY/CATCH Doesn’t Always Work.
Simple Talks at the PASS Summit
Boosting Database Development Efficiency Using AI SQL Code Generators
Setup Excel as Front End Application for SQL Server
[Video] Office Hours: Open Q&A About Databases
How To Use Managed Identities in your Azure Logic Apps
Query Exercise Answers: Why Are These 3 Estimates So Wrong?
Microsoft return to PASS Summit 2024 as Sapphire sponsor
SQL Server on Azure VM: Automated Patching Retirement and Replacement with Azure Update Manager
Contest: What’s Your Biggest Database Regret?
AWS Services Using SQL for Big Data Analysis
Download AWS RDS SQL Server Backup
How to Add a New Shared Disk to a WSFC as a SQL Resource
Working with Schema Validation in MongoDB
SQL Server Performances – CHAPITRE 2 – Faut-il paramétrer, régler, tuner son instance ?
Database Sharding: Strategies for Seamless Scaling and Performance Optimization
Introducing the New Stars of Data speakers for PASS Summit 2024
Modernize your database with the consolidation and retirement of Azure Database Migration tools
[Video] Office Hours: Database Q&A
SQL Server がインストールされていないAzure VM において、「Failed to find SQL instance to target」を含むメッセージが記録される
Query Exercise: Why Are These 3 Estimates So Wrong?
Security Update for SQL Server 2019 RTM CU28
Security Update for SQL Server 2022 RTM CU14
Making Temporal Databases Work. Part 3: Saving Data
Devising the Perfect Index for Your Use Case – MySQL Edition
Event Streams for Persistent and Asynchronous Microservice Communication
Delta Table Performance Is Governed By Transaction Size: Data Engineering with Fabric
PASS Data Community Summit Prices Are About to Go Up!
Uniqueness, Keys, and Identity
GitHub Desktop Tutorial
PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant
Using Containers to Avoid Installing SQL Server
SQL ROUND Function vs. Bankers Rounding with T-SQL
Storing and Retrieving the Initialization and Configuration Data for Applications
[Video] Office Hours Q&A: Abrupt Exit Edition
Microsoft Fabric and PySpark: Coding tricks to improve your solutions
Continued feedback for SSMS 21
Geographic Sharding is Usually a Pretty Bad Idea.
I Must Be an Idiot: Automatic Tuning Never Works for Me.
Hotfix: JDBC Driver 12.6.4 for SQL Server Released
Who’s Hiring in the Microsoft Data Platform Community? September 2024 Edition
Solving the Overlap Query Problem in PostgreSQL
How to Slice Data by Fiscal Month using DAX for Power BI Reports
Choosing Data Types and Column Options
Debugging T-SQL using Visual Studio
MySQL Index Overviews: Composite B-Tree Indexes
Microsoft Fabric: Using Lakehouse data in Real Time Dashboards
Is it still worth it to sponsor PASS Summit?
[Video] Office Hours: Abrupt Intro Edition
Released: Microsoft.Data.SqlClient 4.0.6, 5.1.6, 5.2.2
Released: Microsoft.Data.SqlClient 6.0 Preview 1
Hotfix: JDBC Driver 12.8.1 for SQL Server Released
The Big IT Outage: Where are we going?
Query Exercise Answers: Solving the 201 Buckets Problem
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
Is your DevOps strategy missing a vital link?
About Half Of You Don’t Have Your Databases Under Control.
EsProc SPL and SQL, Complimentary , But Different Technologies
Announcement: System.Data.SqlClient package is now deprecated
Effective Strategies for Storing and Parsing JSON in SQL Server
SQL Local Variables and Performance Issues
Released: Microsoft.Data.SqlClient 3.1.7
[Video] Office Hours: Professional Development Q&A
Query Exercise: Solving The 201 Buckets Problem
Introducing Schema Validation in MongoDB
Auditing SQL Server – Part 3 – SQL Server Configuration Audit
A New and Improved Data Warehouse: Data Engineering with Fabric
Released: Microsoft.Data.SqlClient 3.1.6
Make Money Referring Folks to My Training!
Auditing SQL Server – Part 4 – Database Configuration Audit
Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT
Data Prediction with SQL Server Machine Learning Services, Python, and Linear Regression
PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used
10 tips for Test Data Management success
Recover a Database from Suspect Mode Step by Step
Change Data Capture Pipeline Automation in Snowflake
[Video] Office Hours: Ask Me Anything About #SQLServer
Thoughts Before Speaking at the Software Architecture Conference
Modernize Microsoft SQL Server 2014 workloads with Azure
Query Exercise Answer: What Makes SELECT TOP 1 or SELECT MAX Different?
SSIS in One Hour: Hands-On Tutorial
Introducing PASS Summit Charitable Organization Scholarship
SQL ConstantCare® Population Report: Summer 2024 (And Upcoming Gamification Badges)
As a SQL Server DBA, Postgres Backups Surprised Me.
MySQL vs PostgreSQL: Which Open-Source Database is right for you?
Hiring in IT and Relevance of Domain Experience
Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces
Introducing the pre-con schedule for PASS Summit 2024
Free DBA Job Interview Q&A Course This Weekend
Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell
Express a Number or Currency in Words with T-SQL Code
Released: SCOM Management Packs for SQL Server, RS, AS and Azure SQL MI (7.6)
[Video] Office Hours with a Special Guest: Count Distinct
Query Exercise: What Makes SELECT TOP 1 or SELECT MAX Different?
Surveiller l’adoption des Microsoft Fabric Copilots
Choosing a File Format – Data Engineering with Fabric
The full agenda for the Redgate Summit New York is live!
[Video] I Must Be an Idiot: Automatic Tuning Never Works for Me.
MySQL Index Overviews: B-Tree Indexes
Level up your learning in 2024 with PASS Data Community Summit
Create Document Templates in a SQL Server Database Table
Git, GitHub and Visual Studio Code for SQL Server
Days of the Week, Bitwise Edition
Redgate Summit: The Database Landscape – New York
Cumulative Update #28 for SQL Server 2019 RTM
ODBC Driver 18.4 for SQL Server Released
JDBC Driver 12.8 for SQL Server Released
Génération d’une dimension Date pour les modèles sémantiques en Direct Lake
Who’s Hiring in the Microsoft Data Platform Community? August 2024 Edition
[Video] Office Hours in Cabo San Lucas, Mexico
Contrôler la qualité des modèles sémantiques Power BI au fil du temps
Using Registered Servers in SSMS
Getting Started with Azure CLI to Manage Azure Resources
PASS Summit Futures Scholarship
Free Online SQL Server Internals Conference Next Week
5 Ways to Spend Your 2024 Learning and Development Budget in the US
Fall is around the corner, and hence the PASS Data Community Summit, too
Getting Started With Azure Cosmos DB for PostgreSQL
How to Stream Data from Azure Event Hubs into a Fabric Eventhouse
Thoughts About Stack Overflow’s Annual Developer Survey
Migrate a SQL Server Database to a PostgreSQL Database
[Video] Office Hours in a Mexican Hot Tub
Query Exercise Answer: Fixing a Slow Computed Column
Cumulative Update #14 for SQL Server 2022 RTM
Announcing New Membership Tiers: Free & Mentoring
Sécurité : un Patch Tuesday avec 139 correctifs
Index cleanup : Harder than it looks
How to use Jupyter Notebook in VSCode
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
An Introduction to Frappe Framework: Features and Benefits
101 of Troubleshooting SQL Server on Linux
Today’s a Good Day to Talk to Your Manager About Disaster Recovery.
Notebook Jobs in Azure Data Studio
[Video] Office Hours in My Backyard
Query Exercise: Fix This Computed Column.
Effectively troubleshoot latency in SQL Server Transactional replication: Part 2
Effectively troubleshoot latency in SQL Server Transactional replication: Part 1
Auditing SQL Server – Part 2 – Hardware Audit
Configure Microsoft Fabric Database Mirroring for Snowflake
Four steps towards tackling the complexity of managing multiple database platforms
Updated, Larger Stack Overflow Demo Database
T-SQL Tuesday #176 Roundup of advice
Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions
La haute disponibilité des données, un comparatif SGBD PostGreSQL versus Microsoft SQL Server, un billet blog de Frédéric BROUARD
SQL Server, gestion de la performance… et la VM dans tout ça ?
Prompt+ EAP: your AI-powered database development partner in the making
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation
Add Indexes to Improve SQL DELETE Performance
Streaming Event Data through RabbitMQ to a Microsoft Fabric Eventstream
Save $200 by registering for a PASS Summit 2024 3-day ticket before July 16
Working with Documents in the MongoDB Compass GUI
Haute disponibilité – SQL Server vs PostGreSQL
[Video] Office Hours in Bulgaria
SQL Server 2022 分散型可用性グループにおける同期失敗
Announcing Free SQL Server Monitoring.
Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack
Security Update for SQL Server 2019 RTM CU27
Security Update for SQL Server 2022 RTM CU13
Manage OneLake Storage With PowerShell – Data Engineering with Fabric
Redgate recommended in Bloor Test Data Management market update
Docker Logging Guide Part 1: Basic Concepts and Importance
Update: Security hotfix released for OLE DB driver for SQL Server
Announcing SSMS 20.2 … and getting feedback for SSMS 21
It’s a recovery strategy, not a backup strategy
General program for PASS Summit 2024 now available
Meet the new Google AI Assistant Gemini
What does SQL NULL mean and how to handle NULL values
How much Space can I expect to recover from a rebuild after dropping a column?
[Video] Office Hours in Sofia, Bulgaria
Microsoft Fabric, the Land of Wizards and Trolls
Summer School Savings SALE is live!
Announcing the retirement of SQL Server Stretch Database
Save $350 on the PASS Summit if You Register Now.
Prevent Duplicate Records in SQL using Filtered Index
Does Bit Column Order Matter in Tables?
T-SQL Tuesday #176: One piece of advice you wish Past You had
Updated First Responder Kit and Consultant Toolkit for July 2024
Extending Get-Process to show the Process Chain using PowerShell Proxy Functions
Getting Your DBA Teams Scripts into Git
Saving Data Historically with Temporal Tables: Part 1: Queries
Build Chatbot with Large Language Model (LLM) and Azure SQL Database
Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)
[Video] Office Hours: I Don’t Have All the Answers
Getting started with delivering generative AI capabilities in SQL Server and Azure SQL
Join Me in Seattle for Watch Brent Tune a Query in SQL Server 2022
Control OneLake with Storage Explorer – Data Engineering with Fabric
How to perform unattended uninstall for SQL Server Express
The SQL Language is Just a Hurdle You Gotta Overcome.
Announcing the Availability of adutil for RHEL 9 and Ubuntu 22.04 !
Deleting Documents from a MongoDB Collection
How to Rename a Column in SQL Server
XML Performance Tuning and Added Options
How I Used PostgreSQL RLS To Avoid Code Changes During a Migration
[Video] Office Hours: Database Answers from a Hotel Room
Query Exercise Answer: Beating ChatGPT at Finding Good Question Times
SQL Server TRY CATCH, RAISERROR and THROW for Error Handling
Unzipping Word Documents in T-SQL
Join Me in San Diego for SQL Saturday!
Près de 20 % des Microsoft SQL Server en service ont dépassé la fin de la période de support et ne sont plus supportés par Microsoft et 12 % utilisent SQL Server 2014
Azure Arc enabled SQL Server – determine your Azure SQL target with ease and confidence
Working with SQL Server in Visual Studio Code
Migration sql server from sql 2017 to sql 2022 with Minimal Down time
Cumulative Update #27 for SQL Server 2019 RTM
Fine-grained Access Control for Stored Procedures
Power BI Treemap Chart Step-by-Step Tutorial
[Video] Creepy Office Hours in Vancouver
Query Exercise: Beat ChatGPT at Finding Good Question Times
Memory Grant Feedback Persistence in SQL Server 2022
PostgreSQL is Now Faster than Pinecone, 75% Cheaper, with New Open Source Extensions
There’s a 6-Month Statute of Limitations on “The Last Person.”
Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
SQL Server 2022 is EAL 2 Common Criteria certified!
Concepts and Issues in Test Data Generation
How to Sort String Date Values on a Power BI Slicer Visual
How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB
Nettoyage des instances et bases de données SQL Server
Migration de base de données SQL vers le cloud – Retour d’expérience
Les Dernières Nouveautés Azure SQL Database et On-Prem
Identify Tables With Dropped Columns
Suivi en temps réel de ma production solaire et de ma consommation électrique avec Microsoft Fabric
[Video] Office Hours in a Hotel Room
Datafrogs juin 2024 : ménage de printemps
Auditing SQL Server – Part 1 – Discovery and Documentation
Database mail and connection pool depletion
The signs of a new era: Prompt Injection
Two Tweaks for Faster Backups with Ola Hallengren’s Scripts
Basic Always On Availability Groups in SQL Server Standard
Who’s Hiring in the Microsoft Data Platform Community? June 2024 Edition
Effective Strategies for Storing and Parsing XML in SQL Server
SQL Server on Azure VMs: I/O analysis (preview)
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
PostgreSQL UNION, INTERCEPT & EXCEPT Operator
SQL Bulk Insert Command Examples
Coming in Entity Framework 9: Better Query Parameterization
This Is It! The Last 3 Days of My Anniversary Sale.
Enhancing Web Application Performance through Database Optimization: A Comprehensive Study
Updated First Responder Kit and Consultant Toolkit for May 2024
Snake draft sorting in SQL Server, part 4
SQL Server Temporary Stored Procedures
What is new in Copilot, the new features available
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Takeaways from Data Grillen 2024
Okay, About That SmartPostgres.com Thing.
ライセンス関連のお問い合わせ窓口について (Azure 仮想マシン : SQL Server)
[Video] Office Hours: I Feel Like an Amateur Edition
Troubleshoot SQL Server Always On Availability Groups with SQL LogScout
Empowering Lakehouse Users – Data Engineering with Fabric
Détecter les blocages dans MS SQL Server
Exploring MVCC and InnoDB’s Multi-Versioning Technique
How Big Data Supports Gen AI
Unlock power of data in Azure- With SQL Server on Linux Azure VMs and Azure AI search
SQL Replication Error – the row was not found at the Subscriber when applying the replicated UPDATE command
Managing SQL Agent in Azure Data Studio
Cumulative Update #13 for SQL Server 2022 RTM
[Video] Office Hours: Answers for Your Database Questions
Windows 11/Windows Server 2022 への SQL Server のインストールが失敗する場合の対処策について
Snake draft sorting in SQL Server, part 3
Getting Data Out of an Audit Table: Answers & Discussion
SQL Server Always On Availability group on AKS with DH2i’s DxOperator and Rancher by SUSE
Combining Silver Tables into a Model – Data Engineering with Fabric
Why Generative AI Scares the Hell Out of DBAs
T-SQL Tuesday #174: Your Favorite Job Interview Question?
PowerBI premium capacity administration: dataset monitoring and tuning
Read Data Stored in a Lake Database using Azure Synapse Analytics
Using Machine Learning Pipeline Execution Activity in Azure Data Factory
Identifying Customer Buying Pattern in Power BI – Part 2
SQL Server Networking troubleshooting documentation expanded
I’m Getting Antsy for SQL Server vNext.
Who’s Changing the Table? Answers and Discussion
SQL Server Filtered Index Essentials Guide
SQL ConstantCare® Population Report: Spring 2024
How to Build Metadata Driven Pipelines in Microsoft Fabric
[Video] Office Hours: Ask Me Anything About Azure and Microsoft Databases
Ingest and Retrieve data from an ADX Cluster Using Python
The Curious Case of… missing log information
All about SQL drivers and access tokens
Who’s Hiring in the Microsoft Data Platform Community? May 2024 Edition
Database Dashboards in Azure Data Studio
Managing Failed Pipeline Runs in Azure Data Factory
Query Exercise: Who’s Changing the Table?
It’s Time For Our Annual Anniversary Sale!
Metadata Driven Pipelines – Data Engineering with Fabric
PySpark Secrets to use with Fabric
Join Me at the PASS Data Community Summit in November!
Learning Spark SQL String Functions with Explanations and Code Examples
Exporting and Importing Registered Servers in SSMS
Database technology learning resources
Building RESTful APIs in Rust With Actix and Diesel
What happens when we drop a column on a SQL Server table? Where's my space?
Why migrate Windows Server and SQL Server to Azure: ROI, innovation, and free offers
[Video] Database Answers in Hong Kong
Working with IAsyncEnumerable in C#
Troubleshooting Mysterious Blocking Caused By sp_getapplock
It’s almost time for Fundamentals Week! Have you signed up yet?
Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3
Unlocking Power with Updatable Views in SQL Server
Kubernetes For Complete Beginners
Building a Culture of Data: The Technical Aspects
Identifying Customer Buying Pattern in Power BI – Part 1
[Video] Office Hours: Hong Kong Harbor
Database Subsetting and Data Extraction
Exploration Experience: Saving and Creating Datasets
How to Have a Conversation About Software Licensing
Full vs. Incremental Loads – Data Engineering with Fabric
Announcing Offline Access to Your BrentOzar.com Courses
Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager
Snake draft sorting in SQL Server, part 2
Finding Sister Locations to Help Each Other: Answers & Discussion
Disaster Recovery and High Availability Solutions in SQL Server
Snake draft sorting in SQL Server, part 1
Fabric and Azure SQL in a few clicks: Mirroring a Database
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Cumulative Update #26 for SQL Server 2019 RTM
[Video] Office Hours: Career & Data Q&A
How to Use Any SQL Database With Rust
Your Teammates Need the Fundamentals.
SQL Server Plan Cache Bloat Performance Impacts
Security Update for SQL Server 2022 RTM CU12
Security Update for SQL Server 2019 RTM CU25
Security Update for SQL Server 2019 RTM
Update: Security hotfixes released for ODBC and OLE DB drivers for SQL Server
Using ChatGPT for T-SQL Code Reviews
Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2
Giving Feedback on Microsoft Data Platform Tools
Joining Queries in Azure Data Factory on Cosmos DB Sources
SQL Server Patching Using PowerShell DSC
Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code
[Video] Office Hours: Just Three Questions
Released: SCOM Management Pack for Azure SQL Managed Instance (7.4.0.0)
Dynamic Partitioning and a Simple Incremental Load
Who’s Hiring in the Microsoft Data Platform Community? April 2024 Edition
Use Fabric Data Factory to Load Data From a CSV File in Azure Blob Storage to Azure SQL DB
Building MongoDB Aggregations in MongoDB Compass
Announcing Fundamentals Week, May 6-10
Provision Premium SSD v2 Storage for Microsoft SQL Server on Azure Virtual Machines in the Microsoft Azure portal
Tomorrow’s the Big Day: Free Live Webcasts!
Custom Statistics Distributions in SQL Server 2022
Choosing Between SSIS vs ADF: What You Need to Know
Check Azure SQL DB Space Used
[Video] Office Hours: 25 Answers in 10 Minutes
[Video] Office Hours: The Long One
Managing Files and Folders with Python – Data Engineering with Fabric
What is Eventstream in Microsoft Fabric? – Part 1
Join Me for Free Live SQL Server Training Next Week.
Announcing the discontinuation of using DBCC CLONEDATABASE command in production deployments
Pagination and ordering by large values
Tinkering with Fabric Data Factory Framework Functionality
Quick and Effective Migration Between CosmosDB Collections Using ADF
How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer
Expand the limits of innovation with Azure data
[Video] Office Hours in Snowy Telluride, Colorado
Enabling Azure Key Vault for SQL Server on Linux
Managed Vs Unmanaged Tables – Data Engineering with Fabric
Upcoming changes for SQL Server Management Studio (SSMS) – Part 3
SSMSInfoReports : nouvelle release v9.2
Free Live Webcasts: Slide & Demo Versions of How to Think Like the Engine
Networking errors when enabling SQL Server by Azure Arc
Department of Redundancy Department
Correct SQL Server Transactional Replication Issues with T-SQL and SSMS
Find Unused or Backup Tables
The difference between BIN2 and Case-Sensitive collations in SQL
Cumulative Update #12 for SQL Server 2022 RTM
The Benefits of Volunteering at SQL Saturdays
Visual Studio 17.10 Preview 2 améliore le travail avec GitHub Copilot
SQL Server to PostgreSQL Database Schema Conversion
Option Recompile is a Magic Turbo Button That Actually Works.
Transforming and Analyzing Data in PostgreSQL
Get the most out of SQL Server Agent logs
Will AI end with SQL, Is this the end of SQL?
Why Test-Driven Development? (Part 2)
SSRS 2022 Install, Setup and Configuration
Power BI Auto Detect Relationship Failure
What Happens When Multiple Queries Compile at Once?
Reverse Creating the PBIP file from Source Control
Finding Sister Locations to Help Each Other: Answers & Discussion
Writing your 2024 PASS Data Community Summit Submission
[Video] Office Hours From the Future
Serverless Authentication methods in web apps.
Read This Before Your Users Install SSMS 20
Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities
Evolving Role of Data Professionals in Artificial Intelligence Era
Updated First Responder Kit and Consultant Toolkit for February 2024
Live webinar: How to excel at managing multiple database platforms
A Few Best Practices for Strong SQL Server Security
Upcoming changes for SQL Server Management Studio (SSMS) – Part 2
Query Exercise: Finding Sister Locations to Help Each Other
Find and Replace Text in Strings in T-SQL
Azure Data Studio 1.48 is now available
SQL Server Integration Services (SSIS) Change Data Capture Attunity feature deprecations
Find Recent Superstars: Answers & Discussion
SQL Server Clustered Index Seek Operation Generates Poor Query Performance
“As DBAs, should we be worried about our jobs because of AI?” and other burning questions
Join Me in Orange County for Tuning Databases in One Day
SQL Server enabled by Azure Arc, now assists in selecting the best Azure SQL target
Sessions You Should Attend at SQLBits Online 2024
Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster – Part 3
Upgrade SQL Server on your workstation
[Video] Office Hours: Hot Tub Edition
What Every DBA Should Know about Always On Readable Secondaries
Redgate Summit: The Database Landscape
Query Exercise: Find Recent Superstars
Finding Long Values Faster: Answers & Discussion
Dynamically Create Tables in Power BI with DAX Functions
Forget the Models, Your Data is the Secret Sauce for Generative AI
#TSQL2sday Roundup: The Most Recent Issues You Closed.
Tutorial: Using the hierarchyid Data Type
Released: SQL Server 3rd Party Backend for Django v1.4
Microsoft Drivers 5.12 for PHP for SQL Server Released
JDBC Driver 12.6 for SQL Server Released
Upcoming changes for SQL Server Management Studio (SSMS) – Part 1
[Video] Office Hours: Ask Me Anything About Microsoft Databases
SQL Server サービスが OS の起動時に自動起動してこなかった場合の対処策について
JQ – Tool for Querying JSON documents using the CLI
Functions and Procedures: Learning PostgreSQL with Grant
Cumulative Update #25 for SQL Server 2019 RTM
How SQL developers can maximize savings
Query Exercise: Finding Long Values Faster
Improving Cardinality Estimation: Answers & Discussion
Attention SQLBits 2024 Attendees!
Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more
The Last Ticket/Issue I Closed #TSQL2sday
SQL ConstantCare® Population Report: Winter 2023
Tracer l'activité des développeurs sur la production
Leave it better than you found it
Writing SQL Server code with AI using GitHub Copilot
Planning a Database Testing Strategy for Flyway
Automating BCP with PowerShell
[Video] Office Hours: Lumberjack Edition
Use a Table Variable for Logging Entries that Need to Survive Rollbacks.
LangChain Prompt Templates with OpenAI LLMs
Query Exercise: Improving Cardinality Estimation
Database Changes to Find Tagged Questions Faster: Answers and Discussion
Dimensional Modeling Case Study Part 2 – Days Dimension
#TSQL2sday Invitation: Describe the Most Recent Issue You Closed.
L'étude 2024 de Red Gate sur l'état de l'art en matière de SGBD montre l'avance de Microsoft SQL Server, pour un usage professionnel d'entreprise quel est votre classement ?
Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error
Announcing the first Microsoft Fabric Community Conference!
Fixing the Synapse Error « Available workspace capacity exceeded error (Livy session) »
Deploying Azure SQL Database Using an ARM Template
Adding an AI Policy for Authors
Microsoft Fabric, la solution décisionnelle pour toutes les entreprises – aMS Strasbourg 2024
Office Hours: PowerBI & Fabric Q&A with Eugene Meidinger
Who’s Hiring in the Microsoft Data Platform Community? February 2024 Edition
Feature Flags in Data Projects
Released: Microsoft.Data.SqlClient 5.1.5
Released: Microsoft.Data.SqlClient 5.2 Preview 5
Finding Tagged Questions Faster: Answers & Discussion
Install SSMS using Powershell DSC
Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures
Free Video Training: Estimation and Statistics by Dave Ballantyne
Lancement de la chaine YouTube Data Chouette
Server Dashboards in Azure Data Studio
Adding a new AI usage policy to Simple-Talk
What PowerBI Questions Do You Have for Eugene Meidinger?
Released: SCOM Management Packs for SQL Server, RS, AS (7.4.0.0)
State of the Database Landscape 2024: Shifting skills to match constant demands
Django's ORM vs. Raw SQL: When to Use Which
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Query Exercise: Find Tagged Questions Faster.
Finding the Best Time for Maintenance: Answers & Discussion
Code Visibility: Browsing through Flyway Migration Files
Save 5% on SQLBits Registration with BRENT5.
State of the Database Landscape Results 2024
Understanding the Importance of Data Lineage in Modern Data Management
Configuration of Azure SQL Database Auditing
[Video] Office Hours: The Question is Not the Problem Edition
Buy on-demand access for Summit 2023 today
Leveraging AI Tools for SQL Queries
Query Exercise: Find the Best Time for Maintenance
Find Posts with the Wrong CommentCount: Answers & Discussion
We’re Starting to Automate Testing for the First Responder Kit.
Working on Technology Off the Clock
The Publisher failed to allocate a new set of identity ranges for the subscription
A Simple Method to Load Excel Data
[Video] Office Hours: Ask Me Anything About the Microsoft Data Platform
Cumulative Update #11 for SQL Server 2022 RTM
Dimensional Modelling Case Study Part 1 – Age Group
Query Exercise: Find Posts with the Wrong CommentCount
The Mastering Azure Data Studio Series
Security Update for SQL Server 2022 RTM CU10
Security Update for SQL Server 2022 RTM
Semantic Model: More than a Simple Name Change
Find Foreign Key Problems: Answers & Discussion
Adding Cookie Consent to SQL Server Central
Connecting SQL Server to SaaS applications with a Linked Server
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
Released: Security updates for Microsoft.Data.SqlClient and System.Data.SqlClient
Announcing the 2024 Data Professional Salary Survey Results.
Optimized locking in Azure SQL Database
Machine learning K-Means applied to SQL Server data
PowerShell Dynamic Parameters and SQL Server
New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables
Query Exercise: Find Foreign Key Problems
Being A Bit Less Comfortable in 2024
[Video] Office Hours: Oddball Questions Edition
SQL Window Functions Series: NTILE()
Kickstart the year with our free Livestream! Navigating the database landscape in 2024
Two-Dimensional Interval Packing Challenge
Who’s Hiring in the Microsoft Data Platform Community? January 2024 Edition
Comparing Azure Analysis Services with On-Premises SQL Server Analysis Services
Backup SQL Server on Linux Databases using SQL Server Agent on Windows
Warehouse Load Patterns – Part 2 – Load Patterns
[Video] Office Hours: Holiday Speed Round Edition
The Profiler Extension in Azure Data Studio (ADS)
Updated First Responder Kit and Consultant Toolkit for December 2023
Comment utiliser les rapports SSMSInfoReports
Eager Aggregation in SQL queries
[Video] Working on First Responder Kit Pull Requests
Understanding Maximum Server Memory in SQL SERVER
Most Overlooked Features in Power BI
Introducing the MongoDB Document
The Annual Data Professional Salary Survey Closes This Week!
Building Reports with Power BI vs Tableau from SQL Server Data
Docker Security Principles Overview
Creating a Hyperscale Database in Azure Using the Azure Portal
[Video] Office Hours: 21 Good Questions
[Video] Office Hours: Wrong Side of the Bed Edition
Sending resource alerts on Managed Instance using db_mail
Why Don't You Upgrade in Place?
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
Le DataOps pour Power BI et Microsoft Fabric
Configuring an SSIS ForEach Loop for Multiple File Types
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
Cumulative Update #24 for SQL Server 2019 RTM
Searching an Encrypted Column
Running Azure CosmosDB queries from SQL Server using ODBC driver
MySQL Error Log Management in DevOps Operations
[Video] Office Hours: Sunshine Edition
Fabric Notebooks and Deployment Pipelines
[Video] Office Hours: Really Good Questions Edition
Arc enabled Azure migration & modernization journey
SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server
What Would You Ask Your Predecessor? Get Answers with ChatGPT.
Exploring PostgreSQL Indexes
What is subsetting, what are the advantages, and how does it make test data management easier?
Identify log write limits on Azure SQL Managed Instance using QPI library
SQL Window Functions Series: LAG() and LEAD()
Window Function Basics – PARTITION BY
How using a database monitoring tool helps DBAs create value for the whole organization
Learn Spark SQL Date and Time Functions
SQL Server: Optimize for Ad Hoc Workloads – use or not use
How Has Inflation Affected Your Salary? Let’s Find Out Together.
Microsoft dévoile les mises à jour apportées à SQL Server Data Tools 17.8 dans Visual Studio 2022, dont des améliorations en matière de connectivité, d'accessibilité et d'optimisation de performances
Plansplaining, part 20. SQL Graph (part 1)
Always on Availability Groups for SQL Server containers on Kubernetes – The DH2i's DxOperator way!!
Who’s Hiring in the Microsoft Data Platform Community? December 2023 Edition
GitHub Copilot – Our Best Ally to for T-SQL
Championing DevOps: A Panel Webinar
PowerShell Commands to Administer Virtual Machines on Amazon AWS – Part 2
ChatDBA: ChatGPT 4 Answers 5 Office Hours Questions
Getting Started with DDL statements of Cassandra Query Language
SQL Server Cumulative Updates (CU) through the end of calendar year 2023 (re-post)
SQL Server Cumulative Updates (CU) through the end of calendar year 2023
Microsoft Fabric: Extended Source Control Features
[Video] Office Hours: Live on Black Friday Edition
TABLOCK Hint can Negatively Impact SQL Server Concurrency
Using the Import Extension in Azure Data Studio
Working with Azure DocumentDB: SQL & NoSQL Together
[Video] Office Hours: Black Friday Promo Edition
BrentOzar.com Cyber Monday Week Sale
When an update doesn’t update
Time Series Data Mining Example with T-SQL when Adding New Data
Ensuring a Single Row Table
Warehouse Load Patterns – Part 1 – Requirements and General Patterns
Updates about Database Projects for Microsoft Fabric
It’s Black Friday! Time to save big on SQL Server training.
Black Friday returns to SQLServerFast
Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY
[Video] Office Hours: Brent’s Cursed Technology Edition
SQL Server 2022 for RHEL 9 and Ubuntu 22.04 is now Generally Available (GA)
Source Control with GIT, Power BI and Microsoft Fabric
What is Microsoft Fabric all about?
[Video] Office Hours in Camden Harbor
Advanced SQL Server installation using Powershell DSC
Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud
Back home from the PASS Data Community Summit
Why Haven’t You Disabled SA? Wrong Answers Only.
SSMS and Visual Studio Issue Displaying EUDC (End-User-Defined Characters)
Strategies for queries against bit columns
Embracing SQL Server 2022 with SSDT 17.8: Unveiling Key Updates
Azure Monitor SCOM MI: New SQL Server monitoring solution in Azure
“How do my peers do this?” The latest best practices for IT architects implementing a major business initiative
What are Warehouses in Microsoft Fabric?
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT – Prepare to Ride the Next Wave
Cumulative Update #10 for SQL Server 2022 RTM
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points.
How to get your security team on board with your cloud migration
Scheduling SQL Agent Jobs on Alternating Weeks
PASS Summit 2023 – Redgate Keynote – The New Database Landscape – Revealing Shifts and Charting the Next Horizon
[Video] Office Hours at Megunticook Falls in Camden, Maine
PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless opportunities: Data and innovation in an AI world
Power what’s next with limitless relational databases from Azure
The Bridge – How Azure Arc brings cloud innovation to SQL Server anywhere
Office Hours, Silent Film Edition
SQL Server Table Design Guidelines – Data Types, Designing for Deletes and Primary Keys
How to join the free PASS Data Community Summit Livestream from around the world
SQL Window Functions Series: RANK() and DENSE_RANK()
The Curious Case of… missing 832 errors during memory corruption
The Black Friday Sale is Here: Save Big on Training & Apps
The Real Problem with SQL Server’s Licensing Costs
Getting Started with MongoDB
It’s Probably Time to Upgrade Your Cloud VMs
Azure Data Studio – A First Look
Security in the cloud: Whose responsibility is it?
An editor’s biggest headache: Plagiarism
Office Hours: “Read This” Edition
Microsoft at PASS Data Community Summit 2023!
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points
The PASS Data Community Summit First Timer Guide
Time-Series Data Analysis with Apache Druid
[Video] Office Hours: Having a Bad Day Edition
Fabric Data Warehouse News you need to know
Azure Data Studio 1.47 is now available
[Video] Office Hours: Yes, I’m In the Same Shirt
Timescale Launches Dynamic PostgreSQL, the Cost-Effective Alternative to Serverless and Peak-Allocation Pay Models
Free Webcast: How to Think Like the Engine, Live
Who’s Hiring in the Microsoft Data Platform Community? November 2023 Edition
Storm Ciaran Analysis with Microsoft Fabric
Analyse de la tempête Ciaran avec Microsoft Fabric
Moving SQL Server To The Cloud: Modernizing Stack Overflow for Teams
SQL Server and Python Tutorial
Five database DevOps practices for boosting team productivity
Creating an Azure PostgreSQL cluster and connecting to it
Deploying availability groups for SQL Server with HPE Serviceguard for Linux – The Ansible Way!!
Getting connected to PostgreSQL for the first time
Efficient Table Migration to a New Schema in T-SQL
SQL Server Fragmentation Impact with Modern Hardware
Microsoft at the PASS Data Community Summit 2023
Entra Authentication for Replication in Arc-enabled SQL Server 2022 CU 6 in Public Preview
Why Database Discussions Have Moved From the Backroom to the Boardroom
SQL Server Central Is Upgrading Our Servers
Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics
SSMSInfoReports : nouvelle release v9
SQL Endpoints and Lakehouse UI Differences and Access Secrets
[Video] Halloween Office Hours in Salem, MA
Utiliser les indicateurs de requête, la présentation
Mastering a cloud migration: 10 video tips
Improve Query Performance when SQL Server Ignores Nonclustered Index
Batch Execution Mode on a Rowstore in SQL Server 2022
Trigger the Execution of an ADF Pipeline from an Email
Power Query Editor in Power BI for Formatting Text Columns
Pike’s Market to Pikes Peak: The PASS Summit is Worth the Journey
Packed/Batched Transact-SQL (TSQL) RPC Invocation
Announcing Buy-Now-Pay-Later, Just in Time for the Black Friday Sale!
Database Projects for Microsoft Fabric Data Warehouse
Announcing My 2023 Black Friday Sale!
How We Ate Our Own Dog Food To Level-Up Internal Testing with Redgate Clone
Top 10 Methods to Improve ETL Performance Using SSIS
Announcing Live Online Mastering Classes!
Exporting and Importing Data into SQL Server Using Files
Transform your Winning team into a Champion Team
The promise – and the perils – of GitHub Copilot
Understanding Locking, Data Modification and Committing Data in SQL Server
Updated First Responder Kit and Consultant Toolkit for October 2023
What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples
Azure Databricks Tables – Delta Lake, Hive Metastore, TempViews, Managed, External
[Video] Office Hours: Back in the Vegas Home Studio
SQL ConstantCare® Population Report: Fall 2023
What I Wish Everyone Knew About ETL Processes – Traditional to Modern Cloud Solutions
Designing Databases for Distributed Systems
Who’s Hiring in the Microsoft Data Platform Community? October 2023 Edition
Utiliser les indicateurs de requêtes pour aider l’optimiseur
Faire cohabiter le décisionnel et le Transactionnel dans SQL Server
Migrer un groupe de disponibilité AlwaysOn sans perte du cluster
Fundamentals Week is Coming. Every Day, the Price Goes Up.
Don’t use DISTINCT as a “join-fixer”
Explore Natively Compiled SQL Server Stored Procedure Execution Plans
GIT Configuration and Automated Release for Azure Data Factory
What Is Good Database Design?
SQL Server 2022 Common Criteria EAL4 Certification
Cumulative Update #23 for SQL Server 2019 RTM
Cumulative Update #9 for SQL Server 2022 RTM
Conférence Datafrogs 14 octobre 2023
The SQL Developer Experience: Beyond RDBMS
Integrating Python with MongoDB
New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries
A Beginners Guide To MySQL Replication Part 6: Security Considerations in MySQL Replication
[Video] Office Hours with a Surprise Special Guest
Visual Studio 2022 17.8 Preview 3
Security Update for SQL Server 2022 RTM CU8
Security Update for SQL Server 2019 RTM CU22
Security Update for SQL Server 2019 RTM GDR
Security Update for SQL Server 2017 RTM GDR
[Video] Office Hours at the Northernmost Town in the World
Parsing a Pairs of Values in a String While Preserving Order
Well, I’m Not Doing SQLBits After All.
PostgreSQL Indexes: What They Are and How They Help
Alternatives To SQL Server 2022 Built-in function GREATEST
SQL Athena Introduction – How it works, Use Cases and Advantages
The Basics of Using GENERATE_SERIES()
Using SQLite with Flutter
Power BI Workspace Permissions and Roles
Different Ways to Populate the List of Tables
First Normal Form Gets No Respect
[Video] Office Hours at the Arctic Circle
Fabric: My Content compilation
[Video] Office Hours Off the Coast of Norway
SQL Server 2022 on SUSE Enterprise Linux v15 SP5 – Azure Marketplace image is now available!
Something’s Up with Parallelism in Azure SQL DB Serverless
SQL Server Row Level Security Deep Dive. Part 6 – RLS Attack Mitigations
Normalize strings to optimize space and searches
Which of These Azure Courses Would You Attend?
Getting Started with Power Query M Language in Excel
Sentiment Analysis with IA
PostgreSQL 101: A guide to PostgreSQL documentation & useful resources
Enterprise vs EnterpriseCore Edition for SQL Server on Linux production Workloads
Profiler and Server Side Traces
Sending Multiple Attachments in Email from Azure Data Factory Pipeline
T-SQL Fundamentals: Controlling Duplicates
Protect SQL Server 2014 workloads with Azure flexibility
[Video] Office Hours at the Munch Museum in Oslo
Microsoft Fabric and the Delta Tables Secrets
[Video] Office Hours at Dyrhólaey Overlooking Puffins & Black Sand Beach
Introduction to Using Bitbucket and CI/CD for Your App
The pros and cons of multicloud networking
It’s Probably Time to Upgrade Your Cloud VMs.
Best practices N° 4 – configuration de l'instance SQL
SQL Server Row Level Security Deep Dive. Part 5 – RLS Attacks
Restore With Standby; A Review and A Lesson Learned
AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks
Best practices N° 3 : configurer les historiques
Best practices N° 2 : configurer database mail, les notifications et les alertes
Analyze and Tune SQL Server Statistics
Best practices N° 1 : tâches de maintenance
How Would You Design This: Scheduling Classes
New Amazon X2iedn High-Memory Instances
Azure Data Studio 1.46 and New Features
Microsoft Fabric: Checking and Fixing Tables V-Order Optimization
[Video] Office Hours at Svínafellsjökull Glacier in Iceland
How Effective Is Your Data Load Monitoring in SQL and Python?
GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference?
12 Office Hours Questions I Don’t Have Answers For
Interactive Data Analytics With PowerShell, SQL, and ChatGPT (Sample Script)
Alternatives To SQL-2022 Built-in function GREATEST
Azure SQL Edge Update – September 2023
PostgreSQL 101: A guide to PostgreSQL documentation & useful resources
GENERATE_SERIES() Breaks Minimal Logging
SQL Server Execution Plan Issues when using TOP Clause and Various Parameters
Meetup du Club Power BI, pilote de la saison 8, les nouveautés Power BI, septembre 2023
SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives
How To Filter SQL Server Data in Windows PowerShell
Cumulative Update #8 for SQL Server 2022 RTM
Backup and Restore SQL Database to Azure Blob Storage
Generate Test Data Sets for Testing SQL Server Database Applications
Announcing SQLBits 2024: 19-23 March, Near London
Microsoft Fabric: Using notebooks and table partitioning to convert files to tables
[Video] Office Hours at Breiðamerkursandur, Diamond Beach
“Oops, I Lost My Indexes in Azure SQL DB.”
How To Visualize SQL Server Data in PowerShell (With Sample Script)
What’s Faster: IN or OR? Columnstore Edition
Webinar: The Impact of the Cloud on Databases
How to create a SQL Server presentation in 5 minutes using AI
Working with NULL Values in SQL
SQL Server Row Level Security Deep Dive. Part 3 – Performance and Troubleshooting
How to Use SQL to Analyze the Bitcoin Blockchain
Decision Tree – Credit Card Fraud Detection
SQL Unit Testing reference guide for beginners
Working with MySQL constraints
[Video] Office Hours at Jökulsárlón Glacial Lagoon
How To Connect to SQL Server Database From PowerShell
Microsoft Fabric: Lakehouse and Data Factory in Power BI environment
[Video] Office Hours at the Blue Lagoon
En désactivant TLS 1.0 et 1.1 de Windows, Microsoft perturbe SQL Server
Quickstart: Connect SQL Server machines to Azure Arc
Hotfix: JDBC Driver 12.4.1 for SQL Server Released
Who’s Hiring in the Microsoft Data Platform Community? September 2023 Edition
Orchestrating a MySQL Container on Kubernetes
Why Australian Azure SQL DBs Went Down for 8+ Hours
MarketPlaceからSQL仮想マシンを作成する場合とAzureVMに手動でSQLをインストールする場合の違いについて
Optimized Plan Forcing with Query Store in SQL Server 2022
How To Use Flyway for Database Migration in Spring Boot
SQL Server Row Level Security Deep Dive. Part 2 – Setup and Examples
Setting up Drill Through in the New Power BI Report User Interface
Export and Import SSISDB in just a few clicks
[Video] Office Hours: Overly Caffeinated Edition
[Video] Office Hours: All About Miles Edition
Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook
Announcing General Availability of Azure Portal Experience to Deploy Multi-Subnet Availability Group
Free Webcast: Avoiding Deadlocks by Tuning Queries
Released : Public Preview of Azure Update Manager Integration with SQL Server on Linux Azure VM's
Announcing public preview of enhanced patching for SQL Server on Azure VM with Azure Update Manager
Microsoft Fabric: Loading On-Premises and External Data
How to export data to SQL Server using Bard (Google chatbot)
10 reasons to choose Flyway
A Beginners Guide to MySQL Replication Part 5: Group Replication
Different Ways to Format Currency Output in SQL
Yet Another Reason to Not Use sp_ in your SQL Server Object Names
Screen Scraping with Python and BeautifulSoup Code Examples
[Video] Office Hours: I Need Your Help with These
Spot the Five Differences and Win a Summit Ticket
[Video] Office Hours: Really Long (and Really Short) Answers
Sessions for Summit 2023 are now LIVE!
How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks
Delegating permission management using Roles vs WITH GRANT OPTION
Updated First Responder Kit and Consultant Toolkit for August 2023
Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration
Learning PostgreSQL With Grant: Introducing VACUUM
Database Monitoring for Developers
Working with SQL Server Stored Procedures and .NET
Provisioning Microsoft Fabric: A Step-by-Step Guide for Your Organization
Import Text and CSV Files into SQL Server Database with SSIS Script Task
A LEFT OUTER JOIN in SQL: What Is It?
[Video] Office Hours in Telluride, Colorado
Migration from Sybase ASE using SSMA CLI
How much has data technology changed over the years?
Office Hours: Before Heading Out on Vacation
PASS Data Community Summit 2023 – Sessions are available to view!
Meetup du Club Power BI de Strasbourg, mai 2023
Meetup du Club Power BI de Strasbourg, mars 2023
The PASS Summit Lineup Is Out and Registration is Open!
Cumulative Update #22 for SQL Server 2019 RTM
Discover the Microsoft Fabric Data Wrangler
Working around schema drift in SQL Server
Bing vs Bard (Chatbot wars)
Managing the challenge of migrating to the cloud
Dive into RDS Custom for SQL Server – Leverage your existing licenses and high availability
Database Concurrency in PostgreSQL
SQL Server 2022 now available for both RHEL 9 and Ubuntu 22.04 in Preview mode
Cumulative Update #7 for SQL Server 2022 RTM
How Would You Design This: Tracking Travels
Data Transfer from Azure Blob Storage to Snowflake Using Pipelines
PostgreSQL 101: The ten PostgreSQL extensions you need to know about
Going to a conference where hardly anybody knows my name
[Video] Office Hours: Stump Me On SQL Server
[Video] Office Hours: Extended Answers Edition
Meet the Summit 2023 Sponsors
Standard Sponsor Rates End August 30!
A Beginners Guide to MySQL Replication Part 4: Using GTID-based Replication
T-SQL Tuesday #165 – My Experience with Database Job Titles
I/O optimizations for tempdb in SQL Server and Azure SQL
Analyzing Prices of SQL Server Books, New & Used
The Curious Case of… recovering from a ransomware attack
Azure Data Studio 1.45 Release and Hotfix
What Is an Execution Plan and How to Find It in PostgreSQL
Combine DATE and TIME to DATETIME2 in SQL Server
Using Power Query to Combine Data from Multiple Sheets in Excel
7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide
Building REST APIs in Go with Mux and GORM
How to List First or Last n% Records Using NTILE() in SQL Server
AutomatedLab – A Quickstart for Deploying SQL Server Labs on Windows
ODBC Driver 18.3 for SQL Server Released
JDBC Driver 12.4 for SQL Server Released
[Video] Office Hours While the Pool Refills
[Video] Office Hours: Stump Me With Your Data Questions
Create Your First Pipeline in Microsoft Fabric
Who’s Hiring in the Microsoft Data Platform Community? August 2023 Edition
Running Queries Across Many SQL Server Databases
Installing SQL Server Integration Services
How to Change the SQL Server Database Owner
Unmasking SQL Server Dynamic Data Masking, Part 5, Mitigations and Summary
The Hidden Impact of Microsoft Defender for Azure SQL
Best Practices for Google Cloud Security
Exporting data from a MySQL database using SELECT…INTO OUTFILE
[Video] Office Hours: Overheating Cadillac Edition
[Video] Office Hours: Azure SQL DB & SQL Server Questions
PASS Data Community Summit 2023
What is OneLake in Microsoft Fabric?
Querying PostgreSQL: Learning PostgreSQL with Grant
Finishing Up Your Free Azure Networking Training
A Overview of Amazon Redshift
DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections
Released: Microsoft.Data.SqlClient 5.2 Preview 3
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
SQL Server vs Oracle Query Statistics to Improve Performance
PASS Data Community Summit – Early Bird price ends July 26
Optimizing Queries in MySQL: Optimizing Updates
[Video] Office Hours: SO MANY Good Questions
[Video] Office Hours: While Stack Overflow is Down
SQL ConstantCare® Population Report: Summer 2023
A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication
Free Azure Networking Training This Week
Managing Test Data for Database Development
Power BI Data Gateway to Connect Data Sources in the Cloud and On-Premises
Building a Database Dashboard with SSRS
Using Power BI to Analyze My Travels
Sample Use Case for Using SQLCMD Utility Batch Files
PostgreSQL 101: The journey towards PostgreSQL – tips and lessons from Grant Fritchey
Cumulative Update #6 for SQL Server 2022 RTM
It’s Only Summer, but I am ready for PASS Data Community Summit Now!
[Video] Office Hours: 30 Minutes of Rapid-Fire (And a Little Burnination)
Free Azure Networking Training This Month!
What Counts for a DBA – Discretion
PASS Data Community Summit
Let Your Data Do the Talking with PowerPoint Plus Power BI
FOR XML PATH Changed The Way I Think About T-SQL #TSQL2sday
Released: SCOM Management Packs for SQL Server, RS, AS (7.2.0.0)
Influencing Successful Cloud Transformational Change
Enterprises that adopt Database DevOps save an average of $4.3M per year (Video)
Get the Most Current Row From a Detail Table
N'oubliez pas les correctifs
Creating an Azure SQL Database Using Azure Cloud Shell
Starter Metadata T-SQL Query Examples for Databases and Tables
Storing Credentials Securely on a Windows-based Flyway Installation
Meetup du Club Power BI, Hors-Série spécial Microsoft Fabric
When Parameter Tuning is not the Answer
[Video] Office Hours: DBA & Developer Relationships
Use sqlcmd to create and query a SQL Server container for development
[Video] Office Hours: Lots of Good SQL Server Questions
The difference between libraries and frameworks
Supervise the use of Microsoft Fabric
Bard, Google’s ChatGPT Competitor
SQL Server Database Backup and Restore Failure Notifications
Six Things to Monitor with PostgreSQL
Meetup du Club Power BI, La Tournée de Paris
Searching Flyway Migration Files using Grep and Regex
[Video] How to Use ChatGPT to Write WordPress Blog Posts
[Video] Office Hours: As They Pour My Patio Concrete Edition
How to Reduce the Need for Bookmarks Using Parameters in Power BI
Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text
On the Road Again, Next Up Columbus
How to Make Database Changes Without Breaking Everything
Using a Subquery in a SELECT statement
[Video] Office Hours: Professional Development & Training Questions
SQL Server Resumable Index Operations
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance
Pipelining Configuration Information Securely to Flyway
It’s Friday. I’m Not Answering These 14 Office Hours Questions.
Call for Panelists – WIT Panel at PASS Data Community Summit, 2023
How to Find the SQL Server Version
Troubleshoot SQL Server Deadlocks in Stored Procedures
[Video] Office Hours: Github Copilot in Azure Data Studio
Updated First Responder Kit and Consultant Toolkit for June 2023
How to Avoid N+1 Queries: Comprehensive Guide and Python Code Examples
The Best Career Advice I Ever Got (#TSQL2sday)
Snowflake: A Cloud Warehouse Solution for Analytics
SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 3
ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object
Advantages of Kappa architecture in the Modern Data Stack
Understanding Power BI Security Options – Row-Level, Column-Level and Object-Level Security
SQL Server slow performance troubleshooting documentation expanded
How to Visualize Timeseries Data with the Plotly Python Library
Using Windows Security and Encryption with Flyway
Cumulative Update #5 for SQL Server 2022 RTM
Cumulative Update #21 for SQL Server 2019 RTM
Update: Hotfixes released for ODBC and OLE DB drivers for SQL Server
Why Are Y’all Changing the Compat Levels on Master?
Secure your AI using SQL Server Machine Learning with Microsoft Azure OpenAI Services
Unmasking SQL Server Dynamic Data Masking, Part 3, Security Concerns
[Video] Office Hours: Almost Back in San Francisco
Calculating Prime Numbers With One Query
Building a Kimball Data Warehouse
The SQL Server Advice You Don’t Wanna Hear
SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 2
Poll Results: Are You Going Back to In-Person Events?
Manipulating Data In PostgreSQL: Learning PostgreSQL with Grant
Flyway for SQL Server Data Tools Users
T-SQL Scripts to generate the HTML-formatted database storage report
Multiple Relationships on the same Table in a Power BI Data Model
Released: Microsoft.Data.SqlClient 5.2 Preview 2
A Guide to INSERT, UPDATE, and DELETE Statements in Oracle
Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders
Data Transfer from Snowflake to Azure Blob using Synapse Analytics
SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 1
Early technical preview of JDBC Driver 12.3.1 for SQL Server released
30%-off health checks and self-service via credit card – no waiting!
Released: SQL Server 3rd Party Backend for Django v1.3
[Video] Office Hours at Sea: Leaving Juneau
Unmasking SQL Server Dynamic Data Masking – Part 2 – Setting up Masking
[Video] Office Hours in Glacier Bay, Alaska
PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones)
PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones)
Analyze Data with a Serverless SQL pool in Azure Synapse Analytics
AWS Aurora Cut Our Database Costs for SQL ConstantCare® – Again.
Restarting MS SQL Server : bad or good idea ?
Poll: Are You Going Back to In-Person Events?
First speakers announced for Summit 2023
How to Filter a SQL Server Audit with a Predicate
SQL WHERE LIKE to Construct More Efficient Queries
Flyway and SSDT: Merging Work from a Branch
MuleSoft Integration with Azure Key Vault
SQL Server 2022: Capture SQL Anti-Patterns
Microsoft Fabrics Monitoring Tenant Settings
Announcing 30-Day Free Trials for SQL ConstantCare®. Check Your SQL Servers Now.
Parameter Sensitive Plan Optimization, Why?
[Video] Office Hours at Sea: SQL Server Q&A
Database Sequence Objects with dbatools
Last Call for My 21st Anniversary Sale
Install SQL Server using Powershell Desired State Configuration (DSC)
How Snowflake Creates and Detects Deadlocks
Flyway and SSDT: Extracting a DACPAC from a Flyway-managed Database
Unmasking SQL Server Dynamic Data Masking, Part 1, Intro
Breaking News: SQL Server 2022 Keeps Getting Worse.
Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances
Microsoft Build Announcements for Data Professionals
Getting Started with Ensemble AI Models in SQL Server
A First Look at PostgreSQL Monitoring in SQL Monitor
Private preview announcement of native JSON type & JSON aggregates in Azure SQL Database
Announcing Azure Data Studio 1.44
Who’s Hiring in the Microsoft Data Platform Community? May/June 2023 Edition
SQL Saturday Haïti 2023, Bien maîtriser Azure Data Studio et les Notebooks
Azure Data Factory pour les nuls – SQL Saturday Haïti 2023
SQL Saturday Haïti 2023, Azure Data Factory pour les nuls
Microsoft Fabric: Enabling your Free Trial
Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more
Data Intelligence on light speed: Microsoft Fabric
Using Azure Data Studio to Deploy a SQL Server VM on Azure
Self Review: Practical Graph Structures in SQL Server and Azure SQL
Microsoft Build 2023 Keynote Live Blog: Introducing Fabric
[Video] Office Hours: Azure & SQL Server Q&A
Optimizing MySQL: Adding Data to Tables
How to Generate Images with AI and Store them in SQL Server using Python and DALL·E
PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL
Cache SQL Server Data in a .NET Web Application
Common Table Expression Basics
The Journey to Team-based Development with Flyway
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
PostgreSQL Basics: A Template for Managing Database Privileges
[Video] Office Hours: Professional Development & Training Questions
[Video] Office Hours: 45 Minutes of SQL Server Q&A
Released: Latest Azure VM Marketplace images for SQL Server 2022, 2019 on Linux
SLES 15 SP4 is now supported for SQL Server 2022 starting Cumulative Update 4
SQL Server Agent fails to start on Windows Server 2022 due to Application event log policy setting
Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty
It’s Been 6 Months. SQL Server 2022 Still Isn’t Ready Yet.
Changing log growth strategy in SQL Server 2022
7 ways businesses can improve the quality and speed of database releases
How to Improve Database Design to Speed Up SQL Queries
Star Schema vs Snowflake Schema Considerations
Modélisation : viol de la première forme normale par « apocope »
Azure Storage Blob – Cold tier
Understanding how to Successfully Sell the Cloud
How to Find the SQL Server Instance Startup Time
Uncovering the mysteries of PostgreSQL (auto) vacuum
Database Branching and Merging without the Tears
Cumulative Update #4 for SQL Server 2022 RTM
go-sqlcmd v1.0 – Create, Connect to, and Query SQL Server
How to Configure Ola Hallengren’s Database Maintenance Scripts for Backups
[Video] Office Hours: Testing the First Responder Kit
How to Create a SQL Database on a New Drive in Ubuntu
Free Webcast Next Week! What’s New (and Actually Good) in SQL Server 2022
Power BI Embedded – Club Power BI – Mai 2023
SQL Server Management Studio のインストール手順
A Technical Journey into API Design-First: Best Practices and Lessons Learned
Add a Second NIC for an Availability Group to Separate Network Traffic
Redgate opens the doors to cross-database DevOps Test Data Management
Benefits and Limitations of SCHEMABINDING Views in SQL Server
Released: Multiple Microsoft.Data.SqlClient Updates
Early technical preview of JDBC Driver 12.3.0 for SQL Server released
Finding External References in Database Deployments
Cheat Sheet for SQL Server DBA Daily Operations
PostgreSQL Table Import/Export from and to CSV File
Importing data into a MySQL database using LOAD DATA
[Video] Office Hours: 25 Pretty Good Questions
SQL Server et la redondance de zone sur Azure
Classing Up SSMS is as Easy as 1, 2, 3.
Create an HTML Report on the Status of SQL Server Agent Jobs
Upgrade SQL Server container with Always On availability groups configured on Kubernetes!
Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?
PostgreSQL Basics: Essential psql Tips and Tricks
ChatGPT in Visual Studio tutorial
How to Slice Data by Week in a Calendar Table using DAX
Working with Flyway And Entity Framework Code First: An Overview
How to Automate Cross-Platform Database Development
Using the New Open Source SQLCMD to Create Containers
Updated First Responder Kit and Consultant Toolkit for April 2023
Capitalize on your investments with the new centrally managed Azure Hybrid Benefit for SQL Server
How to Go Live on SQL Server 2022
PASS Data Community Summit registration is open!
Revolutionizing Real-Time Data Management with SQL Server, Kafka, and Informatica
PostgreSQL Basics: Getting started with psql
Using Ledger in Azure SQL Database
Creating a Standalone Executable Python Application
A Brief Introduction to PowerShellAI, an Intelligent Command-line
Automatically Tracking and Deploying Static Data in Flyway Enterprise
What is causing the Always On AG issue? Is it cluster, AD, DNS, or SQL?
Experimenting with Go-SQLCMD
SQL Prompt Safety Net Features for SSMS: Tab Coloring
Extract SharePoint List Data and save to SharePoint Folder as CSV using Power Automate
One use case for NOT using schema prefixes
What Does Setting the SQL Server Compatibility Level Do?
イメージのランダム化を強制する(必須ASLR) に「既定でオンにする」を設定した場合、Express Edition の日本語版のインストーラの起動に失敗します
[Video] Office Hours Speed Round: 21 Answers in 15 Minutes
Office Hours Speed Round, Easy Text Answers Edition
SQL Server でオフライン バックアップおよびオフライン リストアを行うと問題が出ることがある
SQL Prompt Safety Net Features for SSMS: SQL History
Create an Empty Database Using SQL Server Integration Services
Use DDL Triggers to Automatically Keep SQL Server Views in Sync
Make data more human with Azure OpenAI and Azure SQL
Finding and Tuning Expensive Stored Procedures using SQL Monitor
Data Oriented Cloud Security Mechanisms
Three Use Case Examples for SQL Subqueries
Cumulative Update #20 for SQL Server 2019 RTM
Cumulative Update #3 for SQL Server 2022 RTM
5 reasons to join us at Securely Migrate and Optimize with Azure
[Video] Office Hours: Ask Me Anything About Azure SQL DB & MSSQL
SQL ConstantCare® Population Report: Spring 2023
Announcing Azure Data Studio 1.43
How to secure legacy ASP.NET MVC against Cross-Site(CSRF) Attacks
PASS Data Community Summit registrations are open!
WIT Engagement Survey For Female Speakers
Announcing .NET 8 Preview 3
Announcing Live Office Hours on Wednesdays & Thursdays
PostgreSQL Schema: Learning PostgreSQL with Grant
Announcement: New Features and changes to SQL IaaS Agent Extension
A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers
Enhancing SSIS ETL Tools with SolarWinds Task Factory
How to work with ChatGPT in Visual Studio Code
Ordered Columnstore Indexes in SQL Server 2022
Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches
Performance Tuning with SQLFacts Tools
What SQL Server People Should Know About Amazon Aurora Serverless
[Video] Office Hours: Ask Me Anything at Sea
The ten habits for highly successful compliant database DevOps
PASS Data Community Summit 2023 registrations are open!
Who’s Hiring in the Microsoft Data Platform Community? April 2023 Edition
Modifying MySQL data from within Python
Improving SQL Server Performance and Availability with Accelerated Database Recovery
DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
Improving the Quality of your Database Monitoring
Snowflake Temporary Tables vs. Transient Tables
Shrink Database Log Files One by One
GENERATE_SERIES: My new go-to to build sets
Generic ODBC external data sources may not work after installing Cumulative Update
Update XML files using PowerShell
A Beginners Guide to MySQL Replication Part 1
Let's make it easy! How to read System Health and sp_server_diagnostics?
[Video] Office Hours: Ask Me Anything About SQL Server in Costa Rica
Data API Builder Quickstart Demo from VS Live Vegas
Piping, Filtering and Using Flyway Output in PowerShell
The role of forethought for a computer engineer
Accelerated Database Recovery enhancements in SQL Server 2022
Is SQL Server 2019 More CPU-Intensive Than SQL Server 2016?
The Curious Case of…. alcoholism
Using Virtual Network Data Gateways to Secure Access to Azure SQL in Power BI
This is the Last Week of Free PowerShell Training.
How to use the SQL WHERE Clause with Examples
Passing parameters to query without TVFs
Database Monitoring: The ROI of Build vs. Buy
Adoptez une approche Lakehouse pour vos projets BI avec Azure Synapse Analytics
Les bonnes mauvaises pratiques des groupes de disponibilité AlwaysOn
How to Connect SQL Server and Create C# Objects for Data Management
SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners – Part II
Thought Leadership resource page
Announcing the New Azure Cosmos DB Desktop Data Migration Tool
Office Hours: Questions That Didn’t Make the Cut
Updating SQL Server containers deployed on Kubernetes!
[Video] Office Hours in Cartagena, Colombia
The future of AI in solving database challenges
It’s Monday. Do You Know Where Your PowerShell Training Is?
ChatGPT and PowerShell – Some practical examples
New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT
Datafrogs Conférence : Recherche Full-Text
The Basics of PostgreSQL Views
What are the biggest challenges organizations face in their digital transformation efforts?
SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types
Slow Startup, Failover, and Restore Times with In-Memory OLTP
Cumulative Update #2 for SQL Server 2022 RTM
Announcing Polyglot Notebooks! Multi-language notebooks in Visual Studio Code
Announcing Data API builder for Azure Cosmos DB
Data API builder for Azure SQL Databases – Public Preview
Recording What’s Changed when Running Oracle Migrations with Flyway
[Video] Office Hours at Sea: Heading to Jamaica
EF Core 8 Preview 2: Lite and familiar
Are PostgreSQL memory parameters magic?
Better Keep Up: More Free PowerShell Videos This Week.
How to Install the AdventureWorks Sample Database in Azure SQL Database
Find Invalid Objects in SQL Server
[Cross post] Top 25 most common SQL Server Engine Errors (MSSQLSERVER_XXXX)
On-Demand Webinar – Monitoring: The ROI of Build vs. Buy
How to Implement CI/CD in Azure Data Factory (ADF)
SELECT DISTINCT SQL Command to Return a Unique List of Values
Build a Better WordPress Archives Page Using MySQL
SQL Server 2022: Intel® QuickAssist Technology overview
Do you need Trace Flag 460?
Who’s Hiring in the Microsoft Data Platform Community? March 2023 Edition
Complex Production Database Deployments and Flyway
Why a monitoring tool is an essential tool for growing server estates
Microsoft Drivers 5.11 for PHP for SQL Server Released
I’m Coming to Boston for SQLSaturday!
Synapse Serverless and Dedicated Pool: The differences no one told you about
Optional Code in T-SQL Scripts using SQLCMD
It’s Monday. Get Back to Learning PowerShell.
ChatGPT in SQL Server – Practical examples
Snowflake for SQL Server Developers – NULL Functions – Part 2
Understanding Azure Synapse Analytics Pricing
How to Improve the Quality of Database Releases using Clones
Creating Animated Line Plots with Python
Retrieving MySQL data from within Python
I’m Coming to Gothenburg and Oslo This Fall!
Learn PowerShell in 30 Minutes a Day, Free, Starting Now.
Testing before coding: shifting farther left
Getting Started with Azure SQL Bindings: Part 1
Can You Nest Transactions in SQL Server?
Top 25 SQL Server Engine Errors Based on support case volumes Documented
[Data Virtualization] May need to update Java (JRE7 only uses TLS 1.0)
Event exceeds the number of allowable bound actions
How to create a Sankey Chart in Power BI Desktop
How to Forecast Data in Power BI
The business value of frequent deployments
Find 40 Problems in This Stored Procedure.
An Overview of PostgreSQL Window Functions
Getting started with SSIS External Configuration File
Find 40 Problems in this SQL Server Stored Procedure
SQL Server 2022 : bug Filestream
Office Hours: Short Text Answers Edition
Undoing Actions on Groups of Database Tables
Azure Automation With Visual Studio Code
PostgreSQL Basics: Object Ownership and Default Privileges
EF Core 8 Preview 1: Raw, lazy, and on-time
Updated First Responder Kit and Consultant Toolkit for February 2023
SQL Server 2022: Measuring Extended Events Performance Impacts
3 Key Areas to Drive Digital Transformation
json_object and json_array Functions SQL Server 2022 Tutorial
Cumulative Update #1 for SQL Server 2022 RTM
Cumulative Update #19 for SQL Server 2019 RTM
Join us in our castle at SQL Bits, March 15-18
Resources for PL-900 Microsoft Power Platform Fundamentals Certification Exam
[Video] Office Hours Brought to You by Quest Software
Security Update for SQL Server 2022 RTM GDR
Security Update for SQL Server 2019 RTM CU18
Security Update for SQL Server 2017 RTM CU31
Azure Machine Learning Introduction: Part 1 Overview and prep work
OLE DB Driver 19.3 for SQL Server Released
Easily migrate SQL Server applications to the cloud with Azure
ODBC Driver 18.2 for SQL Server Released
Getting Started with Flyway Migrations on Oracle
A Simple Tutorial for DML Triggers
Who’s Hiring in the Microsoft Data Platform Community? February 2023 Edition
What is ChatGPT – Is it the rise of the Skynet era?
An Introduction to Assessing Normal Distribution with Python
How do your DevOps plans really measure up?
Join Redgate at SQL Bits, March 15-18
Steps to add a new disk to SQL Server failover cluster instance and move a user database to it
PostgreSQL Temporary Table
How to ask for programming help
[Video] Office Hours: Quiet Sunday Edition
Petit guide de Transact SQL – Partie 1
Firebase and Supabase: Key differences you need to know
Azure Developer CLI (azd) – February 2023 Release
Free Training Coming Up! March is PowerShell Month.
A Version Control Strategy for Branch-based Database Development
A Simple Example of Flyway Development using GitHub Branching
[Video] Office Hours: Snowy Michigan Edition
Using TOP clause in a SELECT statement
SQL Server on Azure VMs – the best price-performance gets even better!
Schedule Jobs on a Clustered SQL Server
The Database DevOps Transformation
Privileges and Roles in SQL Server, Oracle and PostgreSQL – Part 1
Power BI Dataset Scale-Out
Testing Databases: What’s Required?
Extend your Power BI Reports with Analysis Services 2022 Data
Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL
PostgreSQL Constraints: Learning PostgreSQL with Grant
[Video] Office Hours: 22 Good Questions and a Stinker
JDBC Driver 12.2 for SQL Server Released
[Video] Office Hours: Quickie Before Dinner
The Data Fabric – Future of Data Management
Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory
Optimizing Queries in MySQL: Optimizing Reads
Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions
Microsoft Drivers 5.11.0 Beta 1 for PHP for SQL Server Released
Backup Directly to a GCS Bucket in SQL Server 2022
Dealing with Mutually Dependent Databases in Flyway
Encrypt SQL Server Stored Procedures to Protect Source Code
Publishing a Public Power BI Report from Google Sheets
Dealing with Cross-Server Database Dependencies in Flyway Projects
Configure Contained Availability Groups for High Availability in SQL Server 2022
SQL Server Management Studio (SSMS) 19.0 Released!
HPE SGLX – The new Azure VM extension for SQL Server on Linux
[Video] Office Hours: Ten Minutes of SQL Server Answers
Bite-Sized Office Hours: Q&A on TikTok
Dynamic ELT with Azure Data Factory – Part 3 of 3
DevOps Process Improvement Course
Azure Cosmos DB & Power BI Incremental Refresh
Azure Functions and Managed Identity: More Secrets
How to Import Data in Power BI Using R
A Version Control Strategy for Database DevOps
SQL Server Function Examples with JSON Files
CTEs, Views or Temp Tables?
Released: General Availability of Microsoft.Data.SqlClient 5.1
SQL Server point in time recovery
PostgreSQL Basics: Roles and Privileges
Best practices assessment -Arc-enabled SQL Server
The 20th Anniversary of the SQL Slammer Worm
Technical Considerations for Data Ingestion – Part 2
Understanding Windows Server Cluster Quorum Options
Manage Data Over Time with SQL Server MERGE Statement
[Video] Office Hours: Back Live on Twitch Again
SQL Server containers on Kubernetes with S3-compatible object storage – Getting started
Synapse Serverless: CETAS requires DFS to work
How to Install SQL Server and the Stack Overflow Database on a Mac
How to work with web information, maps, and images in Power BI
Bucket Sort Algorithm in Python to Sort a List of Array Values
Hotfix: JDBC Driver 10.2.3 for SQL Server Released
Hotfix: JDBC Driver 11.2.3 for SQL Server Released
Development with SQL in containers on macOS
Database Sharding to help Improve Performance and Maintenance Tasks
Using pre-commit to prevent simple mistakes
How to Create a Box and Whisker Plot in Power BI Desktop
Working with time series data in SQL Server 2022 and Azure SQL
[Video] Office Hours: Bad Hair Edition
Office Hours: Bad Questions Edition
Translate Text Data using Azure Cognitive Services
Useful Commands for Snowflake Transactions
Index Types in PostgreSQL: Learning PostgreSQL with Grant
Released: SCOM Management Packs for Azure SQL Database, SQL Server, RS, AS (7.0.42.0)
How to Create a Power BI report using MySQL data
Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools
Using sp_prepare and sp_execute to utilize prepared SQL statements
Cross-RDBMS Code Quality Reports in Flyway
Introducing the MySQL common table expression
How to Find Missing Rows in a Table
The SQL Server Posts You Read the Most in 2022
Setting up for Team-based Database Development using Flyway Desktop
Azure Function and User Assigned Managed Identities
Microsoft R Application Network usage & retirement
Microsoft R Application Network retirement
Announcing the 2023 Data Professional Salary Survey Results.
Who’s Hiring in the Microsoft Data Platform Community? January 2023 Edition
DataOps for Power BI
The Importance of a Good Data Model in Power BI Desktop
T-SQL Language Changes in SQL Server 2022 Part 3
Secure File Transfer Protocol (SFTP) support for Azure Blob Storage
Enabling digital transformation – and data modernization – with DevOp
[Video] Office Hours: Holiday Speed Round
SQL ConstantCare® Population Report: Winter 2022
Executing Optional Code in Flyway Callbacks
[Video] Office Hours: Ham Pillow Edition
The Lock Escalation Threshold – Part 3
Building a SQL Computational Framework for MACD Indicators
Flyway Desktop in Database Development Work: An Overview
Heapq Module in Python: Using Heaps and Priority Queues
Should You Use SQL Server 2022’s GREATEST and LEAST?
Should You Use SQL Server 2022’s STRING_SPLIT?
Maintaining a Utilities Schema in a Flyway Project
The Mentoring Class of 2023
Should You Use SQL Server 2022’s DATETRUNC?
Build Your Own Podcast App with .NET 7, Blazor, and .NET MAUI
SQL Server 2022: How Auto-Drop Statistics Work
Resolving to Write in the New Year
What’s New in Visual Studio Extensions for SSAS and SSRS
Artificial Intelligence with Power BI
SSIS Bad Habits: Decreasing SSIS Package Performance
Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back
Hotfix: JDBC Driver 11.2.2 for SQL Server Released
Released: Update to Microsoft OLE DB Driver 18 for SQL Server
Deploy and Configure Azure SQL Managed Instance
How to create a Power BI report using REST API data
Hotfix: JDBC Driver 10.2.2 for SQL Server Released
[Video] Office Hours: Great Questions, Part 2
Updated First Responder Kit and Consultant Toolkit for December 2022
Reviewing SQL Migration Files Before a Flyway Migration
How to use FILESTREAM, query the metadata, and access filestream data using TIFF files
How to use FILESTREAM, query the metadata , access filestream data (using TIFF files) in SQL Server
[Video] Office Hours: Great Questions, Part 1
Polyglot Notebooks – December 2022 Release
What’s new on Power BI DataMarts UI
Trace Flag 8904 – Disable Inline Database Log Flushes
Intermittent ANONYMOUS LOGON of SQL Server linked server double hop
Automate Power BI desktop data model with a PowerShell script
Exploring Hive Tables with Spark SQL
New DevOps Process Improvement Course
Released: SQL Server 3rd Party Backend for Django v1.2
Backing up MySQL Part 8: Zmanda Backups for MySQL & Other Backup Tools
The Enterprise Roadmap to Reducing Costs (While Increasing Value)
Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String
Data Activity Tracking Using SQL Triggers
.NET 7 Networking Improvements
SQL Server のフルテキスト検索機能を用いて Word や PDF ファイルから日本語を検索する Search Japanese from Word & PDF files with FTS
SQL Server のフルテキスト検索機能を用いて Word や PDF ファイルから日本語を検索する
Data Masking in Principle
Who’s Hiring in the Microsoft Data Platform Community? December 2022 Edition
Update: ODBC Driver 17.10.2 for SQL Server Released
Connecting the Dots of Azure SQL CICD Part 3: Testing with tSQLt
The Good, The Bad, and Suboptimal of Sticking to What You Know
Webinar | Database Monitoring: The ROI of Build vs. Buy
Amazon EC2 | Creating a Connection to an Amazon RDS Instance
SQL Server 2022 Paid Editions Require a Licensing Key
Dealing with the Bits of a Binary Value in SQL Server
Backing Up MySQL Part 7: MySQL Enterprise Backup
A Real-world Implementation of Database DevOps: People, Processes, Tools
SQL RAISERROR to Better Handle Errors
Getting started with ROUND() and Its Use Cases
Mentoring 2023 – want some help from me?
Cardinality Estimation Feedback in SQL Server 2022
Backing Up MySQL Part 6: Physical vs. Logical Backups
The Black Friday Sale Has Been Extended!
FCI failed to do failover because of ReAclDirectory : Failed to apply security when applying patch
Basic Checks on a New AWS RDS SQL Server
Webinar | Test Data Management
Slow “Having” Query? Try Pre-Filtering.
New In SQL Server 2022 and Azure SQL: XEvent Performance Metrics
Azure KeyVault を用いて AG 環境の暗号化を実施する
A week in Seattle in 8 Slides at the PASS Data community Summit 2022
Being Agile – A Success Story
SQL Server at Scale – Using an Archive Table – Part 2
The Curious Case of… community
Backing Up MySQL Part 5: Backing Up Big Data
[Video] Office Hours: Black Friday Edition
Express.js or Next.js for your Backend Project
Is Azure SQL Database a Good Choice for your Database Applications?
Troubleshooting external data and access policies in Azure SQL and SQL Server
Contest: Guess the Next SQL Server Release Date
Migrate Azure Analysis Services to Power BI Premium
Using SQL Backup in Development Work
Are You Underpaid? Let’s Find Out: The 7th Annual Data Professional Salary Survey is Open.
Backing up MySQL Part 4: mydumper
Converting Data Across Time Zones: An In-Depth Primer
SQL Server 2022: Azure AD Authentication
Microsoft lance officiellement SQL Server 2022
Looking Back at the 2022 #PASSDataCommunitySummit in Seattle
SQL Server 2022 se convertit au cloud hybride
New Flyway Course on Redgate University
Amazon RDS – Configuring a Connection to a SQL Server Instance
An Introduction to SQL Triggers
Backing up MySQL Part 3: mysqlpump
#PASSdataCommunitySummit Keynote Day 3 Live Blog
Retrouvez la version d'origine
Try Before You Commit in Flyway
How to get IO statistics of SQL Server database files
Microsoft publie SQL Server 2022 avec de nouvelles fonctionnalités pour Azure et des améliorations de performances, l'entreprise affirme que cette version est la plus compatible avec Azure à ce jour
#PASSdataCommunitySummit Keynote Day 2 Live Blog
Manage, govern, and secure all your SQL Servers with new hybrid capabilities enabled by Azure Arc
SQL Server 2022 Paid Editions Require a Licensing Key.
SQL Server がインストール済みのAzure VM をデプロイする際、サーバーの照合順序を変更すると、デプロイに失敗する場合があります
SQL Server 2022 est disponible
Backing Up MySQL Part 2: Percona XtraBackup
Azure Data Studio November release
New SQL Server on Azure Virtual Machines and Azure SQL Managed Instance DR benefits
SQL Server 2022 Release Date: November 16, 2022
Manage, secure, and govern your SQL Server estate from Azure
SQL Server 2022 is now generally available
Link feature for Azure SQL Managed Instance: Connecting SQL Server 2022 to the cloud, reimagined
Azure SQL Database External REST Endpoints Integration Public Preview
Join #TeamHugo and Help Fight Leukemia.
#PASSdataCommunitySummit Keynote Day 1 Live Blog
Flyway Enterprise is here…
SQL LIKE Statement for Various Text Patterns
Report Server Temporary database configuration with Always on Availability groups in SQL server
How monitoring tools can help you excel at your job
Build Your Own SQL Server Central Monitoring Solution with PowerShell
Tutorial to Create a Power BI Report Using PostgreSQL
Introducing the MySQL DELETE statement
Office Hours: Read This, Watch This Edition
Released: Microsoft.Data.SqlClient 5.1 Preview 2
The Art of Data Ingestion – Part 1
Refresh a Power BI Dataset using Microsoft Power Automate
Optimizing MySQL: The Basics of Query Optimization
Optimum performance for your data with SQL Server 2022
[Video] Office Hours: Sponsored By Black Friday Edition
Women as Tech Leads – Tackling the Challenges at the Data Community Summit
Azure Data Studio and BDC Retirement
PASS Data Community Summit 2022 keynote: Transform your data estate with Microsoft’s Intelligent Data Platform
.NET 7 is Available Today
Entity Framework Core 7 (EF7) is available today
[Video] Office Hours: Surprise Edition
The Basics of Deleting Data from a SQL Server Table
Connecting the Dots of Azure SQL CICD Part 2: Local Development
SQL Server Indexes to Improve Query Performance
MDX in Power BI tutorial
Meetup du Club Power BI de Strasbourg, novembre 2022
How to Use Any SQL Database in GO with GORM
Take the SQL Server Mac challenge
Early technical preview of JDBC Driver 12.1.0 for SQL Server released
Join a community like no other at Summit
Leveraging the Script Activity within Azure Data Factory
Cassandra Springboot Integration
Update: ODBC Driver 18.1.2 for SQL Server Released
Is There a Bug in SQL Server’s MAXDOP Calculation?
Who’s Hiring in the Microsoft Data Platform Community? November 2022 Edition
Multi-column statistics
Welcome to the Black Friday Sale of a Lifetime.
Simplifier vos projets BI grâce à Azure Data Factory
Les groupes de disponibilité AlwaysOn par la pratique
Stockage SQL, virtualisation et performances, David Barbarin
Frédéric Brouard – Passer de SQL Server à PostGreSQL ou l’inverse
Hugo Kornelis – T SQL User Defined Functions, or How to kill performance in one, easy step
Christophe Laporte – Configurer SQL Server pour un dépannage efficace
Arian Papillon and Julien Pierre – Les fausses bonnes idées SQL Server
Amar Adghar – Azure, quelle architecture pour moi
David Barbarin – Maintenance des statistiques avec SQL Server
Power Saturday 2020 – La data dans un monde IoT
Power Saturday 2020 – Tests unitaires avec TSQLT
Power Saturday 2020 – SQL Server 2019 de l’intelligence sous le capot
Power Saturday 2020 – Bien maîtriser Azure Data Studio
Power Saturday 2020 – De Docker au Big Data Cluster une nouvelle ère pour SQL server
Power Saturday 2020 – Jupyter Notebooks in Azure Data Studio for the DBA
Power Saturday 2020 – Les usages de l’IoT et l’IA dans le monde agricole
Power Saturday 2020 – Gérez la performance de vos bases de données cross platform simplement
Power Saturday2020 – Les data scientists sont partis. Comment je déploie leurs travaux en production
Power Saturday 2020 – Detect Plan Regression with Query Store
Power Saturday 2020 – Le Big Data en temps réel grâce à Azure
Power Saturday 2020 – Diagnosing performance problems on Azure SQL
Power Saturday 2020 – Migrating existing on prem SQL Datawarehouse to Azure SQL Database (REX)
Power Saturday 2020 – ADF, la clé de voute de vos architectures