Stairway to SQL Server Virtualization – Level 1
I’m proud to announce that yesterday the first installment of my new Stairway series at SQL Server Central has been...
2014-08-07
1,029 reads
Blog Posts
The clustered index columns are in all of the non clustered indexes.
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes...
2014-08-07 (first published: 2014-07-30)
9,430 reads
Apply Now for the PASS Board of Directors
One of the better graphics I’ve seen in a Connector that shows the timeline:
My thoughts:
Should You Run for the...
2014-08-06
742 reads
How to Edit Read-Only Non-clustered Columnstore Data
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,113 reads
Linchpin by Seth Godin
I am not sure how many books by Seth Godin I do own, I guess that it is somewhere around...
2014-08-06
213 reads
SchemaBinding – What & Why
What
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables...
2014-08-06
1,123 reads
So What the Heck is Power BI?
The other day a secondary family member said “we’re still on Microsoft 2010”. Another said “My friend is using Windows...
2014-08-06
546 reads
Batch Mode – part 1 (“The Beginning”)
This is the very first blog post in a new series on the Batch Mode, welcome & enjoy!
I will be going...
2014-08-05
147 reads
Building The SQLSaturday Marketing Plan-Part 31
No viewed on LinkedIn yesterday. Increased the bid to $5 and now seeing views. Not sure it correlates, but probably....
2014-08-05
745 reads
Live 360 Discount Code & Helping Digby!
Join me at SQL Live 360 this November!
I am hugely excited to have been selected to present at Live 360,...
2014-08-05
873 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