TSQL Challenge 33 - Calculate list of bookings fully paid on the book
This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.
Operator of the Week - Lazy Spool
Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator on his list: the Lazy Spool. What does the Lazy Spool do that's so special, how does the Query Optimizer use it, and why is it so Lazy? Fabiano Amorim explains all.
The Phantom DBA
This week Steve Jones has a poll about the difficulties in getting the DBA position into companies. What's your current opinion of this profession?
SSAS: Explaining the State Transitions Viewer for Sequence Clustering
In SQL Server 2005 and SQL Server 2008, Microsoft has added some fantastic visualizations around data-mining algorithms. These visual aids allow us to see exactly what a particular algorithm is predicting or describing—making a difficult subject easier to understand.
Concurrent processing in SSIS – Part 2
The second part of a series that looks at two additional techniques for processing data in parallel in Integration Services.
Dinosaur Databases
Do you work on a database system that's a dinosaur? A recent article called out RDBMSse as dinosaurs, but Steve Jones doesn't think that's correct.
I’m a SQL Server DBA, and I’m in Love with PowerShell
To learn PowerShell, Laerte Junior suggests that you just start using it. To encourage you to start, he provides a series of tips on using PowerShell with SQL Server to solve various everyday problems. With a little patience, a good IDE, and a bit of help and advice, "the lion is dead".
Late June 2010 PASS VC Presentations
PASS BI and DBA Virtual Chapters have free training available on Wednesday June 23rd.
Using the UPTIME Utility to Monitor Servers
Learn how to use a free utility to quickly monitor the uptime of your SQL Server instances.
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
AI Database Central
Comments posted to this topic are about the item AI Database Central
The Grafana Alternative to SSRS and Power BI
Comments posted to this topic are about the item The Grafana Alternative to SSRS...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers