Now on Twitter
A few colleagues of mine, Andy Leonard, Jason Massie, and Chuck Boyce, are all on Twitter. As a matter of fact,...
2008-05-30
1,525 reads
Blog Posts
Security Issue with SQL Server Reporting Services 2008
I have a CTP of SSRS 2008 deployed to one of my servers. Today I built a couple of reports...
2008-05-30
2,540 reads
Trainer training
I have been thinking about getting the MCT credential for about five years. During the MVP Summit I attended a...
2008-05-30
1,305 reads
Link: Avoiding Burnout
Ran across this article about burnout and thought it worth posting. Burnout is not fun to experience and heading it...
2008-05-29
1,427 reads
Using IN with possible NULL values
There is a little quirk with NULLs when using the NOT IN qualifier. I use the term "quirk" loosely here...
2008-05-29
1,588 reads
Good Links on Speaking
Brian Kelley posted Giving a Presentation about a week ago and is worth reading, in particular his suggestion about Toastmasters...
2008-05-28
1,464 reads
Kindle Part 2
Or maybe part 3, depending.
Amazon reduced the cost of the Kindle yesterday. It's $40 off, a 10% discount, down...
2008-05-28
1,688 reads
Pictures from Midlands PASS Chapter Meeting
Last night the Midlands PASS Chapter had the pleasure of hosting SQL Server MVP Brian Knight. I was able to...
2008-05-28
1,550 reads
Backups of Backups
After being gone for 4 days, I've got a little catching up to do. I try to be prepared before...
2008-05-27
1,499 reads
Speaking at PASS Summit 2008
Received news today that one of my submitted sessions - Should You Move Into Management - was accepted for the summit. Good...
2008-05-27
1,346 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