Symbols
I just want to write the setup I went through for using debug symbols within SQL Server to resolve call...
2016-04-20
228 reads
All About SQL
Community work
I have been really busy lately with articles, podcasts and so forth. Lately I have been working on 2 public...
2016-04-16
148 reads
SQL Bite-Size Podcasts are live!
Well, after many late nights I have finally produced a set of podcasts – Bite size style – therefore called SQL Bite...
2016-03-27
278 reads
SQL Server Podcasts
Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help...
2016-03-23
391 reads
SQL Server articles
Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...
2016-03-16
187 reads
An Extended Event script
I have been enjoying XE alot recently ( from following SQLSKILLS) so I decided to write something that I used recently...
2015-05-22
153 reads
Carving up CHECKDB
This is a technique that I am using from Paul Randal – concept of splitting CHECKDB: CHECKALLOC, CHECKCATALOG and CHECKTABLE – here...
2015-05-16
180 reads
Welcome to BlobEater
I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...
2015-03-25
309 reads
A Handy function
If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...
2015-03-03
171 reads
Timed SQL Server tracing
Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...
2015-02-07
248 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