Azure Account and Spending Limits
If you’ve been working with Azure for a while you probably signed up before they had the ability to create...
2013-10-08
807 reads
Blog Posts
Benchmark SQL Server Wait Statistics
One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid)...
2013-10-08
1,968 reads
Data Warehouse Maturity Model
I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into...
2013-10-08
2,207 reads
Generating a unique identifier outside of SQL and persisting it…
I’ve been thinking about a question from a application developer regarding generating a unique identifier outside of SQL and persisting...
2013-10-08 (first published: 2013-10-03)
2,632 reads
New Job Checklist
I started a new job a month ago, but didn’t want to just figure things out as they came to...
2013-10-08
840 reads
Oh, The Free Stuff!
Ah, Shwag
I’ve been doing the whole conference thing for a while. Not as long as some but quite a while....
2013-10-08
887 reads
Oh, The Free Stuff!
Ah, Shwag I’ve been doing the whole conference thing for a while. Not as long as some but quite a while. Along the way I’ve collected quite a...
2013-10-08
6 reads
Setting the Default View on a SharePoint Library
There could be a number of reasons why you would want to change the default view on a SharePoint library....
2013-10-08
736 reads
T-SQL Tuesday #47 – SWAG
It’s T-SQL Tuesday time, the second Tuesday of the month when we all coordinate our blog posts on a particular...
2013-10-08
988 reads
TSQL Tuesday #47 - SWAG - Where Does He Get Those Wonderful Toys?
Where does he get all those wonderful toys? In the line made famous by Jack Nicholson’s Joker in the original...
2013-10-08
1,524 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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...
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