Return the Value of a Specified Dataset Row Outside a Data Region
I want to return the field value for a specific row to a textbox below a table in
my report. To...
2010-03-16
428 reads
Blog Posts
SQL Saturday #33 Recap
SQL Saturday #33 was held on Saturday, 3/6, at the Microsoft campus in Charlotte. Hosted by the Charlotte SQL Server...
2010-03-16
1,060 reads
SQL Saturday is a’comin!
Just a quick reminder that registration is still open for SQL Saturday #35 in Dallas. This event will be held...
2010-03-16
552 reads
SQL Server 2008 SP1 CU7 is Released
Microsoft has released SQL Server 2008 SP1 Cumulative Update 7 (CU7). It is Build 2766. There are 31 fixes listed,...
2010-03-16
1,529 reads
Start Planning to Attend devLINK 2010
devLink 2010 will be held in Nashville, TN August 5-7 on Lipscomb University. This three day, 140+ session event costs...
2010-03-16
501 reads
Tracking data about your instances
I saw a post recently asking how to build a daily report for each instance that tracks the metrics deemed...
2010-03-16
725 reads
User is prompted to login when viewing a report
A user has been added to a SSRS role for the report folder or report but is still
prompted to login....
2010-03-16
1,907 reads
Denver SQL Server User’s Group Meeting on March 18
The Denver SQL Server User’s Group will be having their March meeting on Thursday, March 18. Bulent Gucuk will discuss...
2010-03-15
761 reads
How to Consolidate & Virtualize SQL Server 2008
Many companies face the decisions to 1) consolidate their SQL Servers, due to sql sprawl; and 2) whether to virtualize their SQL...
2010-03-15
1,089 reads
North Texas SQL Server User Group – March 2010
Join us this Thursday, March 18th for our monthly NTSSUG meeting. SQL Server MVP Sean McCown will be continuing his...
2010-03-15
588 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