SSIS - An Inside View Part 2
This article is part 2 of a 4 part series that explores the internals of SQL Server Integration Services. This article looks at SSIS Transformations and Execution Trees.
2009-02-18
3,157 reads
Additional Articles
Using DMVs to improve SQL index effectiveness
Dynamic management views measure the effectiveness of indexes and discover fragmented indexes that may slow down SQL Server.
2009-02-18
3,072 reads
Managing Files with SQL Server 2008's FILESTREAM Feature
SQL Server's new FILESTREAM feature simplifies the process of keeping file-based data, such as images, in sync with relational data.
2009-02-17
2,743 reads
New Features in SQL Server 2008 Management Studio – Part 1
This article shows the new features that are available in SQL Server 2008 Management Studio
2009-02-17
5,046 reads
Securing SQL with access control and login monitoring
SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.
2009-02-16
3,195 reads
SQL Server 2008 Installation Process
I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part tip series, we will review the installation process for SQL Server 2008, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
2009-02-16
3,753 reads
Intrinsic Member Properties: The HIERARCHY_UNIQUE_NAME Property
This month's installment of "MDX Essentials" examines the HIERARCHY_UNIQUE_NAME intrinsic member property. Join SSAS Architect Bill Pearson in an introduction of this intrinsic member property, which Bill complements with hands-on exercises and sample uses.
2009-02-13
1,582 reads
SSIS - An Inside View Part 1
This article is part 1 of a 4 part series that explores the internals of SQL Server Integration Services. This series will focus on the SSIS architecture, buffer management, types of transformation, the execution tree and parallel processing.
2009-02-13
3,960 reads
Introduction to Change Data Capture in SQL Server 2008
This article takes a look at the great new auditing features available in SQL Server 2008.
2009-02-12
2,578 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
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
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