Archives for Data with Bert

Mon 13 November 2023
Crosstream - Efficient Cross-Server Joins on Slow Networks in Python
Mon 19 December 2022
jurn - A Command Line Tool for Keeping Track of Your Work
Thu 03 March 2022
Using curl to Automate Multipage Logins
Tue 25 August 2020
Recursively Querying Row Groups
Wed 29 July 2020
Should I Transform My Data In My SQL Query?
Wed 22 July 2020
Moving 1/3 of a heap
Thu 16 July 2020
COMING SOON - New Content
Tue 07 January 2020
Using Python And NetworkX To Build A Twitter Follower Recommendation Engine
Tue 17 December 2019
SQL Server Converts Numbers to Asterisks
Tue 03 December 2019
Azure SQL vs Azure Table Storage
Tue 26 November 2019
When a SQL UPDATE Statement DELETES Rows
Tue 12 November 2019
First Time Speaking at PASS Summit
Tue 29 October 2019
SQL Server 2019 Feature Power Rankings
Tue 22 October 2019
SQL Server Stored Procedures vs Functions vs Views
Tue 15 October 2019
Are Stored Procedures Faster Than Stand-Alone Queries?
Tue 08 October 2019
Communicating Effectively at the Workplace
Tue 01 October 2019
More "Wrong" SQL Server Math - Floating Point Errors
Tue 24 September 2019
SQL Server's "Wrong" Math
Tue 17 September 2019
SQL Server Quick Tips
Tue 10 September 2019
Tracking Who Last Changed a Row
Tue 03 September 2019
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Tue 27 August 2019
How I Troubleshoot SQL Server Execution Plans
Tue 13 August 2019
SQL Server Execution Plan Operators
Tue 06 August 2019
5 Things You Need To Know When Reading SQL Server Execution Plans
Tue 30 July 2019
Execution Plans: Statistics
Tue 23 July 2019
Introduction to SQL Server Execution Plans
Tue 16 July 2019
How I Continuously Learn About SQL Server
Tue 09 July 2019
SELECT Expression Execution Order
Tue 02 July 2019
Behind the Scenes: How I Create Weekly Technical Videos
Tue 25 June 2019
Multiple Identity Inserts
Tue 18 June 2019
Trailing Spaces in SQL Server
Tue 11 June 2019
Joker's Wild
Tue 04 June 2019
CHOOSE() in SQL Server
Tue 28 May 2019
12 Ways To Rewrite SQL Queries for Better Performance
Tue 21 May 2019
Predicate Execution Order on Mixed Data Type Columns
Tue 14 May 2019
Animating a Magic 8 Ball in SQL Server Management Studio
Tue 07 May 2019
Temporary Staging Tables
Tue 30 April 2019
Tue 23 April 2019
Correlated Subqueries vs Derived Tables
Tue 16 April 2019
Window Functions vs GROUP BYs
Tue 09 April 2019
Data Type Precedence and Implicit Conversions
Tue 02 April 2019
Testing with Temporary Stored Procedures
Tue 26 March 2019
Joining on NULLs
Tue 19 March 2019
4 Reasons To Avoid VARCHAR(8000)
Tue 12 March 2019
Gaps and Islands Across Date Ranges
Tue 12 March 2019
Dipping into the Cookie Jar
Tue 05 March 2019
Time Zones and Daylight Saving Time
Tue 26 February 2019
Searching Complex JSON Data
Tue 19 February 2019
Tue 12 February 2019
Parsing HTML in SQL Server
Tue 12 February 2019
Why make?
Tue 05 February 2019
Automating Database Maintenance with Jess Pomfret and dbatools
Tue 29 January 2019
Cardinality: Not Just For The Birds
Tue 22 January 2019
Optimizing for Ad Hoc Workloads
Tue 15 January 2019
SQL FAILS with Andy Mallon, Erin Stellato, and Mr. Anonymous!
Tue 08 January 2019
T-SQL Documentation Generator
Wed 02 January 2019
Visualizing Hash Match Join Internals And Understanding Their Implications
Tue 01 January 2019
2018 Community Influencer of the Year
Tue 18 December 2018
Visualizing Merge Join Internals And Understanding Their Implications
Tue 11 December 2018
Visualizing Nested Loops Joins And Understanding Their Implications
Tue 04 December 2018
Two Words For Faster Scalar Functions
Tue 27 November 2018
Brute Forcing SQL Logins and Passwords
Tue 20 November 2018
4 SQL Injection Techniques For Stealing Data
Tue 13 November 2018
Bert & Pinal Troubleshoot a Slow Performing SQL Server
Tue 06 November 2018
Learning New Skills
Tue 30 October 2018
The 5 Scariest Moments for a SQL Server Developer
Tue 23 October 2018
Unexpected Shorthand Date Implicit Conversions
Tue 16 October 2018
Conditionally Returning Rows Based On Query Results
Tue 09 October 2018
The Project Graveyard
Tue 02 October 2018
Power BI Dashboards, Reports, and Datasets with the SQL Chefs
Tue 25 September 2018
Shortchanged with International Money in SQL Server
Tue 18 September 2018
Extracting JSON Values Longer Than 4000 Characters
Tue 11 September 2018
Faking Temporal Tables with Triggers
Tue 04 September 2018
Does The Order Of Index Columns Matter?
Tue 28 August 2018
Ignoring NULLs with FIRST_VALUE
Tue 21 August 2018
FizzBuzz and Multiple Recursive Member CTEs
Tue 14 August 2018
6 Techniques For Troubleshooting Your Code
Tue 07 August 2018
Displaying Long Values in SSMS
Tue 31 July 2018
Should You Use Index Hints?
Tue 24 July 2018
Pinal Dave Helps Me Fix My Performance Tuning Problems
Tue 17 July 2018
T-SQL Tuesday #104 Roundup
Tue 10 July 2018
Building Dynamic Table-Driven Queries
Tue 03 July 2018
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
Tue 26 June 2018
Filtering Tables, Procedures, And Other Objects In SSMS
Tue 19 June 2018
Join Elimination: When SQL Server Removes Unnecessary Tables
Tue 12 June 2018
Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class
Tue 05 June 2018
4 Ways To Define Lookup Values In A Query
Tue 29 May 2018
What Does The GO Command Do?
Tue 22 May 2018
Converting JSON to SQL Server CREATE TABLE Statements
Tue 15 May 2018
Why Is My VARCHAR(MAX) Variable Getting Truncated?
Tue 08 May 2018
Contributing to Community
Tue 01 May 2018
Is It Possible To Conditionally Index JSON Data?
Tue 24 April 2018
The Forgotten Fourth SQL Server Recovery Model
Tue 17 April 2018
In-Memory OLTP: A Case Study
Tue 10 April 2018
3 Essential Tools For The SQL Server Developer
Tue 03 April 2018
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Tue 27 March 2018
AT TIME ZONE: The easy way to deal with time zones and daylight savings time
Tue 20 March 2018
How To Steal Data Using Second Order SQL Injection Attacks
Tue 13 March 2018
Full Automatic Tuning: SQL Server 2026's Most Killer Feature
Tue 06 March 2018
2.5 Ways Your ORM Is Vulnerable To SQL Injection
Tue 27 February 2018
Splitting It Up: Side by Side Queries In SSMS
Tue 20 February 2018
OR vs UNION ALL - Is One Better For Performance?
Tue 13 February 2018
What I Do When I'm NOT Writing SQL
Tue 06 February 2018
"How do I contribute to dbatools?" with Drew Furgiuele
Tue 30 January 2018
The Fastest Way To Locate Errors In Your SQL Query
Tue 23 January 2018
Inverted Polygons? How to Troubleshoot SQL Server's Left Hand Rule
Tue 16 January 2018
Importing GeoJSON Earthquake Data Into SQL Server
Tue 09 January 2018
I Have A SQL Login - Why Can't I Connect?
Tue 02 January 2018
A Better Way To Script Database Objects
Tue 26 December 2017
SQL and NOT SQL: Best of 2017
Tue 19 December 2017
How To Create Multi-Object JSON Arrays in SQL Server
Tue 12 December 2017
Reducing the Number of Reads in Your Queries
Tue 12 December 2017
Learning Through Blogging and Speaking
Tue 05 December 2017
How to use Statistics IO to Improve Your Query Performance
Tue 28 November 2017
My Favorite SSMS Shortcut (After Copy/Paste)
Tue 21 November 2017
Does The Join Order of My Tables Matter?
Tue 14 November 2017
How to Search Stored Procedures and Ad-Hoc Queries
Tue 07 November 2017
4 Common Misconceptions About SQL Injection Attacks
Tue 31 October 2017
The Quickest Way To Get SQL Command Help
Tue 24 October 2017
10 Questions To Spark Conversation At Your Next SQL Event
Tue 17 October 2017
How to Make SQL Server Act Like A Human By Using WAITFOR
Tue 10 October 2017
How NOLOCK Will Block Your Queries
Tue 03 October 2017
3 Tips You Need To Know When Using PowerShell with SQL Server
Tue 26 September 2017
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Tue 19 September 2017
How To Make Your Queries Perform Like They Used To
Tue 12 September 2017
ʼ;ŚℇℒℇℂƮ *: How Unicode Homoglyphs Can Thwart Your Database Security
Tue 05 September 2017
How to Safely Parameterize Table Names
Tue 29 August 2017
Warning! Are your queries vulnerable to SQL injection?
Tue 22 August 2017
How to Search and Destroy Non-SARGable Queries on Your Server
Tue 15 August 2017
How to Eliminate Ugly Nested REPLACE() Functions
Fri 11 August 2017
SQLskills is Giving Away Free Training!
Tue 08 August 2017
Why Parameter Sniffing Isn't Always A Bad Thing (But Usually Is)
Tue 01 August 2017
Are your indexes being thwarted by mismatched datatypes?
Tue 25 July 2017
One SSMS Trick That Will Make You a Faster Query Builder
Wed 19 July 2017
How to Use SQL Temporal Tables For Easy Point-In-Time Analysis
Tue 18 July 2017
Here's a Quick Way To Generate a Running Total in SQL Server
Tue 11 July 2017
My Most Embarrassing SQL Moment
Tue 04 July 2017
How to Automatically Purge Historical Data From a Temporal Table
Tue 27 June 2017
How to Put SQL Column Names Onto Multiple Lines in SSMS
Tue 20 June 2017
5 Business Problems You Can Solve With Temporal Tables
Tue 13 June 2017
Behind the Scenes of an Online Presentation
Tue 06 June 2017
5 Things You Need to Do When Performance Testing JSON in SQL and C#
Tue 30 May 2017
How To Roll-Back Data in a Temporal Table
Tue 23 May 2017
How To Use Temporal Tables For Easy Point-In-Time Analysis
Tue 16 May 2017
XML vs JSON Shootout: Which is Superior in SQL Server 2016?
Tue 09 May 2017
One SQL Cheat Code For Amazingly Fast JSON Queries
Tue 02 May 2017
How to fix your terribly slow SQL job
Tue 25 April 2017
Three Changes You Should Always Make Before Checking In Any Code
Tue 18 April 2017
How to write understandable code for your future self
Tue 11 April 2017
Will Technology Eliminate Your Tech Job?
Wed 05 April 2017
[Video] JSON Usage and Performance in SQL Server 2016
Tue 28 March 2017
Who Stuck These Letters In My DateTimes?
Tue 21 March 2017
C#'s foreach ruined my afternoon
Tue 14 March 2017
When Is It Appropriate To Store JSON in SQL Server?
Tue 07 March 2017
The Ultimate SQL Server JSON Cheat Sheet
Tue 21 February 2017
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 4: Performance Comparisons
Tue 14 February 2017
How SQL 2016's JSON Functionality Will Make You Want To Use JSON
Tue 07 February 2017
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 3: Updating, Adding, and Deleting…
Tue 31 January 2017
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 2: Creating JSON
Tue 24 January 2017
JSON Support Is The Best New Developer Feature in SQL 2016 — Overview Part 1: Parsing JSON
Tue 17 January 2017
Present Like Nobody's Watching
Tue 10 January 2017
The Most Lacking Feature In SSRS (7 years and no fix?)
Tue 03 January 2017
Epic Life Quests
Thu 24 November 2016
XmlReader vs XmlDocument Performance
Mon 14 November 2016
Coffee's Variety Problem
Sat 30 April 2016
3 Things I Wish I Knew When I Started Using Entity Framework