Interviewing for the PASS Board of Directors
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule...
2010-07-28
797 reads
Blog Posts
MDX Puzzle #4
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
551 reads
PASS 2010 Summit on LinkedIn Event Calendar – Have You RSVP’d?
Happened to notice in my weekly LinkedIn update today that Todd McDermid had signed up for the 2010 Summit event...
2010-07-28
789 reads
PASS Update #38 (SQLSaturday Wiki)
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as...
2010-07-28
639 reads
Sharing Remote Desktop Sessions
I work for a very large company where divisions are spread out literally all over the world. There are many...
2010-07-28
896 reads
SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai
Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...
2010-07-28
31,939 reads
SQL University – Disk Capacity Planning
This week at SQL University we are talking about capacity planning. I am the guest lecturer for this topic, and...
2010-07-28
5,040 reads
The Right Level of “Right”
…or, How I Learned to Stop Worrying and Love the Bomb
I had a SQL dev’s dream come to me via...
2010-07-28
904 reads
Webcast Today – Using XML to Query Execution Plans
I’ll be speaking for the SQL PASSDatabase Administration Virtual Chapter today at 12 PM Eastern time. The topic will be...
2010-07-28
587 reads
[OT] Where Ya Been?
Have you heard the sound of silence? Yep, that’s been my blog.
It’s been weeks since I’ve posted anything on here,...
2010-07-27
682 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers