T-SQL Tuesday #89 – The O/S It is A-Changing
It's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...
2017-04-11
586 reads
Nebraska SQL from @DBA_ANDY
Who Left Those Old Components in My New Database???
Recently a client requested some new transactional replication publications on a relatively new pre-production server. The client has plenty of...
2017-04-13 (first published: 2017-04-07)
2,306 reads
Querying SQL and Windows Version Info with T-SQL
Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself. There are...
2017-04-10 (first published: 2017-03-24)
31,613 reads
Embrace The Missing Index DMVs - But Proceed with Caution!
One of the performance tools I use all of the time is the set of Missing Index DMVs: · sys.dm_db_missing_index_details– Detailed...
2017-03-22 (first published: 2017-03-09)
4,076 reads
How many Backups is Too Many?
Does this title seem strange? Of course we know this is the true answer:
https://cdn.meme.am/cache/instances/folder633/58097633.jpg
But here is a story of a...
2017-03-02 (first published: 2017-02-24)
2,675 reads
YouTubing Down the SQL Server River
I recently stumbled on a YouTube channel from one of my favorite SQLPeople - she is sharp (and an MCM) and...
2017-02-10
598 reads
#SQLSpeaking this Fall!
I have some great speaking dates coming up this Fall - here is the list:
--
First - the big one. I am honored...
2016-09-15
421 reads
Thank You SQL Saturday Sioux Falls!
I just finished giving my SQL Saturday presentation on "Getting Started with Extended Events" at SQLSaturday Sioux Falls. The audience...
2016-07-23
452 reads
Finding File Growths with Extended Events
I give a SQLSaturday session called "Introduction to Extended Events" and at a recent presentation I had a pair of...
2016-06-17 (first published: 2016-06-13)
6,369 reads
How Do I Change My Domain Password on Windows Server 2012?
As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers...
2016-05-23
5,943 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