SSMSDeploy Now Available!
I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet,...
2011-01-19
604 reads
SSMSDeploy Demo #2 - new features
I've made some changes to the addin, adding some new features:
Comments: You can now add a comment to your request....
2011-01-15
608 reads
SSMSDeploy will be available, with source, for donation
After much um-ing and ah-ing I have decided to release my addin, with source code, under the GNU GPL.
I've also...
2011-01-15
570 reads
SSMS Addin Wrapper - Source Code and Usage
Code First, KTHX!
Here, as promised, is the source code for the SSMS wrapper.
Introduction
My apologies for the brief delay on this....
2011-01-10
2,377 reads
Updated SSMSDeploy Demo Video
This is just a quick note before I head off for work that I have made a new demo video...
2011-01-10
637 reads
SSMSDeploy - Demo Video Available!
Updates
1) I have discovered that there was already a tool called SQL Deploy, so I have renamed my addin to...
2011-01-09
584 reads
SSMS addin (and wrapper)
So I mentioned I'd been working on an SSMS addin. What I didn't mention was that I've also been working...
2011-01-04
1,411 reads
Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas
Introduction
A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....
2011-01-01
1,330 reads
Interlude: SSMS tips
Introduction
I know I said I was going to add more information about the CDC system in this post, but I...
2010-12-23
1,366 reads
Relational Types.
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...
2010-12-23
1,083 reads
Blogs
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Forums
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers