Speaking Twice This Week
This week I will have the opportunity to speak at two different events. The first is on Monday, April 12th,...
2010-04-11
447 reads
SQLDownSouth
SSRS - Formatting Mutiple Columns
Often when designing reports you are required to apply the same formatting to multiple columns in one table or matrix....
2010-03-19
1,574 reads
Minimizing Fragmentation when Moving data using a Switch
Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...
2010-03-17
814 reads
Using a CTE with a T-SQL Pivot Statement
During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a...
2010-03-09
9,603 reads
Speaking at Charlotte, NC - SQL Saturday #33
If you are near Charlotte, NC, I will be speaking at their SQL Saturday on March 6th, 2010. My session, SQL Server...
2010-03-01
499 reads
SSRS – KPIs without Analysis Services
During a recent project I was asked if it was possible to simulate Key Performance Indicator (KPI) images in SQL...
2010-03-01
2,398 reads
Upcoming SQL Lunch Webinars
If you haven’t attended a SQLLunch, I suggest that you put this upcoming lunch on your schedule. Brad McGehee, SQL...
2010-02-24
1,022 reads
SQL Server 2008 - Adding Row Totals
During a recent client engagement I was asked if there was a quick way to add a row containing totals...
2010-02-22
735 reads
Free SQL Server Webinar Series
Are you new to SQL Server?Do you want to learn about its many features and capabilities? If so, please join...
2010-02-20
775 reads
Reporting Services Switch Function
Recently a client requested to create a Reporting Services expression that emulated the CASE WHEN statement from T-SQL. The expression...
2010-02-19
4,281 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
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