T-SQL Tuesday 41 – Presenting and Loving it!
Before we dive in to the post, I’d like to give a big thank you to Bob Pusateri (Blog|Twitter) for...
2013-04-09
784 reads
Blog Posts
Unknown Unknowns: SSAS Version Number and Default Admins
With Service Packs and Cumulative Updates rapidly released for SQL, it can be hard to keep up with what version you have installed where. It’s easy enough to find...
2013-04-09
10 reads
Analysis Services Webinar Recording and Q&A
I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013. If...
2013-04-08 (first published: 2013-04-02)
2,226 reads
Chicago SQL Saturday (#SQLSat211) Is This Weekend
The Chicago SQL Saturday is coming up this weekend on Saturday, April 13th. If you are waiting until the last minute...
2013-04-08
520 reads
Disabling Resource Governor
I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the...
2013-04-08
1,097 reads
DMV-5 : Queries runing are adhoc or proc , single or multi use ?……..sys.dm_exec_cached_plans
sys.dm_exec_cached_plans DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/ms187404.aspx
Returns a row for each query plan that is cached...
2013-04-08
826 reads
How do I use a variable in an IN clause?
I see this question in one form or another a lot. I’ve seen this or something like it probably half...
2013-04-08
765 reads
How Much Power Does Your PC Use?
I can’t say I’ve ever worried too much about how much power my PC uses. I care about battery life...
2013-04-08
767 reads
Last Weeks Top “Reading” Links #27
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-08
479 reads
list of the service applications in SharePoint 2010
Hey Friends,
It’s been a long time , I was out of touch with my blogs. But thanks to all for checking...
2013-04-08
969 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