Off to the PASS Data Community Summit 2024
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and flying to Seattle for the PASS Data Community Summit 2024. I’m very lucky that I...
2024-11-04
12 reads
Blog Posts
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business insights? Look no further than SQL! It's the perfect tool for creating powerful data pipelines...
2024-11-04 (first published: 2024-10-21)
682 reads
Why is fn_xe_file_target_read_file the worst SQL function?
I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but …
reading the extended event...
2024-11-04 (first published: 2024-10-18)
422 reads
2024 PASS Data Community Summit Prep
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling Monday to the event to see a few thousand fellow data professionals, developers, managers, and...
2024-11-01
26 reads
A New Word: Bye-over
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional farewell but then unexpectedly have a little extra time together, wordlessly agreeing to pretend that...
2024-11-01
104 reads
Migrate to Azure PostgreSQL Flexible Server
I need to migrate from a single server to a flex server. Instead of doing a dump and restore, I’m going to try out the migration service that Azure provides. Single...
2024-11-01 (first published: 2024-10-17)
220 reads
Should I Learn PostgreSQL
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email, ads, etc. My MCADAA exam started with an entire section on it. I’m trying to...
2024-11-01 (first published: 2024-10-18)
581 reads
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
SQL Server Audit is an efficient way to track and log events that occur within the database engine. For on-premises or IaaS environments, those audits can only be stored...
2024-10-30 (first published: 2024-10-15)
396 reads
T-SQL Tuesday #179 Roundup: The Data Detective Toolkit
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked, “What’s in your data detective toolkit?” We got some great responses which I’ll recap here,...
2024-10-30 (first published: 2024-10-21)
277 reads
Heading to 2024 PASS Summit
I am able to head back to Seattle for the PASS Summit this year. I would love to meet up with friends and colleagues. I shouldn’t be too hard...
2024-10-29
19 reads
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
Rethinking How We Approach Assignment Help
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers