Star Trek and the Death of IT
GAAAAAAAHHHHH!!!!
I feel slightly better, but only slightly.
I started watching Star Trek: The Next Generation on Netflix just to unwind my...
2013-03-18
1,127 reads
Blog Posts
T-SQL Tuesday #40 Roundup: Files and Filegroups
Good day all, and happy T-SQL Tuesday #40! Yes, this event has officially hit middle age now. I fully expect...
2013-03-18
849 reads
Using Templates
Templates are one of those really handy tools that most DBAs I know of have either never heard of or...
2013-03-18
1,162 reads
PASS Data Arch VC presents Steve Hughes on Accounting for Windows Azure
I meet Steve this past November in Seattle at the PASS Summit. Reading his series on XMLA and Analysis Services...
2013-03-17
636 reads
PowerShell Usage in DBA Work — Case Study 4/7
One common surprise I have encountered in almost all my DBA environments is that a sql job that usually runs...
2013-03-17
929 reads
SQL Server : Part 5 : Explaining Non clustered Index on Heap
In the last post, we have discussed about non clustered index on a clustered table.In this post we will discuss...
2013-03-17
7,812 reads
Database Health and Performance at SQLSaturday Detroit
Today I had the pleasure of speaking at the inaugural SQL Saturday event in Detroit, MI. I spoke on one of my...
2013-03-16
610 reads
Scaling SQL Server 2012 in Lisbon, Portugal
I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon,...
2013-03-16
729 reads
Exploring Excel 2013 for BI Tip #3: Flash Fill
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-15
1,170 reads
Mastering Reporting Services Expressions, March 26
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using...
2013-03-15
794 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