Scripting SSIS Package Deployments
Before I delve into the subject of scripting SSIS package deployments, I’m going to take a slight detour and explain...
2012-11-06
6,770 reads
Chad Miller
Cloning SQL Servers to a Test Environment
I’ve been involved in a project to set up a full test environment of dozens of SQL Servers. The requirements...
2012-11-08 (first published: 2012-11-05)
4,257 reads
Using Invoke-WebRequest
The website PowershellCommunity.org is moving to a new site poweshell.org and I wasn’t sure the old forum posts will be...
2012-10-26
3,206 reads
Upcoming Fall Events
During September/October I’ll be presenting at several in-person events:
Tampa IT Pro Camp
Join system administrators and IT professionals for the Tampa...
2012-09-09
1,117 reads
South Florida IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing PowerShell Output session at South Florida IT Pro Camp 2012.
2012-07-22
1,109 reads
Jacksonville IT Pro Camp 2012 Presentation
Presentation and scripts from my Integrating SQL Server PBM with SCOM session at Jacksonville IT Pro Camp 2012.
2012-06-19
1,172 reads
Jacksonville IT Pro Camp
Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...
2012-06-03
1,233 reads
Appending New Rows Only
I saw a question in the forums related to inserting new rows into a SQL Server table only if they...
2012-04-27
5,531 reads
Backup Database Object
I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...
2012-04-17
1,818 reads
Table-Valued Parameter Example
I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case...
2012-04-13
3,563 reads
Blogs
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...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
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...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
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