Brian Knight’s Texas Tornado Tour!
Its been fun and fulfilling getting neck deep into the Central Texas Capitol Area Users of SQL Server again after...
2009-08-02
498 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
Fusion-IO Update
I’ve done all the testing I can do for now. There were some unexpected developments that I will cover in...
2009-08-02
553 reads
Cannot generate SSPI context…
Out of all the problems you can have with SQL Server troubleshooting connectivity issues can be the most challenging. When you factor in the complexities of Active Directory and SQL Server’s interaction with it fixing SSPI errors can be down right baffling...
2009-07-23
4,833 reads
My Virtual Lab setup Hyper-V 2008 and Virtual Server 2005 R2
One of the things I’ve maintained over the years is a lab to do everything I need. From testing new...
2009-07-22
3,537 reads
Cannot generate SSPI context…
Out of all the problems you can have with SQL Server troubleshooting connectivity issues can be the most challenging. When...
2009-07-20
6,521 reads
The Price of Convenience is Non-Ownership and Loss of Privacy.
This is as far as I ever plan to stray from writing purely technical posts. It just strikes so close...
2009-07-19
702 reads
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install. One of the things I always says is the greatest thing about SQL Server is any idiot can install it. The other thing I also say is the worst thing about SQL Server is any idiot can install...
2009-07-01
4,332 reads
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install.
One of the things I always says is...
2009-06-22
3,359 reads
What I’ve Read and Recommend to Others – SQL Server 2008 Part 1
I read, a lot. I’ve been a prolific reader all my adult life. I use to split my reading between tech books and my regular relaxing reading but since I got into audio books several years ago I just pretty much read tech books now. Some times I’ll listen..
2009-06-22
2,905 reads
Three Years late, Was It Worth The Wait? Windows 7, Vista Promises Delivered.
Having been married to Microsoft for most of my professional career doesn’t mean I drink the Kool-Aid. I have had the distinct privilege to grow up in interesting times. I loved DOS. As a BBS operator DOS was the de facto OS for most BBSes that ran on..
2009-06-19
3,001 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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...
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