PASS Connector Editorial for April 8, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-13
290 reads
Blog Posts
PASS Update #9
Time has flown by since my last update, busy time at work and struggling to get that done and find...
2009-04-13
391 reads
SQL Server 2005/8 Database Compression Presentation in Burlington, Vermont - April 15th
Yesterday, I drove the Smart down to Burlington/Colchester, Vermont to meet up with MVP Roman Rehak and speak to the local...
2009-04-13
1,081 reads
SQL Server 2008 Encryption
I'm embarking on another book project. Not writing this time, but tech editing again. I tech edited a book last...
2009-04-13
622 reads
SSD, The Game Changer
I’ve often described SQL Server to people new to databases as a data pump.
Just like a water pump, you...
2009-04-13
1,230 reads
PASS Connector Editorial For March 25, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-12
304 reads
What's my (fully qualified domain) name?
What's my name?
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring...
2009-04-11
9,427 reads
You thought SQL Server ate up memory…
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially....
2009-04-11
1,418 reads
No Opening Day
For the second year in a row I didn’t purchase opening day Rockies tickets. I had a nice streak of...
2009-04-10
795 reads
Activity Monitor in SQL Server 2008: an Embedded Optimisation Gizmo for the Thrifty DBA
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,777 reads
Blogs
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
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) ...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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...
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