-
AI, Crazy Quoted Identifiers, and comparing column names between tables
Read more: AI, Crazy Quoted Identifiers, and comparing column names between tablesAs I was working on another problem the other day, I had the need to compare two tables that had been created and modified by AI. I created fairly insane column names to test to see what the AI would do with a table that had columns with spaces, brackets, smart quotes, etc. in them.…
-
Feedly Friday – Feeds I Read #12
Read more: Feedly Friday – Feeds I Read #12Feeds I Read Page | Other Feedly Friday Posts Welcome to my continuing series of posts where I am going to highlight one or two feeds I follow in Feedly. Technology feeds only, though I keep up with other things like theme park news in there too. Feedly is an RSS reader that you can use…
-
T-SQL Tuesday #192 – SQL Server 2025 Excitement
Read more: T-SQL Tuesday #192 – SQL Server 2025 ExcitementThank you to Steve Jones for repeat hosting T-SQL Tuesday this month again! This month we are talking about SQL Serve 2025, which I think we all expect to hit the shelves next week. Every new version of SQL Server, once I get access to the bits, I go to the What’s New page and…
-
Throwing Stuff at the Wall
Read more: Throwing Stuff at the WallOf late, if you are following my endeavors, you may have noticed that I am trying to pump out the content as fast as I can. This new website, 2 or 3 blogs a week, a podcast (and a writing vlog that I will start kicking out episodes very soon), and hopefully next year I…
-
25 Years
Read more: 25 YearsToday I celebrate 25 years with CBN. 25 years. Sometimes I have to let that sink in. I only know a few people who have had that kind of longevity with any company, well, other than a decently large number of my company-mates, who have been here considerably longer than I have, that is. In…
-
SQL Strategies for Comparing Sets of Data
Read more: SQL Strategies for Comparing Sets of DataThere are many occasions when we want to see the differences between two sets of data. Sometimes a whole table, a subset of a table, or even the results from a couple of queries, like in a unit test. Maybe you want to see that two sets are exactly the same, for example domain table…
-
Louis’s Scary Adventure: Podcasting the Challenges of Technology
Read more: Louis’s Scary Adventure: Podcasting the Challenges of TechnologyI have been working on a project the past few months, trying out the idea of having a podcast again about technology. Part of me is terrified, but I had wanted to do a podcast like this for a while now. Just me (for now), my microphone and camera, talking to myself. I picked this…
-
Temporary Stored Procedures: Outputting Status in Scripts
Read more: Temporary Stored Procedures: Outputting Status in ScriptsOn another connection (on another computer for that matter), I am right no doing some pretty long loads of some test data. The script is comprised of 6 queries, and they each may take 10 minutes (not completely sure, this is my first run of the scripts). And of course, I want to get some…
Hello,
I’m Louis
I have been at this database thing for a long long time, with no plans to stop.
This is my blog site, companion to drsql.org
Drsql.link 