SSWUG.ORG Articles

Virtual Conference Registration - Last 2 Days of Early Bird (7/6/2009)

Virtual Conference Registration - Last 2 Days of Early Bird You don't want to spend your time running all over the country to keep skills updated. You also want to stay on top of techniques, best practices and such. On top of all this, if your budgets are like everyone else's, your tr...(more)

Webcast: How to Hire a DBA Part 1 of 3 (7/2/2009)

vConference Early Bird About to Expire Shhh... don't tell my boss. The Early Bird rates to save on registration for the vConference on July 22 is still in effect. It'll be going away early next week - so register right away to save! We'll be featuring the most amazing content on...(more)

Interesting Issue of Design with SQL Server (7/1/2009)

Featured Article(s) SQL Server 2005 DBCC Optimization Tips (Part 3) In this article, you can find some helpful SQL Server 2005 DBCC performance tuning and optimization tips. Interesting Issue of Design with SQL Server I was reading over this post by one of our frequent email discussion list ...(more)

Interesting Things Happening with Tools for SQL Server (6/30/2009)

Do You Have a DTS/SSIS Mixed Environment? The solution to migration, having code reusability and a whole lot more is found in BI xPress. If you've experienced the challenges of migrating packages from DTS to SSIS, learning about the re-coding, seeing what's involved and thing figuring out h...(more)

Webcast: SQL Server Reports and OLAP cubes in SharePoint (6/29/2009)

Webcast: SQL Server Reports and OLAP cubes in SharePoint Quickly see how easy it is to use SSRS web part to display SSRS reports on SharePoint pages. Quickly see how to display an OLAP cube KPI on SharePoint page by using the included web part. PResented by: Lynn Langit > Register Now -&...(more)

Webcast: Tools for SQL Server Backup Heroes (6/10/2009 @ 11:00)

Recent trends in the database industry have lead to a number of challenges for managing SQL Server. Most databases grow in size over time. Regulatory requirements mandate maintaining certain amounts of data online. Users also want to see more of their data. And the number of users for database applications grows over time as users discover where relevant data is located. To address these challenges, DBAs and other IT professionals must look to new technology to continue to perform their jobs effectively and in the same amount of time. In this session, we�ll explore the challenges of increased storage and consolidation, log shipping, clustering and other solutions to help the true heroes of SQL Server meet the test. Presented by: AppAssure (www.appassure.com)

Webcast: SQL Server Reports and OLAP cubes in SharePoint (7/1/2009 @ 12:00)

Quickly see how easy it is to use SSRS web part to display SSRS reports on SharePoint pages. Quickly see how to display an OLAP cube KPI on SharePoint page by using the included web part. Presented by: Lynn Langit

Webcast: How to Hire a DBA Part 1 of 3 (7/8/2009 @ 12:00)

Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part one of this series we will talk about defining the role. Presented by: Chris Shaw

Webcast: How to Hire a DBA Part 2 of 3 (7/15/2009 @ 12:00)

Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part two of this series we will talk about reviewing a resume. Presented by: Chris Shaw

Webcast: How to Hire a DBA Part 3 of 3 (7/29/2009 @ 12:00)

Are you looking to hire a DBA? This 3 part series will help you in what you should look for. In Part three of this series we will talk about the interview. We will finish up with making a decision on who to hire. Presented by: Chris Shaw

Webcast: DTS Conversion to SSIS � Conversion Best Practices (8/5/2009 @ 12:00)

Join this webcast and Learn how and why to convert DTS to SSIS. See how you can save time and money and easily migrate your DTS packages to SSIS � Introduction to SSIS and its differences vs. DTS � Advantages of SSIS over DTS � Options for converting DTS packages to native SSIS � Adding value to packages during the conversion process � Assessing the scope of a DTS conversion project Presented by: Brian Knight of Pragmatic Works (www.pragmaticworks.com)

The ADF 11g Area Template - for micro level layout design patterns

(Lucas Jellema) ADF 11g offers various facilities for reusables. To name a few: Task Flows provide packaged, self contained functionality that consists of both User Interface and Data Bindings and potentially even some process logic and multi step navigation. Task flows can expose parameters that accept values used to dynamically influence the task flow�s behavior. Task flows do not expose facets (which could be an interesting extension of the task flow mechanism). Task flows can publish events that ADF can propagate to consumers outside the region that consumes the task flow.

Approaches to 'UPSERT'

(Kenneth Downs) This week in the Database Programmer we look at something called an "UPSERT", the strange trick where an insert command may magically convert itself into an update if a row already exists with the provided key. This trick is very useful in a variety of cases. This week we will see its basic use, and next week we will see how the same idea can be used to materialize summary tables efficiently.

Oracle LOB Processing

(Michael McLaughlin) This page demonstrates how to upload, store, and manage CLOBs (Character Large OBjects) and BLOBs (Binary Large OBjects). It provides some instructions that supplement Chapter 8 in my Oracle Database 11g PL/SQL Programming book.