SQL Server Security Basics: Logins vs. Users
When I discuss SQL Server security, one of the basic concepts I concentrate on is the difference between logins and...
2009-04-21
22,733 reads
Blog Posts
SQLSaturday #14 in Pensacola Update
Karla just emailed that the schedule is set, details at http://www.sqlsaturday.com/schedule.aspx, but to save you time here are the speakers...
2009-04-21
622 reads
A Proper Response
That sounds like a very British title, so maybe the Red Gate folks are rubbing off on me. I had...
2009-04-20
581 reads
Four new SSIS Videos on JumpstartTV.com
I've got four new SSIS videos published on JumpstartTV.com:
Expression Language Basics
Secure FTP File Transfer in SSIS
SSIS Lookup Transformation Basics
SSIS...
2009-04-20
2,205 reads
Interviewed by Tom Larock
Tom has been doing a series of interviews on his blog lately and I ended up on the list. Interviewing...
2009-04-20
521 reads
Prius Update – Smells Like New
We got the Prius back yesterday. I dropped Kyle off and he drove it home. Today was my first time...
2009-04-20
523 reads
Revisiting the Task List
I've written a few posts in the past about time management, and thought I'd post an update with some lessons...
2009-04-20
590 reads
Security Basics - The C-I-A Triad
In the course of giving my security presentations over the past year, I've learned that quite a few folks have...
2009-04-20
9,095 reads
Simply Dumb Founded - A Non SQL Blog
Blogging is both more fun and harder than it looks, so when someone is getting started I try to offer...
2009-04-20
545 reads
The Death of Email Questions
One of my policies is not to answer questions from people about SQL Server in email. That includes emails to...
2009-04-20
1,058 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