Shameless Self Promotion
NewsGator’s marketing department put up a nice post yesterday mentioning myself and Dan Larson, who are both Microsoft MVPs. I...
2009-08-27
675 reads
Blog Posts
SQL Profiler ...Error ...Click OK to terminate program
Hi to everyone! I decide to write it in my blog here about this problem because really don't have any...
2009-08-27
1,296 reads
SQL Saturday #21 – Session Submitted
I just submitted my session for SQL Saturday #21 in Sunny Orlando Florida. I have been working on a presentation...
2009-08-27
654 reads
SQLSaturday #21 Event Update
Thought I’d share some of the event for those you not in the Orlando area. As of today we have...
2009-08-27
518 reads
Top 5 reasons to run for the PASS Board of Directors
There have been quite a few posts in the SQL Server community recently announcing the Call for Nominations for the...
2009-08-27
474 reads
Upcoming Microsoft Gadgets
Microsoft has finally officially announced the long rumored price cuts for the XBox 360 Elite, which will go down from...
2009-08-27
645 reads
Access Denied, Not Possible
What’s going on here?
When trying to open Default Trace files on Windows 7 and SQL Server 2008 I got the...
2009-08-26
1,206 reads
Application and Multi-Server Management With SQL Server 2008 R2
Microsoft has published a good whitepaper that explains the new functionality in SQL Server 2008 R2 that will allow you...
2009-08-26
589 reads
Building a Better Blog - Next week during the 24 hours of PASS
I've got a new presentation on blogging slated for next week during the 24 hours of PASS. The event is...
2009-08-26
816 reads
Corruption in sys.dependencies
The second type of corruption I want to look at is that of missing references in sys.sql_dependencies. This typically appears...
2009-08-26
436 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