PASS Update #67
It’s been a slow few weeks since my last update. This week I did a call with Karla and Wes...
2011-12-01
431 reads
Blog Posts
PASS Update #67 (Election)
Today the slate of candidates for the 2012-2013 term was announced;
Adam Jorgensen, Denise McInerney, Geoff Hiten, Kendal Van Dyke,...
2011-12-01
640 reads
Speaking in Colorado Springs
I’m probably going to have to put together a new SQL video, because I’ve been accepted to speak at SQL...
2011-12-01
555 reads
SQL Saturday 99 – Digineer Interview
Welcome to the second of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-01
773 reads
SQL Server 2012 – Bug in sys.fn_xe_file_target_read_file?
So I finally managed to get my hands on a VM with Windows 2008 R2 SP1 so I could install...
2011-12-01
1,138 reads
SQL Table variable and temporary table
Table variables and Temporary tables are used interchangeably – but they were designed for different purposes.
Temporary tables were designed for storage...
2011-12-01
1,757 reads
The Blocked Process Report
A few days ago, one of my customers asked if there is a possibility to get a notification
from SQL Server...
2011-12-01
5,590 reads
Using NOLOCK hint
Use NOLOCK hint to avoid block - this is what I have often heard/see in many forums I participate, during local...
2011-12-01
613 reads
Buffer Size in SSIS
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in...
2011-11-30
16,621 reads
Convince me to read books (WHERE LEN(argument)
While you wait for my awesome upcoming blog on data exception notification with SSRS, let’s pursue a whim of mine.
I...
2011-11-30
1,672 reads
Blogs
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...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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