Nob Hill Software Database Compare: A Data Developer’s Dream Tool For Comparison And Migration Of Databases By: Stephen Wynkoop Introduction Database comparison and migration tools are evolving and now provide leverage and advanced guidance and feedback during the migration and testing process. Moving beyond a traditional copy-style migration tool can save time, money and frustration in managing your data infrastructure....

Columnar Databases and SQL Server Columnstore Indexes Lately I have been working with Vertica – a column based database from HP and I have to admit that I am amazed by its capabilities and the functionalities it offers, especially when we are talking about relatively big data. The basic difference between SQL Server and Vertica is the way they store...

Issue SQL Server depends on the MASTER and RESOURCE databases for critical information required to start the instance. Without these databases your SQL SERVER will not start. We recently had an outage where everything on the RAID-5 disk drive array containing the SQL Server system (master, resource, model and MSDB) and USER databases was lost due to hardware failure. After...

How to manage without micromanaging Part 3 Influencing different roles to see eye to eye Professional development series This is Laura Lee Rose, instructor for the OnLine Coaching Series on SSWUG and I am a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. In an interview with Stephen Wynkoop on SWWUG...