
Streamlining Data Analytics with Data Pipelines and a Data Lake
Data Architecture

AI in the Boardroom: Turning Data into Strategic Insights
Data Architecture
Microsoft Entra Authentication: A Superior Alternative to SQL Server Authentication
Data Architecture
Machine Learning for Operational Efficiency
Data Architecture
Fabric Lakehouse Schemas: Your Data’s New Best Friend
Cloud, Data Architecture
SQL Server Performance Tuning: No Consultant Required
Data Architecture
Why Adopting a Modern Data Warehouse Makes Business Sense
Data Architecture
Validating Your SQL Server Backups Made Easy!
Data Architecture
Procure SQL’s Weekly Digest – February 28, 2024!
Newsletter
Procure SQL’s Weekly Digest – February 21, 2024!
Newsletter
Procure SQL’s Weekly Digest – February 14, 2024!
Newsletter
Procure SQL’s Weekly Digest – February 7, 2024!
Newsletter
Procure SQL’s Weekly Digest – January 31, 2024!
Newsletter
Procure SQL’s Weekly Digest – January 24, 2024!
Newsletter
Procure SQL’s Weekly Digest – January 17, 2024!
Newsletter
Procure SQL’s Weekly Digest – January 10, 2024!
Newsletter
Procure SQL’s Weekly Digest – January 3rd, 2024!
Newsletter
SQL Saturday Austin, Texas – Free SQL Training
Announcements, Education
SQL Server 2022 What is New?
Announcements, Performance Tuning
It’s official
Announcements
September 2018 Training Opportunities
Announcements, Community, Education
SQL Saturday Houston 2018
Announcements, Community, Education, General
Procure SQL welcomes Jay Falck!
Announcements
Come See Us at Houston TechFest 2017!
Announcements, Community
Speaking at Microsoft Ignite 2017
Announcements, Community
Angela Tidwell is our Marketing Database Administrator
Announcements
Fabric Lakehouse Schemas: Your Data’s New Best Friend
Cloud, Data Architecture
Azure VMs – How To Go Green
Cloud
Replay in the Cloud
Cloud, Data Architecture, Performance Tuning
Import Databases to Azure SQL Database
Cloud, Data Architecture, Data Intergration
Does Automation Kill the DBA “Store”?
Cloud, Community
Austin Texas SQL Saturday was a Success!
Community
SQL Saturday Jacksonville Sponsors
Community
Getting Started with SQL Server Performance Tuning
Community
September 2018 Training Opportunities
Announcements, Community, Education
SQL Saturday Houston 2018
Announcements, Community, Education, General
Four Tips for Entry-Level and Experienced IT Professionals
Community
My SQL Saturday Firsts
Community
The Importance of SQL Saturdays
Community, DBA 101, Education
Free SQL Education!
Community, Education, Uncategorized
Benchmarking Queries with SentryOne Plan Explorer
DBA 101, Performance Tuning
Do I Need to Backup System Databases?
DBA 101, Disaster Recovery or High Availability, Health Checks
What is RPO/RTO?
DBA 101, Disaster Recovery or High Availability
Does Your Database Have any Integrity?
DBA 101, Disaster Recovery or High Availability, Health Checks, Uncategorized
Deep Dive into Bulk Logged Recovery Model
DBA 101, Disaster Recovery or High Availability
Demystifying System Databases
DBA 101, Design, Disaster Recovery or High Availability
The Importance of SQL Saturdays
Community, DBA 101, Education
Validating SQL Server Backups
DBA 101, Disaster Recovery or High Availability
SQL Server Recovery Models
DBA 101, Disaster Recovery or High Availability, Education
SQL Saturday Houston 2018
Announcements, Community, Education, General
SQL Saturday Chicago
General, Performance Tuning
Finding Top Offenders with Extended Events
General, Performance Tuning
Do I Need to Backup System Databases?
DBA 101, Disaster Recovery or High Availability, Health Checks
Does Your Database Have any Integrity?
DBA 101, Disaster Recovery or High Availability, Health Checks, Uncategorized

Finding Query Anti-Patterns in Your Developer’s Queries
Performance Tuning
Tuning Update Statement with SQL Server
Disaster Recovery or High Availability, Performance TuningYou are out doing your scheduled sweeps of the environment and you notice a huge I/O consumer is one of your update procedures. Your initial thought may be to panic because how can you test data that is changing? You have several methods to tuning queries that adjust data that allow data to revert between […]
The post Tuning Basics – Updating an Update appeared first on dbWonderKid.

SQL Server 2022 What is New?
Announcements, Performance Tuning
Clustered Index vs Heap
Clustered index, heap, Performance Tuning
Replay in the Cloud
Cloud, Data Architecture, Performance Tuning
Benchmarking Queries with SentryOne Plan Explorer
DBA 101, Performance Tuning
Query Store for Workload Replays
Data Architecture, Performance Tuning
5 Game Changers with SQL Server 2019
Data Architecture, Performance Tuning
Clustered Index vs Heap
Clustered index, heap, Performance Tuning
Power BI: Discover What License Is Best for Your Money
ReportingQuery Store 101
sql server 101Today I heard a great analogy, and it inspired this post. Execution plans are like flight plans, there are multiple flight paths that can be taken to get from where you are to your ultimate destination. Some plans are more efficient than others, and we want to use those whenever possible. How can I make […]
The post Query Store 101 appeared first on dbWonderKid.

Streamlining Data Analytics with Data Pipelines and a Data Lake
Data Architecture

AI in the Boardroom: Turning Data into Strategic Insights
Data Architecture
Microsoft Entra Authentication: A Superior Alternative to SQL Server Authentication
Data Architecture
Machine Learning for Operational Efficiency
Data Architecture
Fabric Lakehouse Schemas: Your Data’s New Best Friend
Cloud, Data Architecture
SQL Server Performance Tuning: No Consultant Required
Data Architecture
Why Adopting a Modern Data Warehouse Makes Business Sense
Data Architecture

Growing New Speakers T-SQL Tuesday #84
The Blog
Enable Multi-Factor Authentication, Please!
Advice
Five Tips for Working Remotely
Advice, Education
John Sterrett: A Microsoft Data Platform MVP
Awards
Clustered Index vs Heap
Clustered index, heap, Performance Tuning
SQL Saturday Austin, Texas – Free SQL Training
Announcements, Education
Five Tips for Working Remotely
Advice, Education
September 2018 Training Opportunities
Announcements, Community, Education
SQL Saturday Houston 2018
Announcements, Community, Education, General
The Importance of SQL Saturdays
Community, DBA 101, Education
Free SQL Education!
Community, Education, Uncategorized
SQL Server Recovery Models
DBA 101, Disaster Recovery or High Availability, Education
A Beginner’s Guide to SQL Server Backups
DBA 101, Disaster Recovery or High Availability, Education
Building Your First Always On Availability Group
Disaster Recovery or High Availability, Education
Streamlining Data Analytics with Data Pipelines and a Data Lake
Data Architecture

AI in the Boardroom: Turning Data into Strategic Insights
Data Architecture
Microsoft Entra Authentication: A Superior Alternative to SQL Server Authentication
Data Architecture
Machine Learning for Operational Efficiency
Data Architecture
Fabric Lakehouse Schemas: Your Data’s New Best Friend
Cloud, Data Architecture
SQL Server Performance Tuning: No Consultant Required
Data Architecture
Why Adopting a Modern Data Warehouse Makes Business Sense
Data Architecture

QUOTED IDENTIFIER Set Incorrectly?!
DesignSo What Is Going On? I recently ran into an issue when I set up a job to collect information from an extended event. I wanted to write that to a table in my scratch DBA database. This allowed the customer and I to slice and dice data with ease. This seemed easy enough. I […]
The post QUOTED_IDENTIFIER Set Incorrectly?! appeared first on dbWonderKid.

Where did my string or binary data get truncated?
Data Architecture, Design
Demystifying System Databases
DBA 101, Design, Disaster Recovery or High Availability
Is external governance coming to SQL Server 2022?!?!
Features
Import Databases to Azure SQL Database
Cloud, Data Architecture, Data IntergrationNewsletter Signup
![]() | Thank you for Signing Up |


Blog Categories
Tags
Archives
- January 2025
- December 2024
- November 2024
- October 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- February 2024
- January 2024
- November 2023
- October 2023
- March 2023
- January 2023
- May 2022
- April 2022
- November 2021
- October 2021
- September 2020
- August 2020
- April 2020
- March 2020
- February 2020
- January 2020
- December 2019
- November 2019
- September 2019
- July 2019
- April 2019
- November 2018
- September 2018
- August 2018
- July 2018
- June 2018
- May 2018
- April 2018
- March 2018
- February 2018
- January 2018
- November 2017
- October 2017
- August 2017
- July 2017
- June 2017
- April 2017
- December 2016
- November 2016
- October 2016
- July 2016