SQLSaturday #9 in Greenville, SC on Oct 11, 2008
Paul Waters and team from the SQL Server Innovators Guild have decided to host a SQLSaturday at ECPI Greenville, SC...
2008-08-18
464 reads
Blog Posts
Database administration culture
"Culture", according to Merriam-Webster Dictionary http://www.merriam-webster.com/dictionary/culture, has one definition as
"the set of shared attitudes, values, goals, and practices that characterizes an...
2008-08-16
1,830 reads
August Charlotte SQL Server User Group Meeting Announcement
The Charlotte SQL Server User Group meeting will be held online on August 20th at 12 Noon (EDT). They'll have...
2008-08-15
647 reads
TechEd Online
I'm glad I'm not this slow, or maybe it's timed for the SQL Server release, but my TechEd Online panel,...
2008-08-15
813 reads
[OFF-TOPIC] "Geek" Comics I Follow
Like a lot of folks my age (in their 30s), I grew up on comics, both comic strips in the...
2008-08-14
774 reads
How Long Is Your Receipt?
Part of running a businness is deciding when and where to spend your hard earned cash. It's interesting to look...
2008-08-14
526 reads
2008-08-13
1,093 reads
How do I .... grant access permissions for SSIS to users?
SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to...
2008-08-13
45,928 reads
Microsoft Events in August for Columbia, SC
The following events are for August 21, 2008, in downtown Columbia, SC.
Morning - Momentum: IT ExecsMorning - TechNet: Vista, PowerShell, Group PolicyAfternoon...
2008-08-13
2,399 reads
Mnemonic Phone Numbers & Cell Phones
Recently I needed to make a call and the only number I had was a mnemonic one. I get why...
2008-08-13
1,900 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