Important: Moving Projects to Production? When you move projects to production, you need to be absolutely certain that you have the right pieces deployed, the right changes completed. You need to be able to check data, objects and synchronize it all, making sure the changes and updates are reflected in the production environment. Idera’s SQL Comparison Toolset will take care […]

Managing Database Change – Community Responds A few days ago I shared some of my experience with Database Change Control. Many of you chose to respond with excellent comments. Following is a response from Thom providing a nice bulleted list of the problems he faces. There aren’t really any solutions here, but he sure helps break down the nature of […]

Things that Make You Say ‘Icky’ I once won second place in a contest; but, never wanted to tell anyone about it. That was because it was a contest for the worst SQL code. Second place was so bad it was worth $100. I wonder what the $500 first place code looked like. “What was bad enough to win $100”, […]

DBASchool – 3 Days of In-Person Training Stephen Wynkoop (SSWUG.ORG Founder/Editor!) will be presenting an exclusive three-day course on what you need to know about SQL Server for your every day support of your systems. The class has very limited seats available and will focus on real-world instruction, discussion about how it applies specifically to your systems and focus on […]

Data Cleansing with SSIS – Brian Knight In this session, Brian Knight will show how to cleanse your data and apply business rules to your data in SSIS. Learn how to solve complex data problems quickly in SSIS using simple techniques in the data flow. Brian will start by showing you an easy package to bring you up to speed […]

New SelecTViews Show On the show this week, hear from Kevin Kline and TJay Belt. Talking buy vs. build, consolidation lessons learned, the cloud, security and many other great tips. [Watch Now] Previous shows, available now: [Watch Now] Craig Utley and Jason Strate on SelecTViews. [Watch Now] Donald Farmer and Buck Woody on SelecTViews. Have You Registered for the Smart […]

Featured White Paper(s) Java Database Connectivity Database connections are the lifeblood of enterprise applications, administrating the secure and steady flow of information b… (read more) Upcoming Events Workshop: SQL Server 911 – SQL Server MVP Chris Shaw’s workshop on everything (and I do mean EVERYTHING) you wanted to know and fully understand about SQL Server backup and recovery is coming […]

Featured Article(s) Custom SharePoint webpart property error messages When creating webparts with properties in them to store custom data – you can never rely too much on users not making errors and typos. The best way to tell your site contributors that they have specified an invalid webpart property is to display error message right there is a webpart tool […]

Webcast: Processing Late Arriving Facts with Integration Services 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 > Register Now > 9/30/2009 at 12:00pm Noon Pacific Database Design – the Biggest […]

Guest Editorial – Chris Shaw, SSWUG Site Manager Have you used Database mirroring? Database mirroring was a feature released in SQL Server 2005 service pack 1. When deployed on your systems, it will make a copy of your database and ship it to another server. The server can be located in the next rack, a building across the street or […]