SQL Server 2008 Diagnostic Information Queries (Oct 2012)
Here is the October 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-10-19
1,703 reads
Blog Posts
This December–SQL Server Consolidation and Virtualization
This December (5th - 7th) I will be presenting SQL server Consolidation and Virtualization: Hands-On for Learning Tree in New York....
2012-10-19
929 reads
this is what I do when I install SQL. How about you?
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
875 reads
Awarded – Microsoft Community Contributor Award 2012
Today, I’ve received an email from Microsoft stating that I’ve been awarded Microsoft Community Contributor. This is the first time...
2012-10-18
1,684 reads
DBA Study Guide
http://www.flickr.com/photos/caledonia09/4999119065/
Hello Dear Reader, over here at Pragmatic Works we’ve been growing like weeds. For the most part we are looking...
2012-10-18
2,423 reads
Important Alerts for SQL Server
One of the things that I think is extremely important for DBAs and really anyone that has to administer a...
2012-10-18
2,422 reads
My Training Topics For Coming Months
Just few days gone since our last Chennai SQL Server User Group meet. This is the right time to choose...
2012-10-18
887 reads
On Source Control
A mention today from Jamie Thomson in his blog on source control. I left a comment, but it was long,...
2012-10-18
1,602 reads
Should a placement firm tell you what they are billing the client?
As a 1099 consultant, I usually use a placement firm to find a contract job. I always ask the placement...
2012-10-18
1,193 reads
SQL Audit – User-defined Audit Events
One thing I failed to touch on during my series on SQL Audit was the use of user-defined events in...
2012-10-18
3,227 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