Tattersall's gamble with password security

Bragging rights http://www.itwire.com/content/view/25873/1231/1/1/

Favourite SQL Server Integration Services Articles

Over the last few months I've been answering questions on the SSIS Forum as well as working on a data migration project here in Canberra.  During this time I've found a number of valuable articles (which have subsequently been added to my favourites collection for future reference) so I thought I'd share them with you.

Performance Tuning

Top 10 SQL Server Integration Services Best Practices

An article by SQLCAT discussing what they consider to be the 10 most important practices to consider when developing SSIS packages.  This article also discusses what tasks are best done in T-SQL instead of SSIS.

Getting Optimal Performance with Integration Services Lookups

An article that discusses several techniques for getting optimal performance from a Lookup transform in SSIS.

Troubleshooting Package Performance

Integration Services includes features and tools that you can use to troubleshoot the performance of packages. For example, logging captures run-time information about packages, and performance counters let you monitor the data flow engine. This article provides information about these features, along with suggestions for designing packages to avoid common performance issues in SSIS 2005

Improving the Performance of the Data Flow

This article provides suggestions about how to design Integration Services packages to avoid common performance issues and also provides information about features and tools that you can use to troubleshoot the performance of packages in SSIS 2008.

Integration Services: Performance Tuning Techniques

This white paper describes common performance-tuning techniques that you can apply to your SQL Server Integration Services (SSIS) 2005 data integration solutions.

Scheduling

How to Schedule and Run a SSIS package Job

To execute a SSIS package via a SQL Server Agent Job you need to configure a Proxy Account and assign it as the executor of the Job Step.  This article discusses how to do this.

Developing

Generating Surrogate Keys

SSIS does not contain a built in component for generating surrogate keys but there is still a mechanism for doing it – the Script Component. The Script Component allows us to modify the data in a data flow path using managed code and we can use it to generate surrogate keys.

Row Number Transformation

SSIS does not contain a built in component for generating surrogate keys but there is still a mechanism for doing it – The Row Number Transformation.  The Row Number Transformation calculates a row number for each row, and adds this as a new output column to the data flow. The column number is a sequential number, based on a seed value. Each row receives the next number in the sequence, based on the defined increment value.

Integration Services Data Types

Provides datatype mappings between SSIS, SQL Server, Jet, Oracle and DB2 for SSIS 2005 and SSIS 2008.

Administration and Setup

Configuring Integration Services in a Clustered Environment

The Integration Services service is not a clustered or cluster-aware service, and does not support failover from one cluster node to another. Therefore, in a clustered environment, Integration Services should be installed and started as a stand-alone service on each node in the cluster.  These articles discuss how to install and setup SSIS 2005 and SSIS 2008 in a clustered environment.

CSSUG: Answering the queries your users really want to ask

When: Tuesday, 10 February 2009 -

Where: Excom Education, Level 2, 33-35 Ainslie Place, Canberra City (Entrance Map)

Duration: Networking from 5:30PM for a 6:00PM Start

Registration: http://www.sqlserver.org.au/

Session Details

Developers like queries that are very constrained. Users don't. In this session, Greg will show how iFTS in SQL Server 2008 allows developers to build systems that answer the queries the users really want to ask. This session got great reviews when Greg delivered it at TechEd Developers in Barcelona recently.

If you haven't used FTS in earlier versions of SQL Server and are curious about what’s possible, have used it and have some old pain associated with it or are using it and want to see what's changed, this session is a must.

About Greg Low

Greg is an internationally recognised consultant, developer and trainer. He has been working in development since 1978 and holds a PhD in Computer Science. Greg is the country lead for Solid Quality (www.solidq.com.au), a SQL Server MVP and a Microsoft Regional Director. He is currently one of only two people in the world to hold the new Microsoft Masters certification for SQL Server 2008 and teaches internal SQL Server classes for Microsoft on their Redmond campus.

Canberra SQL Server User Group Home Page

Canberra SQL Server User Group Facebook Group

WARDY IT Solutions - December 2008 SQL Server Newsletter

The December 2008 edition of the WARDY IT Solutions SQL Server Newsletter has been released. In this issue we cover:

• SQL Server Healthcheck
• January SQL Server User Groups
• SQL Server 2005 Service Pack 3
• Red-Gate SQL Server E-Book
• Free SQL Server Breakfast
• SharePoint Training and Consulting
• Analysis Services Performance Whitepaper
• Tech Summerfest
• Troubleshooting with Extended Events
• Integration and Messaging Framework

To subscribe to the newsletter visit http://wardyit.com/Default.aspx or send an email to newsletter_add@wardyit.com

Cheers
Jeff

Australians Against Internet Censorship

All Australians are urged to participate in the Australians Against Internet Censorship movement.

Visit these sites quickly before they're added to the Australian Government's Blacklist :-)

March

http://wiki.efp.org.au/index.php?title=13th_December_2008

Website

http://www.nocleanfeed.com/

Blog

http://blog.nocleanfeed.com/

YouTude

http://au.youtube.com/watch?v=ZPBdWjIrUn4
http://au.youtube.com/watch?v=tH35CVig3fQ&feature=related

WARDY IT Solutions - July 2008 SQL Server Newsletter

The July 2008 edition of the WARDY IT Solutions SQL Server Newsletter has been released and can be viewed at http://www.wardyit.com/newsletters/jul2008.htm.

In this issue we cover:

• August WARDY IT Community Dinner
• August SQL Server User Groups
• Reporting Services Training Camouflage
• SQL Server 2008 Benchmarks
• Managing Unstructured Data
• Article Writing Opportunity
• SQL Down Under Code Camp
• T-SQL Programmability Features in SQL Server 2008
• SQL Server Virtual DBA

To subscribe to the newsletter send an email to newsletter_add@wardyit.com.

Cheers
Jeff

Microsoft SQL Server 2008 Virtual Labs

Test drive Microsoft SQL Server 2008 in a virtual labs.

• MSDN Virtual Lab: Using Table Valued Parameters in SQL Server 2008
• MSDN Virtual Lab: Using the new SQL Server 2008 Spatial Capabilities: GEOGRAPHY
• MSDN Express Virtual Lab: Building Occasionally Connected Systems
• MSDN Express Virtual Lab: Dimension Designer and Best Practice Alerts
• MSDN Express Virtual Lab: Hierarchy Id
• MSDN Express Virtual Lab Table Value Parameters + Merge Statement
• MSDN Express Virtual Lab: T-SQL Enhancements - Date/Time-Table Valued Parameters - MERGE SQL Statement
• MSDN Express Virtual Lab: XML Enhancements
• MSDN Express Virtual Lab: Change Data Capture
• MSDN Express Virtual Lab: X-Event Infrastructure
• MSDN Virtual Lab: Learn How to Build Occasionally Connected Applications with SQL Server 2008 MSDN Virtual Lab: Implementing Change Data Capture (CDC) in SQL Server 2008
• MSDN Virtual Lab: Working with the new DATE data type in SQL Server 2008

Keep up-to-date with new lab releases by subscribing to the SQL Server 2008 Virtual Labs feed