Schema as Folder
I'm catching up on my reading today and ran across an article from Kathi Kellenberger called Understanding the Difference between...
2007-10-13
604 reads
Blog Posts
Partitioning Part 2 Posted on SSC
I'm a couple days late updating the blog, the article went up on Mon.
2007-10-11
572 reads
Views, Temp Tables, Data Types - Aha!
I spent last week onsite with a client teaching performance tuning and it was really a good week. Great company...
2007-10-08
607 reads
The Contest
I hate contests. I mean it's nice to get people involved and I start out with the best of intentions...
2007-10-07
730 reads
My Book is Out!
How to Cheat at Securing SQL Server 2005
I recently had the opportunity to contribute a couple of chapters to this...
2007-10-04
547 reads
What's In a PodCast - Part 1
Well, lots of mistakes. Here's a good example of one: Friday Oct 5 mistake.
I decided to go the budget route...
2007-10-04
979 reads
Midlands PASS October Meeting
Taya Blanchard to speak on A
Practical Guide to Making Sense of Your SQL Server Application
Performance
Midlands PASS Chapter - October...
2007-10-03
576 reads
Estimates - Part 1
I saw a very interesting post about estimating software from Steve McConnell, of Code Complete fame. He compared his estimate...
2007-10-02
1,010 reads
Paperwork Day
Doing payments for articles, expenses, and a few articles. This is definitely a paperwork day. As much as I like...
2007-10-01
645 reads
Clustered Indexes
I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports...
2007-09-30
1,291 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