Finding Key Lookups In Cached Execution Plans
Ask anyone with performance tuning experience to list the most expensive operations in an execution plan and it's a safe...
2010-07-29
5,326 reads
Kendal Van Dyke
SQLRally Logo Contest - Fame & Fortune Up For Grabs!
Now that the PASS SQLRally (formerly known as the spring event) has a name it's time to start building a...
2010-07-22
678 reads
Getting Started In Blogging And Technical Speaking - At The 2010 PASS Summit
In case you missed it the Program Session (60 min. long) selections are now available on the 2010 PASS Summit...
2010-07-21
504 reads
Introducing The PASS SQLRally
If you're a PASS member you may have noticed in this morning's Community Connector that the 2011 spring event I...
2010-07-14
541 reads
In The Spotlight!
I received an unexpected but certainly not unwelcome email last night letting me know that I've been selected to present...
2010-06-23
413 reads
PASS 2011 Spring Event In Orlando
In March of this year the PASS Board of Directors began kicking around the idea of holding some kind of...
2010-06-21
879 reads
Presenting At OPASS June 15
On Tuesday, June 15, I'm presenting Paging DR Availability, You're Wanted in the Recovery Room at the Orlando SQL Server...
2010-06-10
415 reads
PASS Summit 2010 Abstract Submissions
I submitted three abstracts for the 2010 PASS Summit this year - two "normal" (75 minute) and one spotlight (90 minute)...
2010-06-08
476 reads
"Troubleshooting Transaction Replication" Published In SQL Server Magazine
I've been published! My article Troubleshooting Transactional Replicationis featured in the June 2010 issue of SQL Server Magazine (subscription required...
2010-05-28
1,922 reads
STS-132 NASA Tweetup or "I've Won A Golden Ticket!"
Note: This is a very non-SQL Server related post. If you don't want to read something personal about me feel...
2010-05-11
852 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
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...
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