Fighting the Flu
Last Monday was my first day back from the PASS Summit, planned for (and was) a slow day, just starting...
2009-11-16
497 reads
Blog Posts
Today’s SQL Lunch – Integrating Table Valued Parameters with Reporting Services 2008
Meeting URL: Join Meeting
Click the above Meeting URL around 11:30 AM CST on 11/16/2009 to join the meeting
Date: 11/16/2009
Time: 11:30...
2009-11-16
1,268 reads
Why does change control for SQL Server have to be so hard?
I’ve been dealing with change control and source code repositories for most of my professional career. While I’ve seen change...
2009-11-16
1,442 reads
Hot Sauce Links
New friend David Easley shared two sources for hot sauce that I wasn’t familiar with:
http://www.datilsensation.com/products.shtmlhttp://www.pepperpalace.com/I like some spice here and...
2009-11-15
528 reads
Marketing Mistakes and Poor Customer Service can Hurt Your Business
Yesterday, I was able to cause a potential customer to buy a competing product. In fact, according to my tally...
2009-11-15
398 reads
Using Dedicated NICs to Segregate SQL Server 2008 Backup Traffic
If you need to initialize a mirrored database for SQL Server 2008 Database Mirroring, one of the first things you...
2009-11-14
1,437 reads
Indentifying Performance Bottlenecks presentation
Thanks to everyone who attended the State of Tennessee’s .NET User Group meeting yesterday. I really enjoyed spending time with...
2009-11-13
830 reads
Looking Back – PASS Summit 2009 Day 5
Since this was my time visiting Seattle I opted to stay an extra day and take in the sights and...
2009-11-13
592 reads
Microsoft Release end dates:
I realize that we all should know when the support of Microsoft sql server will expire. we should have this...
2009-11-13
692 reads
PASS Summit 2009 - Media
There were tons of people taking pictures and video during the PASS Summit. I found a number of pictures on...
2009-11-13
1,369 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