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
Blog Posts
Speaking at the Boulder SQL Server Users Group – November
I’m scheduled to give “The Encryption Primer” at the Boulder SQL Server Users Group on the November 13 meeting. It’s...
2012-11-06
931 reads
SQL, Sandy, Backup & Recovery - Have a Restore Plan
Reporting
from NY, East Coast, USA: In the wake of
hurricane Sandy, or as re-classified, post-tropical cyclone Sandy (whatever
that is), we slowly...
2012-11-06
1,607 reads
T-SQL Tuesday #36 - SQL Community (Guest Post)
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2012-11-06
638 reads
Windows 2012 Week
Over the past few weeks I have been doing some work with Windows Server 2012 and learned a few little...
2012-11-06
589 reads
Come Back From vacations…..
Hey Friends
I missed you so much in my vacations.
I come back from my leaves & hope now we have regular interactions.
2012-11-05
541 reads
Countdown to PASS Summit 2012 – 1 to Go – See You There
IT’S MONDAY! You ready to enjoy the fun and to learn a bunch? I know I am. Besides my schedule...
2012-11-05
673 reads
Last Weeks Top 10 “Reading” Links #5
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-05
610 reads
Looping through multiple servers in SSIS
This is just a quickie post to answer a question on how to loop through multiple servers in SSIS. There...
2012-11-05 (first published: 2012-10-31)
5,043 reads
Marking Up Books
I like reading and while I read more on an e-reader than I used to, I still prefer the printed...
2012-11-05
839 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
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...
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?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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