Additional Articles

We Loaded 1 Terabyte in 30 Minutes with SSIS, and So Can You

by Additional Articles

TechNet Blogs

Integration Services (SSIS)

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios.

2009-06-01

7,208 reads

Analyzing SQL Agent Job and Job Step History in SQL Server

by Additional Articles

MSSQLTips.com

SQL Agent

You may have a number of jobs scheduled and often there is the need to analyze the data to see which jobs are taking a long time or which job steps are taking a long time. As you add more jobs and overhead to the server these times become even more critical and analyzing the data is key.

2009-05-29

3,827 reads

Reducing Database Size by Using Vardecimal Storage Format

by Additional Articles

TechNet Blogs

Vardecimal

Learn about the new storage format for storing decimal and numeric data in SQL Server 2005 SP2. Details include when and how to enable vardecimal storage format, restrictions, space savings, and its impact on the performance of your workload.

2009-05-29

2,475 reads

Automate collection and saving of failed logins for SQL Server

by Additional Articles

MSSQLTips.com

Security

I re-cycle my SQL Server log every night using sp_cycle_errorlog. However, before I do, I would like to capture all of the failed logins recorded. I have auditing turned on for failed logins, but I want to make sure that I capture those events into a table so I can report on. How can I do this?

2009-05-28

3,095 reads

SQL Server 2008 Developer Training Kit

by Additional Articles

Microsoft MSDN

Programming

The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.

2009-05-28

5,566 reads

Discuss

Using The Data Profiler Task and FTP Task in SQL Server 2008 Integration Services

by Additional Articles

SQL Server Performance

Integration Services (SSIS)

See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.

2009-05-28

2,252 reads

Data Access Tracing in SQL Server 2008

by Additional Articles

TechNet Blogs

trace

Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine.

2009-05-27

2,017 reads

Trace File Source Adapter

by Additional Articles

sqlis.com

Integration Services (SSIS)

The Trace File Source adapter is a useful addition to your SSIS toolbox. It allows you to read 2005 and 2008 profiler traces stored as .trc files and read them into the Data Flow. From there you can perform filtering and analysis using the power of SSIS

2009-05-27

2,229 reads

Retaining historical index usage statistics for SQL Server

by Additional Articles

MSSQLTips.com

statistics (data)

In this three-part series I'll look at what you can do to persist this data so you don't find yourself waiting for usage stats to compile over a reasonable period of time just so you can harness the power of the indexing DMOs in your performance tuning process.

2009-05-26

1,438 reads

Searching for tasks with code – Executables and Event Handlers

by Additional Articles

sqlis.com

Integration Services (SSIS)

Searching packages or just enumerating through all tasks is not quite as straightforward as it may first appear, mainly because of the way you can nest tasks within other containers. You can see this illustrated in the sample package below where I have used several sequence containers and loops.

2009-05-26

1,144 reads

All authors

Additional Articles

We Loaded 1 Terabyte in 30 Minutes with SSIS, and So Can You

Analyzing SQL Agent Job and Job Step History in SQL Server

Reducing Database Size by Using Vardecimal Storage Format

Automate collection and saving of failed logins for SQL Server

SQL Server 2008 Developer Training Kit

Using The Data Profiler Task and FTP Task in SQL Server 2008 Integration Services

Data Access Tracing in SQL Server 2008

Trace File Source Adapter

Retaining historical index usage statistics for SQL Server

Searching for tasks with code – Executables and Event Handlers

Blogs

“We love to debate minutiae”

Advice I Like: Knots

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

Forums

Windows logins for users migrated from DomainA to DomainB

Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Question of the Day

Upgrading Admin Queries