Articles

In the previous tips (SQL Server Integration Services (SSIS) - Best Practices - Part 1 and Part 2) of this series I briefly talked about SSIS and a few of the best practices to consider when designing SSIS packages. Continuing on the same rhythm I am going to discuss some more best practices for SSIS package design, how you can design high performing packages with parallelism, troubleshooting performance problems etc.

2009-11-30

3,785 reads

TSQL Challenge 18 - Generate text formatted month calendars

by Press Release

T-SQL Challenges

T-SQL Challenges

Can you generate a calendar with T-SQL? Take this month's challenge.

2009-11-30

3,924 reads

Converting a File with Parent-Child Records in SSIS

by Jeff Singleton

SQLServerCentral.com

Integration Services (SSIS)

Convert a file with multiple record types that have a parent child relationship.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(15)

You rated this post out of 5. Change rating

2009-11-27

5,839 reads

Discuss

Deploying Reports on Windows 7

by Patrick LeBlanc

SQLServerCentral.com

Blogs

Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-11-27

2,033 reads

Fundamentals of Storage Systems – Capturing IO Patterns

by Wesley Brown

SQLServerCentral.com

Blogs

We often take the advice given to us on forums or in articles at face value. Even though the authors...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-11-27

3,278 reads

How to simulate transparent data encryption (TDE) with SQL 2000 and 2005

by Additional Articles

MSSQLTips.com

Transparent Data Encryption (TDE)

Encryption of data at rest is becoming more and more crucial in today’s world. This tip is aimed to help businesses that do not have the budgets or resources to purchase hardware encryption tools or to upgrade to SQL 2008. It basically illustrates how to achive transparent file encryption with SQL 2005 or SQL 2000.

2009-11-27

4,390 reads

Increase Your Value as a Professional in the Technical Industry

by Additional Articles

SimpleTalk

Career Growth

It has never been so important to enhance your employability as it is today. Job security can never be taken for granted. Employability, increasing your professional value, means far more than just collecting qualifications, as Dr Masha Petrova explains: It also involves communicating, writing, and participating in communities.

2009-11-27

2,850 reads

The DBA Boat

by Steve Jones

SQLServerCentral.com

Editorial - WMV

For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.