Change the Report Manager logo
A common question I've been asked a lot lately is how to replace the icon in the Report Manager to...
2009-11-22
14,732 reads
Blog Posts
Fundamentals of Storage Systems – Capturing IO Patterns
We often take the advice given to us on forums or in articles at face value. Even though the authors...
2009-11-20
4,235 reads
Get 25% Off SQL Server E-Learning from Microsoft
Not all DBAs have the opportunity to attend formal classroom training or attend conferences. While there are many SQL Server...
2009-11-20
936 reads
How to Create a Reporting Services 2005/2008 Template
At most large companies one business requirement is that all reports have the same look and feel. This may vary...
2009-11-20
12,570 reads
I’m Missing Data
One of the things that I thought about doing after the 2008 PASS Summit was to bring someone along with...
2009-11-20
705 reads
MDX, DMX, and XMLA Templates
One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....
2009-11-20
3,128 reads
PASS Summit 2009 Final Thoughts…or What I've Learned From The 2009 Summit
Last week I wrote a day by day recount of my PASS Summit experience (Monday, Tuesday, Wednesday, Thursday, Friday). Since...
2009-11-20
714 reads
Should DBAs have local administrator rights?
This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...
2009-11-20
14,009 reads
SQL Job Ownership Article on SSC.Com
Today, Please see my featured article appearing on SQLServerCentral.com discussing SQL Agent Job Ownership.
Have you ever had a situation...
2009-11-19
628 reads
Book Review: The Cleaner
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
499 reads
Blogs
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...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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