Deschide articolul original într-un tab nou Schimbarea acestei opțiuni se aplică imediat și reîncarcă pagina.
LECTURA
Înapoi la articole →

Data with Bert

bertwagner.com/atom.xml
Vizitează site-ul

Cel mai recent articol

Ultima verificare

Urmăritori 0 urmăritori
Articole: 100

  1. Creating a Pulsing Conducting Baton - Part 1

    (Data with Bert)

    Train Wreck The last time I watched a high school band nearly fall apart mid-performance was when the relatively new, certainly nervous band director started the piece off much faster than what the students could play.

  2. An LLM Saved My ATtiny85 From Certain Death

    (Data with Bert)

    I almost ordered parts for a circuit that would have destroyed itself the instant I powered it on.

  3. Self-Hosting a Photo Server the Whole Family Can Use

    (Data with Bert)

    Until recently, my family's 90,000+ photos have been hidden away in the depths of my gaming PC's hard drives.

  4. SplashFlag - Building an IoT Swimming Notification Device from Scratch

    (Data with Bert)

    After setting up dozens of Internet of Things (IoT) smart home devices, I started to wonder: how hard could it be to build one from scratch?

  5. Talkie - a simple, private, responsive interface for LLMs

    (Data with Bert)

    Watch this video on YouTube I like using ChatGPT.

  6. Crosstream - Efficient Cross-Server Joins on Slow Networks in Python

    (Data with Bert)

    Earlier this year I presented at PyCon 2023 in Salt Lake City, UT on the topic of "Efficient Cross-Server Data Joins on Slow Networks with Python".

  7. jurn - A Command Line Tool for Keeping Track of Your Work

    (Data with Bert)

    Watch this week's video on YouTube How do you keep track of your daily work accomplishments?

  8. Using curl to Automate Multipage Logins

    (Data with Bert)

    Watch this week's video on YouTube I like solving the daily New York Times crossword on paper.

  9. Recursively Querying Row Groups

    (Data with Bert)

    Watch this week's video on YouTube Recursive queries are fun to plan and write.

  10. Should I Transform My Data In My SQL Query?

    (Data with Bert)

    Watch this week's video on YouTube Imagine you need to join two tables of data and filter the results.

  11. Moving 1/3 of a heap

    (Data with Bert)

    Watch this week's video on YouTube A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap.

  12. COMING SOON - New Content

    (Data with Bert)

    Watch this week's video on YouTube Hey everyone.

  13. Using Python And NetworkX To Build A Twitter Follower Recommendation Engine

    (Data with Bert)

    Watch this week's video on YouTube This week, I want to share my process for analyzing Twitter.

  14. SQL Server Converts Numbers to Asterisks

    (Data with Bert)

    Watch this week's video on YouTube Pop quiz: What will be the output of the below three statements?

  15. Azure SQL vs Azure Table Storage

    (Data with Bert)

    Watch this week's video on YouTube A year ago I built an app to keep track of pickup volleyball game scores and payments.

  16. When a SQL UPDATE Statement DELETES Rows

    (Data with Bert)

    Watch this week's video on YouTube At first I wasn't going to write this post.

  17. First Time Speaking at PASS Summit

    (Data with Bert)

    Watch this week's video on YouTube This week, I filmed my experience as a first time speaker at PASS Summit in Seattle.

  18. SQL Server 2019 Feature Power Rankings

    (Data with Bert)

    Watch this week's video on YouTube With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in the new release.

  19. SQL Server Stored Procedures vs Functions vs Views

    (Data with Bert)

    Watch this week's video on YouTube SQL Server has several ways to store queries for later executions.

  20. Are Stored Procedures Faster Than Stand-Alone Queries?

    (Data with Bert)

    Watch this week's video on YouTube A few months ago I was presenting for a user group when someone asked the following question: Does a query embedded in a stored procedure execute faster than that same query submitted to SQL Server as a stand alone state…

  21. Communicating Effectively at the Workplace

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates.

  22. More "Wrong" SQL Server Math - Floating Point Errors

    (Data with Bert)

    Watch this week's video on YouTube Last week we looked at how implicit conversions and datatype precedence can cause SQL Server to output unexpected results (if you aren't aware of how it handles these features).

  23. SQL Server's "Wrong" Math

    (Data with Bert)

    Watch this week's video on YouTube A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a true wall instead.

  24. SQL Server Quick Tips

    (Data with Bert)

    Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations.

  25. Tracking Who Last Changed a Row

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #118 prompt by Kevin Chant.

  26. Whitespace, Letter Case, and Other Things That Prevent Plan Reuse

    (Data with Bert)

    Watch this week's video on YouTube Last week's post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace.

  27. How I Troubleshoot SQL Server Execution Plans

    (Data with Bert)

    Watch this week's video on YouTube Part 1: Introduction to Execution Plans Part 2: Overview of Statistics Part 3: Reading an Execution Plan Part 4: Commonly Troublesome Operators Part 5: Troubleshooting Execution Plans Today I'm concluding my series on SQL

  28. SQL Server Execution Plan Operators

    (Data with Bert)

    Watch this week's video on YouTube Part 1: Introduction to Execution Plans Part 2: Overview of Statistics Part 3: Reading an Execution Plan Part 4: Commonly Troublesome Operators Part 5: Troubleshooting Execution Plans When examining a query's execution p…

  29. 5 Things You Need To Know When Reading SQL Server Execution Plans

    (Data with Bert)

    Watch this week's video on YouTube Part 1: Introduction to Execution Plans Part 2: Overview of Statistics Part 3: Reading an Execution Plan Part 4: Commonly Troublesome Operators Part 5: Troubleshooting Execution Plans In the first part of this series I e…

  30. Execution Plans: Statistics

    (Data with Bert)

    Watch this week's video on YouTube Part 1: Introduction to Execution Plans Part 2: Overview of Statistics Part 3: Reading an Execution Plan Part 4: Commonly Troublesome Operators Part 5: Troubleshooting Execution Plans Last week we looked at what execution

  31. Introduction to SQL Server Execution Plans

    (Data with Bert)

    Watch this week's video on YouTube Part 1: Introduction to Execution Plans Part 2: Overview of Statistics Part 3: Reading an Execution Plan Part 4: Commonly Troublesome Operators Part 5: Troubleshooting Execution Plans I nearly always use execution plans…

  32. How I Continuously Learn About SQL Server

    (Data with Bert)

    Watch this week's video on YouTube In order to stay current in a technology you have to immerse yourself in community content.

  33. SELECT Expression Execution Order

    (Data with Bert)

    Watch this week's video on YouTube Today I want to share with you an interesting observation I made about SELECT expression execution order.

  34. Behind the Scenes: How I Create Weekly Technical Videos

    (Data with Bert)

    Watch this week's video on YouTube Today I want to share my process for blogging and making weekly YouTube videos.

  35. Multiple Identity Inserts

    (Data with Bert)

    Watch this week's video on YouTube This week I want to share something that surprised me about using SQL Server's SET IDENTITY_INSERT statement.

  36. Trailing Spaces in SQL Server

    (Data with Bert)

    Watch this week's video on YouTube A long time ago I built an application that captured user input.

  37. Joker's Wild

    (Data with Bert)

    This past weekend I had a blast presenting Joker's Wild with Erin Stellato (blog\|twitter), Andy Mallon (blog\|twitter), and Drew Furgiuele (blog\|twitter).

  38. CHOOSE() in SQL Server

    (Data with Bert)

    Watch this week's video on YouTube While I know I don't utilize most of the features available in SQL Server, I like to think I'm at least aware that those features exist.

  39. 12 Ways To Rewrite SQL Queries for Better Performance

    (Data with Bert)

    Watch this week's video on YouTube Over the past several week's I've been exploring ways to rewrite queries to improve execution performance.

  40. Predicate Execution Order on Mixed Data Type Columns

    (Data with Bert)

    Watch this week's video on YouTube SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions.

  41. Animating a Magic 8 Ball in SQL Server Management Studio

    (Data with Bert)

    This post is a response to this month's T-SQL Tuesday #114 prompt by Matthew McGiffen.

  42. Temporary Staging Tables

    (Data with Bert)

    Watch this week's video on YouTube SQL Server Spool operators are a mixed bag.

  43. IN vs UNION ALL

    (Data with Bert)

    Watch this week's video on YouTube When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs: WHERE Col1 IN ('A','B','C') or WHERE Col1 = 'A' OR Col1 = 'B' OR Col1 = 'C' While SQL

  44. Correlated Subqueries vs Derived Tables

    (Data with Bert)

    Watch this week's video on YouTube Correlated subqueries provide an intuitive syntax for writing queries that return related data.

  45. Window Functions vs GROUP BYs

    (Data with Bert)

    Watch this week's video on YouTube There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...

  46. Data Type Precedence and Implicit Conversions

    (Data with Bert)

    Watch this week's video on YouTube SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.

  47. Testing with Temporary Stored Procedures

    (Data with Bert)

    Watch this week's video on YouTube A while back I learned that it's possible to create temporary stored procedures in SQL Server.

  48. Joining on NULLs

    (Data with Bert)

    Watch this week's video on YouTube It's important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect.

  49. 4 Reasons To Avoid VARCHAR(8000)

    (Data with Bert)

    Watch this week's video on YouTube When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000).

  50. Gaps and Islands Across Date Ranges

    (Data with Bert)

    Watch this week's video on YouTube In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the sequence is missing (gaps).