Scary Reading List for Halloween
I know I focus on community, SQL Server, professional development and process. But you need to do other stuff occasionally...
2012-10-26
730 reads
Blog Posts
SQL Server 2012 SSAS .. 'Yes we can' use one instance for both the tabular and multi dimensional models
As most of us are aware, each instance of SSAS 2012 may be run in either tabular or multidimensional mode (and...
2012-10-26
3,743 reads
Understanding Server Hardware Course from Pluralsight
My first training course from Pluralsight, Understanding Server Hardware has just gone live. It is listed in the SQL Server...
2012-10-26
1,490 reads
Using Invoke-WebRequest
The website PowershellCommunity.org is moving to a new site poweshell.org and I wasn’t sure the old forum posts will be...
2012-10-26
3,206 reads
Using Word 2013 to Create Blog Entries
Over the past few years, I have used Windows Live Writer to create my blog entries on WordPress. Given the...
2012-10-26
2,780 reads
Your online security is only as good as the weakest link
Over the weekend I received an email supposedly from Microsoft Live wanting me to verify my account and provided a...
2012-10-26 (first published: 2012-10-24)
1,661 reads
DBA Question of the Day
When I used to work in an office I had a stack of flash cards and occasionally I'd grab a...
2012-10-25
820 reads
Denali –Memory : Memory Error Recovery in SQL Server 2012
Continue on What’s new in Denali and Memory enhancement, come across another great article by SQLCAT and Glenn Berry a...
2012-10-25
868 reads
PASS 2012 Countdown – 2 Weeks To Go
I’m not sure how we got to 2-weeks until this year’s PASS Summit. If you haven’t registered yet it’s really...
2012-10-25
792 reads
PASS DBA Virtual Chapter Deck and Demo's Live
Hello Dear Reader, I wanted to say a quick Thank You to the PASS DBA Virtual Chapter for having me...
2012-10-25
543 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