Канал: Bert Wagner

A simple, private, chat interface for ChatGPT: Talkie

A simple, private, chat interface for ChatGPT: Talkie

Keeping a dev/work journal in the CLI with jurn

Keeping a dev/work journal in the CLI with jurn

curl and Multi Page Forms

curl and Multi Page Forms

Recursively Querying Related Rows with SQL

Recursively Querying Related Rows with SQL

Should I put my transformation logic into my SQL query?

Should I put my transformation logic into my SQL query?

Moving 1/3 of a Heap

Moving 1/3 of a Heap

COMING SOON

COMING SOON

Network Graph Analysis with Python and NetworkX

Network Graph Analysis with Python and NetworkX

SQL Server Converts Numbers to Asterisks

SQL Server Converts Numbers to Asterisks

Azure SQL vs Azure Table Storage

Azure SQL vs Azure Table Storage

When UPDATE statements DELETE rows!

When UPDATE statements DELETE rows!

Speaking at PASS Summit 2019

Speaking at PASS Summit 2019

SQL Server 2019 Feature Power Rankings

SQL Server 2019 Feature Power Rankings

SQL Stored Procedures, Functions, and Views

SQL Stored Procedures, Functions, and Views

Stored Procedure vs Adhoc Query Performance

Stored Procedure vs Adhoc Query Performance

How to Communicate Effectively at your Workplace

How to Communicate Effectively at your Workplace

SQL Server's "Wrong" Math - Part 2 - Floating Point Errors

SQL Server's "Wrong" Math - Part 2 - Floating Point Errors

SQL Server's "Wrong" Math

SQL Server's "Wrong" Math

Key Concepts - DBA Fundamentals Quick Tip

Key Concepts - DBA Fundamentals Quick Tip

SARGability - DBA Fundamentals Quick Tip

SARGability - DBA Fundamentals Quick Tip

STATISTICS IO, TIME - DBA Fundamentals Quick Tip

STATISTICS IO, TIME - DBA Fundamentals Quick Tip

Tracking Who Changed Row Data in SQL Server

Tracking Who Changed Row Data in SQL Server

SQL Server Cached Plan Reuse

SQL Server Cached Plan Reuse

Troubleshooting SQL Server Execution Plans

Troubleshooting SQL Server Execution Plans

SQL Server Execution Plan Operators

SQL Server Execution Plan Operators

How To Read SQL Server Execution Plans

How To Read SQL Server Execution Plans

SQL Server Execution Plans: Statistics - Part 2

SQL Server Execution Plans: Statistics - Part 2

SQL Server Execution Plans - Part 1

SQL Server Execution Plans - Part 1

How I Continuously Learn SQL Server

How I Continuously Learn SQL Server

SELECT Expression Execution Order in SQL Server

SELECT Expression Execution Order in SQL Server

BEHIND THE SCENES: How I Make Weekly Technical Videos

BEHIND THE SCENES: How I Make Weekly Technical Videos

Multiple Identity Inserts in SQL Server

Multiple Identity Inserts in SQL Server

Trailing Spaces in SQL Server

Trailing Spaces in SQL Server

Joker's Wild

Joker's Wild

SQL Server's CHOOSE Function

SQL Server's CHOOSE Function

12 Ways To Rewrite SQL Queries for Better Performance

12 Ways To Rewrite SQL Queries for Better Performance

Predicate Execution Order on Mixed Data Type Columns

Predicate Execution Order on Mixed Data Type Columns

Magic 8 Ball in SQL Server

Magic 8 Ball in SQL Server

Rewriting Queries with Temporary Staging Tables

Rewriting Queries with Temporary Staging Tables

IN vs Union All in SQL Server

IN vs Union All in SQL Server

Correlated Subqueries vs Derived Tables

Correlated Subqueries vs Derived Tables

Window Functions vs Group By

Window Functions vs Group By

Data Type Precedence and Implicit Conversions

Data Type Precedence and Implicit Conversions

Temporary Stored Procedure Testing

Temporary Stored Procedure Testing

Joining on NULL values in SQL Server

Joining on NULL values in SQL Server

4 Reasons Not To Use VARCHAR(8000) For Every Column

4 Reasons Not To Use VARCHAR(8000) For Every Column

GAPS and ISLANDS in SQL Server

GAPS and ISLANDS in SQL Server

Handling Time Zones and Daylight Saving Time in SQL Server

Handling Time Zones and Daylight Saving Time in SQL Server

Searching Complex JSON in SQL Server

Searching Complex JSON in SQL Server

COUNT, DISTINCT, and NULLs in SQL Server

COUNT, DISTINCT, and NULLs in SQL Server

Parsing HTML In SQL Server

Parsing HTML In SQL Server

Automating Database Maintenance with Jess Pomfret and dbatools

Automating Database Maintenance with Jess Pomfret and dbatools

SQL Server Cardinality

SQL Server Cardinality

Should You Enable Optimize For Ad Hoc Workloads?

Should You Enable Optimize For Ad Hoc Workloads?

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!

AUTOMATE Documentation Generation

AUTOMATE Documentation Generation

Hash Match Join Internals in SQL Server

Hash Match Join Internals in SQL Server

Happy Holidays

Happy Holidays

Merge Join Internals in SQL Server

Merge Join Internals in SQL Server

The Importance of Nested Loops Joins in SQL

The Importance of Nested Loops Joins in SQL

WITH SCHEMABINDING Performance for Scalar Functions in SQL Server

WITH SCHEMABINDING Performance for Scalar Functions in SQL Server

Brute Forcing SQL Server Logins and Passwords

Brute Forcing SQL Server Logins and Passwords

4 Types of SQL Injection

4 Types of SQL Injection

Bert & Pinal Troubleshoot a Slow Performing SQL Server

Bert & Pinal Troubleshoot a Slow Performing SQL Server

How To Learn New SQL, PowerShell, JavaScript, .NET, etc... Skills

How To Learn New SQL, PowerShell, JavaScript, .NET, etc... Skills

The 5 Scariest Moments for a SQL Developer

The 5 Scariest Moments for a SQL Developer

SQL Server's Shorthand Date Math Woes

SQL Server's Shorthand Date Math Woes

Conditionally Returning Rows in SQL Server

Conditionally Returning Rows in SQL Server

My Blog/Vlog Horror Story 😱🎃👻

My Blog/Vlog Horror Story 😱🎃👻

Power BI: Dashboards, Reports, and Datasets with the SQL Chefs

Power BI: Dashboards, Reports, and Datasets with the SQL Chefs

SQL Server's TRY_PARSE to Convert Formatted Money Strings

SQL Server's TRY_PARSE to Convert Formatted Money Strings

Extracting JSON Values Longer Than 4000 Characters

Extracting JSON Values Longer Than 4000 Characters

FAKING Temporal Tables with Triggers

FAKING Temporal Tables with Triggers

Does The Order Of Index Columns Matter?

Does The Order Of Index Columns Matter?

FIRST_VALUE without nulls

FIRST_VALUE without nulls

SQL Server Multiple Recursive Member CTEs

SQL Server Multiple Recursive Member CTEs

Techniques to Troubleshoot Your Code

Techniques to Troubleshoot Your Code

Displaying Long Variable Values in SQL Server

Displaying Long Variable Values in SQL Server

When Should I Use An Index Hint?

When Should I Use An Index Hint?

Pinal Dave's Real World Performance Solutions

Pinal Dave's Real World Performance Solutions

T-SQL Tuesday #104 "Code You Would Hate To Live Without" ROUNDUP

T-SQL Tuesday #104 "Code You Would Hate To Live Without" ROUNDUP

A Template For Dynamic Table-Driven Queries

A Template For Dynamic Table-Driven Queries

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)

Filtering Tables, Stored Procedures, and Other Objects in SSMS

Filtering Tables, Stored Procedures, and Other Objects in SSMS

What's Join Elimination?

What's Join Elimination?

What I learned in Brent Ozar's Master Index Tuning Class

What I learned in Brent Ozar's Master Index Tuning Class

Hardcoding Lookup Values In SQL Queries

Hardcoding Lookup Values In SQL Queries

The GO Command in SQL Server Management Studio

The GO Command in SQL Server Management Studio

Convert JSON to CREATE TABLE Statements

Convert JSON to CREATE TABLE Statements

Why is varchar(max) getting truncated?

Why is varchar(max) getting truncated?

SQL Server Community Involvement

SQL Server Community Involvement

JSON Filtered Indexes

JSON Filtered Indexes

SQL Server Recovery Models

SQL Server Recovery Models

SQL Server In-Memory OLTP Use Case

SQL Server In-Memory OLTP Use Case

3 SQL Dev Tools I Can't Live Without

3 SQL Dev Tools I Can't Live Without

Power Query vs DAX with Eugene Meidinger

Power Query vs DAX with Eugene Meidinger

Time zone conversions with SQL Server's AT TIME ZONE

Time zone conversions with SQL Server's AT TIME ZONE

Stealing Data with Second Order SQL Injection

Stealing Data with Second Order SQL Injection

Fully Automatic Tuning: SQL Server 2026’s Most Killer Feature

Fully Automatic Tuning: SQL Server 2026’s Most Killer Feature

Is your ORM vulnerable to SQL Injection?

Is your ORM vulnerable to SQL Injection?

Split Screen Queries in SSMS

Split Screen Queries in SSMS

OR vs UNION ALL - is one better for performance?

OR vs UNION ALL - is one better for performance?

What I Do When NOT Writing SQL

What I Do When NOT Writing SQL

Speaking SQL with Drew Furgiuele

Speaking SQL with Drew Furgiuele

How do I contribute to dbatools? with Drew Furgiuele

How do I contribute to dbatools? with Drew Furgiuele

The EASIEST Way To Find SQL Query Errors

The EASIEST Way To Find SQL Query Errors

Inverted Polygons: How to troubleshoot SQL Server's Left-Hand Rule

Inverted Polygons: How to troubleshoot SQL Server's Left-Hand Rule

Importing GeoJSON Data Into SQL Server

Importing GeoJSON Data Into SQL Server

SQL Login Can't Connect

SQL Login Can't Connect

A Better Way To Create Scripts for Multiple SQL Database Objects

A Better Way To Create Scripts for Multiple SQL Database Objects

SQL and NOT SQL: Best of 2017

SQL and NOT SQL: Best of 2017

Generating Multi-Object JSON Arrays in SQL Server

Generating Multi-Object JSON Arrays in SQL Server

4 Ways to Reduce Reads in SQL Server for faster performance

4 Ways to Reduce Reads in SQL Server for faster performance

TSQL Tuesday #97: Setting Learning Goals for 2018

TSQL Tuesday #97: Setting Learning Goals for 2018

Performance Tuning with Statistics IO

Performance Tuning with Statistics IO

My Favorite SSMS Shortcut (After Copy/Paste)

My Favorite SSMS Shortcut (After Copy/Paste)

Does SQL table join order matter?

Does SQL table join order matter?

How to Search SQL Query Text in Stored Procedures and Ad-Hoc Queries

How to Search SQL Query Text in Stored Procedures and Ad-Hoc Queries

4 Misconceptions About SQL Injection

4 Misconceptions About SQL Injection

The QUICKEST Way to Get SQL Command Help

The QUICKEST Way to Get SQL Command Help

10 Questions to Ask At Your Next SQL Event

10 Questions to Ask At Your Next SQL Event

Using WAITFOR DELAY and TIME in SQL Server

Using WAITFOR DELAY and TIME in SQL Server

How NOLOCK causes blocking

How NOLOCK causes blocking

SQL Server PowerShell tips with Drew Furgiuele

SQL Server PowerShell tips with Drew Furgiuele

Differences between Clustered vs Nonclustered Indexes in SQL Server

Differences between Clustered vs Nonclustered Indexes in SQL Server

How to use the old legacy cardinality estimator in SQL Server

How to use the old legacy cardinality estimator in SQL Server

SQL Unicode Homoglpyh Injection

SQL Unicode Homoglpyh Injection

How To Parameterize SQL Table Names

How To Parameterize SQL Table Names

How to protect yourself from SQL Injection

How to protect yourself from SQL Injection

Performance of SARGable queries in SQL Server

Performance of SARGable queries in SQL Server

Clean up Ugly SQL Function Syntax with CROSS APPLY

Clean up Ugly SQL Function Syntax with CROSS APPLY

How to Stop Parameter Sniffing in SQL Server

How to Stop Parameter Sniffing in SQL Server

SQL Server Implicit Conversions Hurt Performance

SQL Server Implicit Conversions Hurt Performance

How to Use the SSMS Clipboard Ring

How to Use the SSMS Clipboard Ring

How to Generate a RUNNING TOTAL in SQL Server

How to Generate a RUNNING TOTAL in SQL Server

My Most Embarrassing SQL Moment

My Most Embarrassing SQL Moment

How to Automatically Delete Historical Data From a Temporal Table

How to Automatically Delete Historical Data From a Temporal Table

How to Put SQL Column Names Onto Multiple Lines in SSMS

How to Put SQL Column Names Onto Multiple Lines in SSMS

5 Business Problems You Can Solve Using Temporal Tables

5 Business Problems You Can Solve Using Temporal Tables

Behind the Scenes of an Online Presentation

Behind the Scenes of an Online Presentation

Performance Testing JSON in SQL Server vs C#

Performance Testing JSON in SQL Server vs C#

Rolling Back Temporal Tables

Rolling Back Temporal Tables

How to Use Temporal Tables in SQL Server 2016

How to Use Temporal Tables in SQL Server 2016

XML vs JSON in SQL Server 2016

XML vs JSON in SQL Server 2016

One SQL Cheat Code For Amazingly Fast JSON Queries - SQL JSON Index performance

One SQL Cheat Code For Amazingly Fast JSON Queries - SQL JSON Index performance

How to fix your terribly slow SQL job

How to fix your terribly slow SQL job

JSON Usage and Performance in SQL Server 2016 Bert Wagner

JSON Usage and Performance in SQL Server 2016 Bert Wagner