SSWUG.ORG Articles

Do You Do Podcasts for SQL Server Information? (11/6/2009)

Did You Miss the Virtual Conference? No worries... There's still time - you can catch it on-demand right now! All of the sessions, all of the great content. The sessions, demonstrations and help is second to none, period. Take a look, check out the sessions, download the s...(more)

Data to Drive Decisions (11/5/2009)

SQL Server Performance Virtual Workshop Register Now to save your spot Really looking forward to the upcoming SQL Server Performance Virtual Workshop - I'll be teaching this workshop and going through all sorts of information from monitoring to TSQL gotchas to indexing and more. You can ta...(more)

Webcast Today: Database Recovery 101 (11/4/2009)

Featured Article(s) Useful Undocumented Informational SQL Server 2008 DBCC Commands In this article, Alexander Chigrik shows some useful undocumented informational DBCC commands that shipped with SQL Server 2008. Webcast Today: Database Recovery 101 Every DBA is required to maintain good bac...(more)

SQL Server Migration Successes (11/3/2009)

Featured Article(s) SharePoint file filtering beyond out-of-the-box Whether for audit or to enforce policy, file filtering in SharePoint is an excellent feature. Out of the box, you can specify the list of files you want to be blocked; not really do any audit on already uploaded files. Also, if ...(more)

SQL Server Upgrade Challenges (11/2/2009)

Featured Article(s) Installing MySQL and MySQL-Front tool It is very important before you learn how to install MySQL and MySQL-Front tool to understand what are the MySQL system is a relational database, ie tables relate to each other. The programming language used is SQL (Structured Query Lang...(more)

Webcast: ASP .NET Dynamic Data Starter (8/12/2009 @ 12:00)

Get up to speed with ASP.NET Dynamic Data in just a few minutes. In this demo you�ll see how to quickly setup a Dynamic Data web application. Presented by: Rachel Appel

Webcast: Upgrading to SQL Server 2008, It is easier than ever! (8/26/2009 @ 12:00)

Are you ready for SQL 2008? Many organization are still trying to upgrade from SQL 2000 to SQL 2005 and are now faced with the decision should they upgrade to directly SQL 2008 or do they upgrade to SQL 2005 then SQL 2008. In this session, we cover if you should upgrade to SQL 2008 and discuss potential incompatibility issues. We will then discuss the different methods to upgrade and how to plan for a rollback if needed. This session will cover upgrading SQL 2000 and SQL 2005. Presented by: Sarah Barela Sponsored by: Melissa Data (www.melissadata.com)

Webcast: Managing a Crisis (9/9/2009 @ 12:00)

Do you have a plan for your next Crisis? What should you look for? Presented by: Chris Shaw Sponsored by: SSWUG.org

Webcast: Visual Studio 2008 Quick Tips (9/23/2009 @ 12:00)

In this presentation you�ll see a series of tips for making your time spent in Microsoft Visual Studio more productive. Presented by: Rachel Appel Sponsored by: SSWUG.org

Webcast: Processing Late Arriving Facts with Integration Services (9/30/2009 @ 12:00)

Handling late arriving facts and performing historical loads are common tasks in Data Warehousing scenarios. This webcast takes a look at the pros and cons of three different approaches to this problem using SSIS. Presented by: Matt Masson Sponsored by: SSWUG.org

Webcast: Measure Twice, Develop Once (10/28/2009 @ 12:00)

One site-collection or two? Subsite or List? The answer to these questions guides the decisions of many deployments. When mistakenly answered organizations quickly learn how hard it is to gain their return on investment. We will explore the importance of requirements gathering, the limitations of SharePoint, and some backend considerations in making these decisions. Presented by: Adam Levithan Sponsored by: EMC (www.EMC.com)

Webcast: End to End Database Development (11/18/2009 @ 12:00)

How to manage the database Application Lifecycle. This session will discuss team-focused database development challenges, and will present tried and true methodologies for dealing with database development issues. This session is a must-attend for any database developer working in a team environment. Presented by: Ted Malone Sponsored by: Embarcadero (www.embarcadero.com)

Webcast: Protect & Defend Your Data (12/2/2009 @ 12:00)

With most SharePoint implementations storing critical business data, it is crucial that this data be protected and quickly restorable in the event of a disaster. Learn how utilizing Data Protection Manager 2007 as your backup/restore/disaster recovery solution provides a full-fidelity solution with granular control. We will walk you through the initial configuration of DPM as well as setting up a recovery farm. Presented by: Christopher Regan Sponsored by: EMC (www.EMC.com)

Webcast: Database Recovery 101 (11/4/2009 @ 12:00)

Every DBA is required to maintain good backups of their systems. But what are your options for recovering the system once you do experience a failure? In this presentation youll learn how to restore various types of database backups, the impact the recovery process has on your system, and how to estimate downtime and time to recover. Presented by: Buck Woody Sponsored by: BakBone (www.BakBone.com)

Webcast: Upgrade to SQL Server 2008 � Before This Presentation Finishes (11/25/2009 @ 12:00)

In this session we�ll review lessons learned and best practices when upgrading from previous versions of SQL Server to SQL Server 2008. In this session we�ll go through the changes to the installation and upgrade to SQL Server 2008. Also, how do you prepare for the upgrade? Do you install now or wait until later? Can your production database be upgraded in less time that it takes to complete this session? Presented by: Jason Strate Sponsored by: SSWUG

Webcast: Argument for Change Control (8/19/2009 @ 12:00)

How implemention Change Control can help your business. Presented by: Chris Shaw

Webcast: Convert Your Script to a Custom Task in Five Easy Steps (9/2/2009 @ 12:00)

This session will show you how to can turn your script into a custom task, allowing you to easily reuse it between packages, and share it with the world. Presented by: Matt Masson Sponsored by: SSWUG.org

Webcast: Quick Dynamic Data Customizations (9/16/2009 @ 12:00)

In this demo learn how to kick off a new project, setup the data model and make a few customizations to the �out of the box� Dynamic Data site structure. Presented by: Rachel Appel Sponsored by: SSWUG.org

Webcast: jQuery Quick Hit (10/7/2009 @ 12:00)

In this demo you�ll learn where to get and how to install jQuery. Then we�ll demonstrate some basic features of jQuery, such as the jQuery function and selectors. Presented by: Rachel Appel Sponsored by: SSWUG.org

Webcast: SQL Server Best Practices (10/14/2009 @ 12:00)

Having worked with databases for some time now, I felt it important to get some best practices documented. This presentation will touch on the simple things that we often take for granted while using our favorite database systems. From naming conventions, to cursors,to temporary, derived and variable tables, to the use of dynamic sql. We�ll touch on a great many different ideas and hopefully further cement your own best practices, making you a more exceptional DBA or Database Developer. Presented by: TJay Belt Sponsored by: Melissa Data (www.melissadata.com)

Federation of Oracle Data in DB2

(Vikram Khatri) These steps are for Oracle database (any supported version from Oracle) to DB2 9.5 but they should work as it is for DB2 9.7 or later with proper Oracle client install. 1. Install DB2 3. Install Relational connectors or Install InfoSphere DB2 (The InfoSphere DB2 is a limited edition of DB2 with relational connectors to connect to other relational databases such as Oracle, SQL Server, Sybase etc.). You do not need to install IBM branded DataDirect ODBC drivers in order to connect to Oracle since we will be installing Oracle client to connect to Oracle from DB2 server. (InfoSphere DB2 is used to be known as IBM Webspehere Federation Server.)