SQL Saturday Syracuse 2024 Recap
First Things First Thanks to every who came to my session, Asnwering the Auditor’s Call with Automation. Slides and scripts are posted to my Github.
The Event! This was Syracuse’s...
2024-09-08
38 reads
Blog Posts
A New Word: Incidental Contact High
incidental contact high – n. an innocuous touch by someone just doing their job – a barber, yoga instructor, or friendly waitress – that you find more meaningful than...
2024-09-06
35 reads
Creating a Test Pipeline in Azure DevOps using a Windows Agent
A customer was having some trouble getting started with Azure DevOps (AzDO) and building their database, so we took a step back and decided to create a simple test...
2024-09-06 (first published: 2024-08-21)
555 reads
Database CI/CD Basics (T-SQL Tuesday #177)
This month’s invitation is from Mala Mahadevan (b) asking us how we manage the database code. Since this is my passion project, I have a few basic tips to...
2024-09-06 (first published: 2024-08-13)
444 reads
Take the 2025 State of Database Landscape Survey
The survey is out now and you can share your experiences for a chance at $250 in Amazon vouchers. No matter whether you think your org is great or...
2024-09-06 (first published: 2024-09-05)
55 reads
Blockchain + RWAs
Blockchain technology is still at the hype stage for an emerging technology cycle, it gets a bad image from all the dodgy web3 “crypto” fake projects out there (based...
2024-09-05
29 reads
Developer Q&A: John Kostak of Web Dev USA
"We can really be dangerous if we want, without being too afraid of it."
2024-09-05
53 reads
How Learning SQL Basics Transformed My Productivity
As a data analyst, my switch from Excel to SQL was revolutionary. This article reveals how an online SQL basics course dramatically improved my workflow. I've always depended on...
2024-09-04
194 reads
Microsoft Fabric reference architecture
Microsoft Fabric uses a data lakehouse architecture, which means it does not use a relational data warehouse (with its relational engine and relational storage) and instead uses only a...
2024-09-04 (first published: 2024-08-12)
523 reads
SQL Saturday Boston 2024 Plans
I was accepted to speak at SQL Saturday Boston 2024, which is taking place on October 5, 2024. One month away. This is a fun event that takes place...
2024-09-04
26 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers