Invitation to T-SQL Tuesday #040: File and Filegroup Wisdom
Hello and welcome to the third T-SQL Tuesday of 2013!
Over three years ago, Adam Machanic (Twitter) dreamed up the idea...
2013-03-05
655 reads
Jen McCown
FileTable: SQL Server 2012's little gasp-maker
When was the last time you looked at a SQL Server new feature list and said, “Ohhh, WOW!”? Was it...
2013-03-02
1,817 reads
We’re Live on the PowerScripting Podcast! (Thursday night, 02-28)
Your MidnightDBAs
Unusually, Sean and I will be guests on someone else’s podcast this week! Tune in live to our PowerScripting...
2013-02-27
1,272 reads
23 Pieces of News and Fluffery (Feb 9-15)
I have a news segment on DBAs@Midnight (our live weekly webshow, tune in tonight at 11pm Central time), but there’s...
2013-02-15
744 reads
#CISPA’s Coming Back: Time to Pay Attention Again
Update: The President’s cybersecurity Executive Order was signed and released today (see the Wired article). “Although the order comes after...
2013-02-12
862 reads
Install .NET Framework using #Powershell (#TSQL2sday!)
One of the really great things about being married to an MCM is that I can steal recycle his blogs,...
2013-02-12
1,206 reads
Clustering Concepts for the Common Man
SQL Server clusters are widely used, and widely misunderstood, which makes people like our good friend (and clustering MVP) Allan...
2013-01-29
1,441 reads
Talking on Purpose
Last year I stepped into the intimidating (and slightly effervescent) waters of the consulting world, and found great success. This...
2013-01-10
775 reads
T-SQL: CASE Statement
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-11 (first published: 2012-12-03)
5,085 reads
Great Tools for Formatting T-SQL
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-10
1,205 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