Authors Needed for the SQL Server Standard (PASS) & Almost Engraved Invitations
SQL Server Standard editor Grant Fritchey needs more content! We’ve got about three done and three more in the pipeline,...
2009-12-02
952 reads
Blog Posts
Dr. DeWitt’s Key Note at the PASS Summit
If you missed this, here’s your chance to make it up. If you were there, and like me, you need...
2009-12-02
714 reads
Explain it to yourself
I found a nice post from a friend, Roy Ernest, on an effective way to learn. He notes that one...
2009-12-02
673 reads
Featured Blogger: Tim Mitchell
I met Tim about a year and a half ago at SQLSaturday Jacksonville and from the start we hit it...
2009-12-02
271 reads
Fundamentals of Storage Systems – Testing IO Systems
12/03/2009 - UPDATE! There were a couple of bugs in the SQLIOCommandGenerator new SQLIOTools.zip has been updated.
------------------------------------
I often tell people one...
2009-12-02
1,577 reads
I think I’ll back up my laptop
Those were the first words out of my wife’s mouth when I told her my laptop had died. She walked...
2009-12-02
843 reads
PowerShell V2 Remoting
To use remoting you'll need to install Powershell V2, unless you're running Windows 2008 R2 or Windows 7, you'll need...
2009-12-02
1,199 reads
SQL Standard Update
Andy Warren in the latest PASS Connector has posted an update on where we’re at with the SQL Server Standard....
2009-12-02
648 reads
Under Repair
I’m glad I called Toshiba last night. When my laptop died on Sunday, and never came back Monday, I wasn’t...
2009-12-02
341 reads
What It Means To Be A Production DBA
Remember that scene from Office Space where the Bobs ask, "What would you say you do here?" I've been a...
2009-12-02
538 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers