Database Dropped
What do you do when a developer comes to you and asks, "Where did the database go? The database was there one minute, and the next it was...
2016-09-09
4 reads
Jason Brimhall
Finding the Right Path
I have a fairly large backlog of articles that are in progress or that are planned for my series about...
2016-09-05 (first published: 2016-08-24)
1,474 reads
Default Sessions – Back to Basics
With the evolution of SQL Server, there is an evolution in Extended Events. New features in SQL Server also means there may be some additional default sessions.
Related Posts:
Changing Default...
2016-09-01
10 reads
Events By Feature
Within the world of SQL Server there are a few things one can be certain of - things will change. This is true of the features in SQL Server....
2016-08-30
3 reads
Events By Feature
Within the world of SQL Server there are a few things one can be certain of – things will change. This...
2016-08-30
810 reads
Finding the Right Path
What is this gaping hole in the coverage of Extended Events? To be honest, it is not a very complicated topic or very difficult gap to fill. It's just...
2016-08-24
5 reads
T-SQL Tuesday #081: Recap
August 2016 TSQL Tuesday Recap
Related Posts:
T-SQL Tuesday 109: Influence Somebody Invite December 4, 2018
Passion, Challenges, and SQL February 12, 2019
T-SQL Tuesday #102: Giving Back May 8, 2018...
2016-08-18
4 reads
T-SQL Tuesday #081: Recap
Sharpen Something
In case you missed it (many did), TSQL Tuesday was a challenging event this month. I invited people to...
2016-08-18
427 reads
T-SQL Tuesday #081: Getting Sharper
Sharpen Something
This month I am the host of the TSQL Tuesday blog party. In the invite, which can be read...
2016-08-16
363 reads
T-SQL Tuesday #081: Getting Sharper
Getting sharper at JSON through a little experimentation.
Related Posts:
Passion, Challenges, and SQL February 12, 2019
T-SQL Tuesday #097: Learning Plans December 18, 2017
T-SQL Tuesday 109: Influence Somebody Invite...
2016-08-16
4 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