SSIS 101: Isolating Data in a Data Flow
MVP and SSIS expert Andy Leonard brings us a new article on how to work with a data flow and manipulate your data in complex ways.
2009-02-11
10,661 reads
Articles
Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
2009-02-11
669 reads
Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
2009-02-11
623 reads
Global Warming and Business Intelligence
What does global warming have to do with BI? Steve Jones explains.
2009-02-11
623 reads
SQL Server Integration Services Features And Properties Part 4
This article is the final article of a 4 part series that explores the Features and Properties of SSIS. This article will explore Validation.
2009-02-11
2,663 reads
Temporal Data Techniques in SQL
Joe discusses various factors to take into account when using temporal data such as Holidays, and discusses a few techniques using Calendar, Report Usage and History tables
2009-02-11
3,885 reads
Ways To Build Your Brand
This is in the presentation I've given a few times, but I thought it made some sense to put these things out here as well. I see there are a few major ways for you to build your brand and raise your profile in the modern world that is highly interconnected...
2009-02-11
811 reads
Automate Default Constraints
One procedure that will take care of all default constraint values in the destination.
2009-02-10
4,439 reads
Data Mining in Excel 2007 Pt.1 - SQL School Video
Excel has greatly helped ease the process of data mining. In this video MVP Brian Knight shows how you can start using the data mining add-ins for Excel to get started.
2009-02-10
5,218 reads
Creating packages in code - OLE-DB Source to Flat File File Destination
This code sample programmatically creates a package with an OLE-DB Source and a Flat File Destination, and the resulting package exports data from SQL Server to a CSV file. The finished package just has the one Data Flow Task shown below.
2009-02-10
2,537 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