SSWUG.ORG Articles

About Denormalization of Your SQL Server Databases (11/20/2009)

Announcing: DBA School - Learning SQL Server for the Rest of Us A three-day course taught by Stephen Wynkoop - centered around real-world experiences, how-to information and specific demonstrations and labs that will let you use and explore the topics covered. We'll be covering Performance, ...(more)

Data Warehouses and De-Normalization (11/19/2009)

Featured Article(s) How to EASILY Migrate from IIS 6 to IIS 7 There are tons of great new features in IIS7 and the list continues to grow. We identify the top reasons people refuse to upgrade to IIS 7 and show you how a new tool from Microsoft, the Web Deployment Tool, makes the process nearly s...(more)

Microsoft "Dallas" Platform - Things That Make You Think... (11/18/2009)

Featured Article(s) Undocumented Validation SQL Server 2008 DBCC Commands In this article, Alexander Chigrik shows some useful undocumented validation DBCC commands that shipped with SQL Server 2008. Last Day To Register! Workshop is TOMORROW Tomorrow is the day - 3+ hours of SQL ...(more)

SQL Injection Point of Interest (11/17/2009)

Twitter - Facebook SSWUG.ORG page vWorkshop - Last Days to Register - Register Now! SQL Server Performance - Presented by Stephen Wynkoop I'll be doing a virtual workshop THURSDAY - several hours on SQL Server performance. Find out about indexes, TSQL tips,...(more)

On Automation and SQL Server (11/16/2009)

Get Social! Twitter - Facebook SSWUG.ORG page vWorkshop - Just a Couple of Days Away - Register Now! SQL Server Performance - Presented by Stephen Wynkoop I'll be doing a virtual workshop THURSDAY - several hours on SQL Server performance. Find out about indexes, TS...(more)

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

Complex Event Processing (CEP) with SOA creates business benefits

(Mike Pontacoloni) A complex event is an event indicated by the asynchronous occurrence of multiple other, often simpler, events. To use a non-software example: A person throwing a ball, a person swinging a bat, and a person running to a base are each individual events which compose the complex event of a baseball game. (R)