Coming to reality near you - DBA in Space - Produced by Red Gate...
Space - the Final Frontier!
Do not adjust your monitor- this blog is NOT a joke - rubbing your eyes will not help!
Now,...
2011-10-12
928 reads
Blog Posts
Day three of Summit Keynote
Last year we set out some very high goals. 1 million technical training hours, 250k members in the community, and...
2011-10-12
975 reads
Error configuration in SSAS
In SSAS, there is an Error Configuration object that is central to the management of data integrity errors.
The following picture...
2011-10-12
2,435 reads
Event Driven SSIS with Synchronous Processing and Dynamic Subscriptions
I know the title of this post is a little cryptic and something that only a techie would like but...
2011-10-12
1,861 reads
From The Bloggers Table Day 1
COMMUNITY!
It is a packed house again this year. If you were here on Tuesday night and you were a first...
2011-10-12
937 reads
Liveblog for Day 1 Keynote at SQL PASS 2011
It is hard to live tweet or live blog when the Wi-Fi is not working reliably. The keynote starts out...
2011-10-12
616 reads
PASS Summit 2011 Day #1 Post #1
Hello again. The PASS Organization has once more allowed me to sit at the bloggers table for the key note....
2011-10-12
987 reads
PASS Summit 2011 Day 1 – Keynote Live Blog
Welcome to PASS Summit 2011 Day 1!! Be sure to get your very own copy of the hot-off-the-presses MVP Deep Dives...
2011-10-12
1,417 reads
Practicing for DR
One of the sayings that I’ve heard a few times from professional atheletics is this:
“Amateurs practice until they get it...
2011-10-12
810 reads
Reach for the Select *s
Do you have your head in the clouds?
Have you wanted to take flight?
Have you been called “Space Case”
If you are...
2011-10-12
724 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