PASS Data Community Summit 2024 Day 3 Keynote
It’s been an amazing week here, as well as a long week. I’m tired, as are many others. The blogging table is a little bare this am, but I...
2024-11-20 (first published: 2024-11-08)
153 reads
Blog Posts
Thoughts on AI Data Infrastructure Field Day #1
On October 2nd and 3rd, I took part in an amazing event called AI Data Infrastructure Field Day as a delegate. If you’ve never heard of this event before,...
2024-11-20 (first published: 2024-11-11)
209 reads
AI Innovation in Microsoft Keynote
I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day 1 of the PASS Data Community Summit. Data is the driving force behind innovation, powering...
2024-11-18 (first published: 2024-11-06)
172 reads
Day 2 at PASS Data Community Summit 2024
I missed blogging yesterday as I was on stage/backstage for quite a bit of the keynote. Live updates, so keep refreshing. Today I’m blogging and noting the interesting things...
2024-11-18 (first published: 2024-11-07)
163 reads
Webcast Tomorrow on SQL Server Disaster Recovery
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL Server Disaster Recovery. It'll cover all the typical methods built-in to SQL Server, with a...
2024-11-18
17 reads
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if I need it somewhere in the future 🙂 Sometimes you need a numbers table (also...
2024-11-16 (first published: 2024-11-15)
352 reads
Spark Connect Dotnet November 2024 Where are we?
All Spark Connect Posts
Introduction There have been quite a few changes in the last couple of months and I just wanted to give a quick update on the current...
2024-11-16
77 reads
A New Word: Ochisia
ochisia – n. the fear that the role you once occupied in someone’s life could be refilled without a second thought, which makes you wish that every breakup would...
2024-11-15
17 reads
Counting Groups with Window Functions: #SQLNewBlogger
I looked at row_number() in a previous post. Now I want to build on that and do some counting of rows with COUNT() and the OVER clause. I’ll show...
2024-11-15 (first published: 2024-10-30)
467 reads
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC. The topic is about window functions, something that really interests me and that should...
2024-11-15 (first published: 2024-10-31)
372 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers