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: IN vs UNION ALL
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: COUNT, DISTINCT, and NULLs
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