One very interesting new feature in SQL Server 2005 is the ability to run backups to multiple locations, ensuring you have a second copy of the backup file if your first one were to be corrupted. SQL Server expert Andy Warren takes a look at how this feature works and the implications of using it.
SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.
A short review of the WROX red covered book that looks at Integration Services for the DBA.
SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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