SSWUG.ORG Articles

New SelectViews Show (7/10/2009)

Registered Yet for the Virtual Conference? It's only days away. [Register Here] New SelectViews Show The show today features RAID and Defrag tips, backup optimization with filegroups, baseline stats and industry news. Also, find out about virtual learning opportunities, the SQL ti...(more)

SQL Server 911 Workshop - July 21 (7/9/2009)

SQL Server 911 Workshop - July 21 Register now to attend Chris Shaw's workshop - all you need to know about SQL Server backup, restore, recovery and options. You can download the workshop outline here at the site. Be sure to get registered right away - we'll even send out certificates...(more)

Webcast Today, SQL Server 911 Workshop Date, More (7/8/2009)

Last day for early bird discount for the July 22-24 refresher virtual conference ... ... is TODAY. [Click here to get registered] Don't Forget the Basics when Troubleshooting So many times in talking with people using SQL Server they realize that the solution to ...(more)

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

Webcast Tomorrow: How to Hire a DBA Part 1 of 3 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 > Register Now > 7/8/2009 at 12:00pm Noon Pacific ...(more)

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: 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)

WebSphere MQ for z/OS security

(Tom Schneider) Previous articles on developerWorks have addressed WebSphere MQ security on the distributed platforms. This article examines WebSphere MQ security on z/OS, with particular attention to controlling administrative access, and using RACF classes effectively for MQ security. While this article will be easier to follow for readers with experience with WebSphere MQ for z/OS and RACF, it should be helpful to anyone interested in this topic.

DB2 9 migration: SQL performance best practices

This document contains best practices related to query performance issues for approaching migration to DB2 9 for z/OS.

DB2 Cloud with RightScale - Part 1 - Local Storage

This screencast by Bradley Steinfeld walks you through getting started with the free DB2 Express-C on Amazon's Elastic Compute Cloud using RightScale server templates. Part 1 demonstrates the setup using non-persistent local storage.