One Database, One Server
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use...
2009-06-09
393 reads
Blog Posts
PASS Connector Editorial for June 3, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-09
334 reads
Speaking At Space Coast SQL Users Group On June 11
Just a quick note to mention that I'm speaking at the next Space Coast SQL Users Group on Thursday, June...
2009-06-09
418 reads
SQL Saturday Eval Results
I received my evaluation summary from Karla Remail for this weekend's SQL Saturday event. The results are as follows:
Expectations: 0...
2009-06-09
582 reads
Starting Conversations - Part 6
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker...
2009-06-09
334 reads
Transparent Data Encryption - Encrypting the Log
One of the interesting things about Transparent Data Encryption is that it tries to ensure that your data, whenever it...
2009-06-09
467 reads
Call for Speakers for SQLSaturday #16 in Miramar, FL on August 8, 2009
Scott Klein still needs a few more speakers for the first ever SQLSaturday in Miramar (basically Miami). So far Jeff...
2009-06-08
349 reads
Gathering in the Corner - SQLSaturday #14
I'm done with SQLSaturday #14, actually stuck in Pensacola for an extra night, but that's another story.
It was a great...
2009-06-08
593 reads
Handling Errors in PowerShell
Scripting tasks in PowerShell is a fairly easy way to automate tasks, but you have to know when you get...
2009-06-08
953 reads
It’s Beginning to Look A Lot Like Christmas……
We got something good in the mail last week!
Some quick observations:
The build quality is outstanding. Nothing cheap at all...
2009-06-08
579 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