Experiments with Data Compression in SQL Server 2008
Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use...
2010-02-22
2,113 reads
Blog Posts
Free Webinar Series This Week
If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners. ...
2010-02-22
627 reads
I Feel Like a Heel
It’s now 3 events that I’ve canceled in the last 6 months, and a 4 or 5 more that I’ve...
2010-02-22
879 reads
IgnoreUnrelatedDimensions in Analysis Services 2008
Once of the more common issues with working with data in a cube is that it does not always line...
2010-02-22
459 reads
Introduction to Using Profiler with SSAS 2008
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
606 reads
It will happen on a spring day in May...
"The world's favorite season is the spring. All things seem possible in May." - Edwin Way Teale This spring, the Portland,...
2010-02-22
463 reads
Power Plans and Windows Server 2008 R2
After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL...
2010-02-22
3,443 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
What Does It Look Like When Everything Is Okay?
I'm a big believer in looking at systems when everything is okay. I'm not the only one, as Joe Richards, a...
2010-02-22
874 reads
What’s up with the reads?
So the other day I read Andrew Kelly’s article, Do You Have Hidden Cache Problems, in the latest electronic edition...
2010-02-22
371 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