PASS First Timers Guide and Schedule – 2012 edition
Hi there ho there everybody! It’s less than five (FIVE!) three (THREE!)one (ONE!!) week until the 2012 PASS Summit in Seattle,...
2012-10-03
1,217 reads
Blog Posts
ReFS || next generation file system for Windows
Q) Why is it named ReFS?
ReFS stands for Resilient File System. Although it is designed to be better in many...
2012-10-03
601 reads
SQL Saturday #149 Minneapolis 2012
This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member...
2012-10-03
821 reads
Where have all the Orphans gone?
Do your database users appear to be having an out of body experience? Have they lost all ties to their...
2012-10-03
1,075 reads
Where have all the Orphans gone?
Do your database users appear to be having an out of body experience? Have they lost all ties to their login? Does it feel like maybe what this baby...
2012-10-03
4 reads
Why do you attend sessions? – Survey Results
Several weeks ago I posted a quick survey on my blog that asked how you choose a session to attend...
2012-10-03
964 reads
Honored with MVP award!
I’m so honored to be recognized as an MVP for SQL Server by Microsoft!
Thank you Microsoft and the SQL Server Community.
My...
2012-10-02
1,333 reads
Master Data Services: Copy Versions
In Master Data Services (MDS), you can use the Master Data Manager Web User Interface “UI” to copy a version of...
2012-10-02
1,136 reads
One Great Day And Mixed Feelings
If it happens two times then you know the first time wasn’t a fluke.
Today was my anniversary date for the SQL Server...
2012-10-02
1,012 reads
PASS 2012 Countdown – 5 Weeks To Go
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you...
2012-10-02
719 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