![Bert Wagner](/img/default-banner.jpg)
- 147
- 1 068 700
Bert Wagner
United States
Registrace 14. 10. 2011
I release a new SQL video every Tuesday, showing tips and tricks and helping you solve your SQL problems.
The code and additional blog content referenced in my videos can be found at: bertwagner.com/
The code and additional blog content referenced in my videos can be found at: bertwagner.com/
A simple, private, chat interface for ChatGPT: Talkie
Subscribe and turn on notifications to never miss a video: czcams.com/users/bertwagner
Check out the related blog post for more details:
bertwagner.com/talkie-a-chatgpt-clone
Talkie on GitHub:
github.com/bertwagner/talkie.dev
The Talkie app for your phone, browser, and everywhere:
talkie.dev
Follow me on X:
x.com/bertwagner
00:00 - Intro
00:25 - Why build another ChatGPT user interface?
03:00 - Development of Talkie
05:06 - Using Talkie demo
Check out the related blog post for more details:
bertwagner.com/talkie-a-chatgpt-clone
Talkie on GitHub:
github.com/bertwagner/talkie.dev
The Talkie app for your phone, browser, and everywhere:
talkie.dev
Follow me on X:
x.com/bertwagner
00:00 - Intro
00:25 - Why build another ChatGPT user interface?
03:00 - Development of Talkie
05:06 - Using Talkie demo
zhlédnutí: 195
Video
Keeping a dev/work journal in the CLI with jurn
zhlédnutí 1,2KPřed rokem
0:00 - Introduction 1:02 - Install and basic usage 2:05 - Categorizing messages with Tags 2:30 - TAB completion of Tags 4:30 - Subcategorization with Tags 5:00 - Displaying logs with the "print" command 6:10 - Using jurn to remind you to update your daily work 8:30 - Performance evaluations and conclusion Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWit...
curl and Multi Page Forms
zhlédnutí 1,8KPřed 2 lety
Subscribe and turn on notifications to never miss a video: czcams.com/users/DataWithBert Check out the related blog post for all code samples: bertwagner.com/posts/using-curl-to-automate-multipage-logins/ Follow me on Twitter: bertwagner
Recursively Querying Related Rows with SQL
zhlédnutí 13KPřed 3 lety
Check out the related blog post for all code samples: bertwagner.com/2020/08/25/recursively-querying-row-groups/ Another one of my videos about how recursive queries work: czcams.com/video/2ocXC4wZcn4/video.html Subscribe and turn on notifications to never miss a video: czcams.com/users/DataWithBert Follow me on Twitter: bertwagner
Should I put my transformation logic into my SQL query?
zhlédnutí 3,5KPřed 3 lety
Save time with PopSQL. Collaborate on queries with your team, visualize data, and share results. Visit popsql.com/bert for your free 2-week trial. Subscribe and turn on notifications to never miss a video: czcams.com/users/DataWithBert Related blog post: bertwagner.com/2020/07/29/should-i-transform-my-data-in-my-sql-query/ Follow me on Twitter: bertwagner
Moving 1/3 of a Heap
zhlédnutí 1,6KPřed 4 lety
Related blog post: bertwagner.com/2020/07/22/moving-1-3-of-a-heap/ Subscribe and turn on notifications to never miss a video: czcams.com/users/DataWithBert Follow me on Twitter: bertwagner
COMING SOON
zhlédnutí 694Před 4 lety
Related blog post: bertwagner.com/2020/07/16/coming-soon-new-content/ Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBert Follow me on Twitter: bertwagner
Network Graph Analysis with Python and NetworkX
zhlédnutí 9KPřed 4 lety
Today I run some graph analysis using Python, NetworkX, and the Twitter API to build a Twitter Follower Recommendation Engine. Subscribe and turn on notifications to never miss a video: czcams.com/users/DataWithBert Check out the related blog post for all code samples: bertwagner.com/2020/01/07/using-pythons-networkx-for-twitter-graph-analysis/ Follow me on Twitter: bertwagner
SQL Server Converts Numbers to Asterisks
zhlédnutí 2,2KPřed 4 lety
SQL Server handles most datatype conversions fairly well, but in this episode we discuss one type of conversion that leads to unexpected results. Subscribe and turn on notifications to never miss a video: czcams.com/users/DataWithBert Check out the related blog post for all code samples: bertwagner.com/2019/12/17/sql-server-converts-numbers-to-asterisks/ Follow me on Twitter: bertwa...
Azure SQL vs Azure Table Storage
zhlédnutí 11KPřed 4 lety
This episode I take a look at some of the differences between Azure SQL database and Azure Table Storage and explain with which option I chose for my web app. Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBert Check out the related blog post: bertwagner.com/2019/12/03/deciding-between-azure-sql-and-azure-table-storage/ Follow me on Twitter: twitter.c...
When UPDATE statements DELETE rows!
zhlédnutí 2,4KPřed 4 lety
I was shocked to discover that SQL Server was deleting certain rows when I ran an UPDATE statement...or at least that's what I *thought* was happening. Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBert Check out the related blog post for all code samples: bertwagner.com/2019/11/26/when-a-sql-update-statement-deletes-rows/ Follow me on Twitter: twitt...
Speaking at PASS Summit 2019
zhlédnutí 627Před 4 lety
This year was my first time speaking at the PASS Summit conference in Seattle. This video shares my thoughts as I was going through the process. Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBert Follow me on Twitter: bertwagner
SQL Server 2019 Feature Power Rankings
zhlédnutí 1,8KPřed 4 lety
With the release of SQL Server 2019 (most likely) right around the corner, I thought it'd be fun to share my most highly anticipated features coming in the new version. Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBert Check out the related blog post for the full run down: bertwagner.com/2019/10/29/sql-server-2019-feature-power-rankings/ Follow me o...
SQL Stored Procedures, Functions, and Views
zhlédnutí 42KPřed 4 lety
SQL Server offers many different options for storing and reusing your query logic. In this video we'll take a look at all of the options and whether or not you should use them. Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBert Check out the related blog post for all code samples: bertwagner.com/2019/10/22/sql-server-stored-procedures-vs-functions-vs...
Stored Procedure vs Adhoc Query Performance
zhlédnutí 10KPřed 4 lety
Will you get faster performance by putting your SQL queries in a stored procedure or executing them directly? In this week's video we look at the (mostly) straightforward answer. Subscribe and turn on notifications to never miss a weekly video: czcams.com/users/DataWithBert Check out the related blog post for all code samples: bertwagner.com/2019/10/15/are-stored-procedures-faster-than-stand-al...
How to Communicate Effectively at your Workplace
zhlédnutí 1,4KPřed 4 lety
How to Communicate Effectively at your Workplace
SQL Server's "Wrong" Math - Part 2 - Floating Point Errors
zhlédnutí 1,4KPřed 4 lety
SQL Server's "Wrong" Math - Part 2 - Floating Point Errors
Key Concepts - DBA Fundamentals Quick Tip
zhlédnutí 1,4KPřed 4 lety
Key Concepts - DBA Fundamentals Quick Tip
SARGability - DBA Fundamentals Quick Tip
zhlédnutí 2KPřed 4 lety
SARGability - DBA Fundamentals Quick Tip
STATISTICS IO, TIME - DBA Fundamentals Quick Tip
zhlédnutí 2,1KPřed 4 lety
STATISTICS IO, TIME - DBA Fundamentals Quick Tip
Tracking Who Changed Row Data in SQL Server
zhlédnutí 13KPřed 4 lety
Tracking Who Changed Row Data in SQL Server
Troubleshooting SQL Server Execution Plans
zhlédnutí 18KPřed 4 lety
Troubleshooting SQL Server Execution Plans
How To Read SQL Server Execution Plans
zhlédnutí 40KPřed 4 lety
How To Read SQL Server Execution Plans
SQL Server Execution Plans: Statistics - Part 2
zhlédnutí 30KPřed 4 lety
SQL Server Execution Plans: Statistics - Part 2
SELECT Expression Execution Order in SQL Server
zhlédnutí 2,6KPřed 5 lety
SELECT Expression Execution Order in SQL Server
Thanks! for explaining with practical examples
Too simplistic to use in real scenarios...
Very late to the game... Couldn't get the "animation" working at first. Had to go to Options Search for "Results to Text" Check "Scroll as results are recieved" Fiddle with the result pane size and it's working like a champ! Hope this helps someone.
great stuff
Found just stories in all videos. normally we watch video tutorials to understand practical stuff otherwise theory we can read from some web page(s).
talk slower, let people absorb what you are saying. Also explain how you ingested the co-ordinates polygons
There is not a single chance in the world to get rid off Nested loops, not even 0,0000001% chance buddy
Video này rất thú vị và hữu ích. Ý tưởng đề cập đến rất sáng tạo và giải thích rõ ràng. Nội dung được thể hiện rất tốt và gây ấn tượng mạnh. Tôi rất thích xem video này. 🌻🌹
hey Bert (or anyone else that knows :)) - at 6:50 you talk about viewing the cach plans by looking at the 'DMV' called dm exec etc etc. What is a DMV in this context? Just trying to understand what those commands are... where do they come from? What is this 'DMV' that you refer to?
Hi Bert, I didn't set up payment in the OpenAI settings but they still gave me an API key. Took me a minute to figure out why the Talkie wasn't working. Working now, thanks!
Thanks for giving it a try. I hope it helps you!
Thanks🎉
content that is worth its time :) credits for such valuable materials :) thx!!! btw why You have the Polish emblem (white eagle on red shield) on your laptop? :)
That's a very cool solution. Thanks!
Awesome video
Hiya Bert; I don’t have an alternative/better/likely worse solution to your problem (though I do love these kinds of things!), nor do I even know if you ever come back and read the comments (hopefully so, I’ve watched quite a lot of them and everyone seems mostly positive - which is about the best you can hope for with CZcams comments). I do just want to say THANK-YOU for taking the time to put these together; they’re VERY well done, concise, span and broad range of SQL topics, provide in-depth knowledge in an understandable fashion, and go far beyond the deluge of basic/beginner topics that so many channels seem to focus on. I’m a dev, and as you know it’s a lifelong commitment to learning about things that change every day and potentially won’t even be relevant in a decade or so (ᕕ( ᐛ )ᕗ), and part of that commitment is reading articles, SO, and watching CZcams videos to try and keep my knowledge current, refreshed, and hopefully ever-growing. Your videos are phenomenal for that: I can’t find the mental bandwidth after a long day to watch a slow, dry, hour long video on SQL that MAY make some interesting points. The cost/benefit analysis just doesn’t check out. Your videos, on the other hand, are spectacular! They’re fast-paced, you don’t pontificate ad infinitum, and (as mentioned) the content is phenomenal. So, Bert: I say thank-you! I’ve already begun recommended your channel to the coworkers that I like :)
Great video!
Very good examples. Thanks man.
your content and explanation is good but for further videos can you please remove background music, difficult focus on what you said
k j n
可能,你,那麼,那麼,那麼,那麼,你,嗎你們,你,m
I must say, I was kinda skeptical but this really helped me get a quick overview of Cardinality. Thank you!!!
I like the 3rd option, but hate it too and not just for maintenance. The idea of having to put that through peer review and production approval would be lovely to explain to others as well as documenting everything so people know why you have duplicate code.
cool introduction 👍
Temporal SQL and Complex Event Processing (CEP) serve different purposes and are not direct substitutes for each other. Temporal SQL, also known as "time-centric SQL," extends traditional SQL with features for handling temporal data, such as valid-time and transaction-time semantics. It allows querying data based on time intervals, historical snapshots, and temporal relationships. Temporal SQL is useful for scenarios where you need to track changes to data over time, analyze historical trends, or perform time-based queries. On the other hand, Complex Event Processing (CEP) is a technology used for analyzing and correlating streams of events in real-time to identify patterns, detect complex conditions, and trigger actions or alerts. CEP systems typically process high volumes of streaming data from various sources and apply rules or patterns to identify meaningful events or combinations of events. CEP is commonly used in applications such as fraud detection, monitoring IoT devices, and financial trading. While both Temporal SQL and CEP deal with time-related data, they address different aspects of data processing. Temporal SQL focuses on querying and managing temporal data stored in databases, while CEP focuses on real-time analysis and processing of streaming event data. In some cases, you may use both technologies together to handle different aspects of time-sensitive data processing in your applications. ChatGPT verified Used some versioning built in into databases
Have you seen a QBSQL query that requires W - with the bar over laid onto the W to replace a / symbol?
what is sound track plays?
ㅠㅠㅠ 너무 감사합니다 이 문제로 삽질을 얼마나 했는지 ㅠㅠ 정말 요즘 세상에 8000자로 짜른다니 이해가 안되네요
Perfect explanation
Mine doesn't do anything when I click it. Doesn't work for me.
The way this has to be done feels like all the things database classes tell you not to do :(
These videos are gold. Thank you for making them.
Thank you for the info, is it an issue if the execution plans are never reused? We have an EHR data base and the execution plans are showing 0 for reuse. Just wondering if that's normal.
this video is really helpful . I have a doubt. If I have defined clustered and non clustered index and we are inserting new row, it will add the newly added row in specific position and shift other rows as per clusterd index. So, how non clustered index is getting benefitted here on inserting new rows. And is that possible to have table without any clustered index.
Great video!
Pinal Dave is my hero.
Misleading at best
Thank you For Spatial DB we have lots of information on PostGIS very less for SQL This is highly informative for MS SQL DBA's
We can also use the keyword N'' before the string to specify the encoding unicode and it would be able to store more data
Am I the only one who noticed the Polish eagle sticker on his laptop? Where do I get one?
Thanks for this making tutorial. It's just what I needed.
Thanks Bert! Big Help 😁👍 You're a Cool Dude.
You're new I'm just starting this video... I'm gonna watch this..
Thank you that was so useful!
4:05 im confused why a insert would be so slow in this situation. Can clustered indexas not be sorted by some sort of tree?
I have been using jrnl for over two years now, and it has made my life really easy. I can have multiple journals, add metadata to my entries and do a search on that. I have managed to define my own metadata format and use some functionality of the system to quickly filter on that. But it is nice to see your app, as it is somehow similar, although a little less powerful, and also written in Python
Are you Austrian?
This is fascinating SQL code... what I was hoping to find was a way to generate a possible table definition by inspecting a subset of a list of data from the json response of an API. For example using python, C#, etc to output a definition and get the types right, even if precision, keys etc might need modified.
what camera u used to glow ur face
thank god you're no indian!
WOW! cool video! Thanks for the filtering info, and for the awesome views!