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. Even for customers who don't have needs quite like this benchmark, such efforts can teach a lot about getting optimal performance.

Serverless Software

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones talks about the future of software development and how it might not require developers to know anything about servers.

T-SQL Restore Script Generator

by Paul Brewer

SQLServerCentral.com

Restore

A procedure that generates point in time restore database & log commands for your databases.

Securing SQL Server 2012 Integration Services Packages using Digital Certificates

by Additional Articles

Database Journal

SQL Server 2012

There are several different ways of restricting access to SSIS packages and confidential information they contain. However, preventing unauthorized users from running or viewing the content of your code is not the only security measure that you should take into consideration.

Building Better Software

by Steve Jones

SQLServerCentral.com

Editorial

Why is it so hard to build better software? Steve Jones looks at recent problem in iOS that seems silly.

Capturing Baselines on SQL Server: Where's My Space?

by Erin Stellato

SQLServerCentral.com

baselines

In this article, we'll tackle the topic of monitoring disk space usage. By tracking how much is in use and how much is still available, over time we'll have the data we need for better capacity planning, and can ensure that a database won't ever run out of disk space.

Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues

by Additional Articles

MSSQLTips.com

RESOURCE_SEMAPHORE

This tip describes memory pressure issues that can arise from the RESOURCE_SEMAPHORE Waittype and how to find which query or transaction is causing the memory pressure.

Encryption Not Restriction

by Steve Jones

SQLServerCentral.com

Editorial

Encryption keys for services in the cloud should be maintained by the customer, according to Steve Jones. It's actually a good idea for all of your data.

Free Webinar: Statistics in Oracle and SQL Server

by Press Release

Redgate

Oracle

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.

SQLServerCentral Runs sp_Blitz - Performance Part 1

by Steve Jones

SQLServerCentral.com

Performance Tuning

The third article that examines the output of the sp_Blitz script™ run against SQLServerCentral's database servers.

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

Serverless Software

T-SQL Restore Script Generator

Securing SQL Server 2012 Integration Services Packages using Digital Certificates

Building Better Software

Capturing Baselines on SQL Server: Where's My Space?

Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues

Encryption Not Restriction

Free Webinar: Statistics in Oracle and SQL Server

SQLServerCentral Runs sp_Blitz - Performance Part 1

Blogs

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

AgentDBA vs Critical SQL Server

Forums

Increment a number in a SQL Query based on a value

Follow Your Hunch

What Happens When You Ask a Local AI to Query Your Database?

Question of the Day

Detecting Characters