Article of the Week – Kimberly L. Tripp (Partitioned Tables and Indexes)
When partitioning was first introduced in SQL Server 2005, I thought what a great idea. However, when I started reading...
2009-11-16
2,667 reads
Blog Posts
Blowing Off Steam and Recharging
I’ve written a few things about why conferences and events are good, or why it’s valuable for an IT worker...
2009-11-16
715 reads
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
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,443 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
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers