Using an audit table to rollback changes to data might be a nice addition to many applications. David McKinney's new series looks at how you can use this data for RollBack or RollForward.
In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.
For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance.
As I've mentioned in earlier posts (Part 1, Part 2, Part 3) I've engaged speaking and networking Don Gabor to help me build my skills. I recently had my second coaching session and wanted to share more of what I've learned so far.
How can you measure someone's DBA skills? Steve Jones comments on a new technique that someone suggested to him.
How can you measure someone's DBA skills? Steve Jones comments on a new technique that someone suggested to him.
How can you measure someone's DBA skills? Steve Jones comments on a new technique that someone suggested to him.
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
i have huge table with lot of data and is also wide. i took...
Comments posted to this topic are about the item Creating a JSON Document II
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
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