A Script A Day - Day 26 - RESTART a Database Restore
Today’s script is another one based on database restores. There is a little known clause of the RESTORE DATABASE command...
2012-02-29
2,856 reads
Chris McGowan
A Script A Day - Day 27 - Missing Database Backups
Today’s script is one I have used many times in the past to check for missing backups. The script will...
2012-02-29
3,481 reads
A Script A Day - Day 24 - Object Qualification
Today’s script is one I use as an example to explain that there is method behind my standards that some...
2012-02-28
1,505 reads
A Script A Day - Day 21 - The HAVING Clause
Today’s post is about the HAVING clause which specifies a search condition for a group or an aggregate. HAVING is...
2012-02-27
548 reads
A Script A Day - Day 22 - Database Backup
Today’s script follows on from Day 16’s script which was about database restores. In a backwards way the script is...
2012-02-27
610 reads
A Script A Day - Day 23 - Find an Object In Job Steps
Today’s script is one which saves me a lot of time on occasion. On large systems with lets say more...
2012-02-27
771 reads
A Script A Day - Day 19 - Remove Virtual Subscriptions
Today’s script is to help replication performance. It was something I learned from my resident replication expert Paul Anderton. Below...
2012-02-25
3,501 reads
A Script A Day - Day 20 - User Database VLF Count
Today’s script will execute DBCC LOGINFO for all user databases. This is a script I use to monitor the number...
2012-02-25
2,638 reads
A Script A Day - Day 17 - Possible Poor Indexes
Today’s script is one I’ve taken from a job I use to collect possible poor indexes. I’ve tweeked it slightly...
2012-02-23
545 reads
A Script A Day - Day 18 - Viewing System Configuration
Today’s script is something I’ve learned today, it’s cool learning new stuff! When viewing server configurations in the past I’ve...
2012-02-23
557 reads
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Removing TDE
Comments posted to this topic are about the item Removing TDE
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers