TSQLScripts.com and IE 8
Wow, I just got an email from a registered member of www.tsqlscripts stating that it is not compatible with IE...
2009-09-02
584 reads
Blog Posts
Tulsa TechFest to be Held November 7, 2009
The next annual Tulsa TechFest will be held on Saturday, November 7, 2009, at the Tulsa Community College in Tulsa,...
2009-09-02
543 reads
Use the Best Tool for the Task
Last February I wrote an article for Simple-Talk called Let PowerShell do an Inventory of your Servers . This script was...
2009-09-02
358 reads
24 Hours of PASS Tonight
For those of you who may have missed it, the 24 Hours of PASS conference starts tonight at 8pm EDT!...
2009-09-01
426 reads
Building a Pipeline
While I try to write most days, I don’t always podcast, and I only schedule things a day or two...
2009-09-01
383 reads
Indexing HierarchyID
The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...
2009-09-01
3,739 reads
Keeping a Low Profile
I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly...
2009-09-01
557 reads
- Easiest Rebuild Ever - Windows 7
I'm somewhat conservative with my machines. These days it's a tool for me, and I'm not looking for the coolest...
2009-08-31
1,669 reads
Active August – Final Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-31
1,324 reads
Backing up to NUL vs Backup with Truncate only
Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...
2009-08-31
2,238 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