In this presentation, Ira shows you how to data profile in SSIS using a Script transform and some creative methods like RegEx. He shows you how to look for patterns in your data to find bad data that wouldn't be obvious to the eye or casual viewer.
2007-01-18
1,543 reads
In this article author Paul Mu shows us how you can create a custom component for the new SQL Server 2005 Integration Services environment.
2007-01-17
17,609 reads
Part 40 of this series reviews a Web Service Control Flow task that exposes an infinite range of easily deployable features by leveraging capabilities present in the .NET Framework.
2007-01-17
2,598 reads
This article describes how to implement a single refactoring within your database. It contains a worked example of the Move Column structural refactoring, whereby we move the Customer.Balance column to the Account table, a seemingly straightforward change to improve the database design.
2007-01-16
3,244 reads
Learn how to keep track of previous versions of code in case your next upgrade doesn't go well from SQL Server guru Tim Chapman.
2007-01-15
2,928 reads
Learn how to calculate days of the week based on the current date and how to calculate accounting months.
2007-01-12
3,468 reads
In this presentation, Brian Knight shows you how to use canned SSIS components to detect data changes in a source table and only load new or conditionally update changed records. He shows you two methods: one using the OLE DB command and another using a set based operation and demostrates you the performance differences between the two.
2007-01-12
2,108 reads
In this presentation Brian shows you some of the new features in SQL Server 2005 SP2. Then, he demos briefly how to install SP2 and some of the small quirks around the installation.
2007-01-11
2,926 reads
New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.
2007-01-11
5,731 reads
We published a very interesting article about data warehousing in the SQL Server Standard awhile back. However the article was abridged and the author, a very respected data warehousing professional asked that we publish the entire thing here. So we bring you Harsh Bhaiya's very popular ETL treatise.
2007-01-10
13,359 reads
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Telp/WA.0821°3111°179 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6, RT.2/RW.2, Wil, Kec. Duren...
BCA KCP Menara Imperium Telpon/wa:0813.7887.595.Jl. H. R. Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi,...
BCA KCP Cilandak KKO I Telpon/wa:0813.7887.595.Jl. Raya Cilandak KKO No.9, Ragunan, Ps. Minggu, Kota...
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers