PASS Summit: Blogger Q&A with Board of Directors Executive Committee
On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors:...
2014-11-07
782 reads
Blog Posts
Reblog: October 31 to November 6
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-11-07
1,057 reads
Remove Witness from SQL Server Database Mirroring
1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2)...
2014-11-07 (first published: 2014-10-27)
7,406 reads
SQL PASS Summit 2014 Diary – Days 3-5
The last two days have been an absolute blur. As I first posted this week, I had planned to blog...
2014-11-07
812 reads
Summit 2014 – Next Impressions
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has...
2014-11-07
624 reads
Summit 2014 – Next Impressions
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has been good so far. It has been very busy...
2014-11-07
2 reads
Thoughts on the 2014 PASS Summit From A Non-Attendee
I missed the Summit this year, but tried to follow along remotely via Twitter, PASSTV, and the blog posts I...
2014-11-07
935 reads
Versioning In Your SQL Database
Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...
2014-11-07
638 reads
Another great reason to enable remote admin connections
I recently came cross another great reason to enable the remote admin connections server configuration on SQL server.
If you don’t...
2014-11-06
1,180 reads
Configuring a Complete Memory Dump
Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform...
2014-11-06
1,934 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