Have you seen the SSWUG.ORG Script Library?
http://bitonthewire.wpengine.com/scripts – 100’s of scripts, read, review, post your own – great tools! (See below for a top 10 scripts show too!)
Featured Article(s)
Step by Step to Capture change data in IBM DB2 — Part 2
Step by Step to Capture change data in IBM DB2 — Part 2 . IBM consistent Change Data capture provides the capacity to track changes to tables and store them in a change table. With this functionality any source database can be identified and objects (tables) within the database can be selected. You can capture the changes to the table row within or on different database. It is always advisable to create a separate database and store the change data. In this article we would create CCD tables to store and track change to a table. Any Insert , update or delete statement on the table will be stored in the destination database with the operation , and time stamp and the data.
New SelectViews Show Available
The final segment of the three-part show – There are some great scripts out there that will bring you all sorts of information about what’s happening with your SQL Servers, debugging, performance management, indexing and a whole lot more. Chris and I set out to find the best of the best scripts and put together a several part show so you could see just a bit of what’s available. Kudos to the script-builders out there – great work!
Part 3: Chris Shaw, Stephen Wynkoop explore the top 10 SQL Server scripts that you simply must know about. Learn about scripts, why these particular scripts are great and where they are found.
[Watch the Show Here]
Previously:
[Watch Here] (Part 2) Chris Shaw, Stephen Wynkoop explore the top 10 SQL Server scripts
[Watch Here] (Part 1) Chris Shaw, Stephen Wynkoop explore the top 10 SQL Server scripts
[Watch Here] (Part 2) SQL Server Performance Tips.
Looking for a Job? Looking to Post a Job?
Head to the SSWUG.ORG career center – you can post your resume (even making it anonymous) for others to review, check out job listings and much more. The cool thing is that you (the candidate) have the final say on contacts from potential employers and you can pick and choose who you’d like to share your personal details with. It’s pretty cool. Check it out here.