Using Custom File Delimiters in SSIS
File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field...
2016-02-16 (first published: 2016-02-05)
2,690 reads
Blog Posts
Where did january go?
I have been pretty busy over january and the first half of feburary and haven’t had time to write any...
2016-02-16
44 reads
Where did january go?
I have been pretty busy over january and the first half of feburary and haven't had time to write any...
2016-02-16
475 reads
Where did january go?
I have been pretty busy over january and the first half of feburary and haven't had time to write any blogs, I did have an article on simple talk...
2016-02-16
4 reads
Where did january go?
I have been pretty busy over january and the first half of feburary and haven’t had time to write any...
2016-02-16
52 reads
Copying SSIS packages With DTUTIL
A frequent need when performing a server migration is to copy the SSIS packages from one server to a new...
2016-02-15 (first published: 2016-02-05)
6,426 reads
Did you know?
Did you know that the call for speakers for PASS Summit 2016 opened on February 3, 2016?
Did you know that...
2016-02-15
433 reads
Importing Open Data Sets in SQL Server
Whilst working on an upcoming post I realised that I needed a decent data set on which to test some...
2016-02-15
711 reads
Loading Data into Azure SQL Data Warehouse
Ouch.
Let’s start with the level set. I’m not an ETL expert. In fact, I haven’t done any professional ETL work...
2016-02-15
1,538 reads
Monday Morning SQL Break – February 15, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-02-15
397 reads
Blogs
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...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
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