New In-Person Training Courses for Phoenix, Metropolitan Dallas and San Francisco! With our in-person training partner SolidQ, SSWUG is proud to announce three new classes that will take place in February! If you’re interested in learning more about the Microsoft Business Intelligence stack, we have hands-on labs in San Francisco, Phoenix and Irving, TX. Click here to review the upcoming […]

Copying a Large Database Through Scripting I was reminding folks that sometimes we have to revert to the very basic method of copying a database by scripting SQL statements from an existing database for one reason or another. There are many great tools out there that do it naturally. I have used DB Compare with great success for many years. […]

Free Career Guidance Expo Next Friday SSWUG.ORG’s free virtual expo presents techniques for information technology (IT) professionals to enhance their professional life in 2012. Through our in-depth sessions with some of the leading functional specialists in the IT field (Bill Pearson, TJay Belt, Chris Shaw and Tom Roush), you will see many examples and case studies on ways to improve […]

MDX Training (Chicago) Our training partner, SolidQ, will be hosting a hands-on, instructor-led course on Jan. 31-Feb. 2 from 8:30 a.m. to 4:30 p.m. in Lisle, Illinois. The course will guide students step-by-step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. Tim Peterson, the course instructor and author of several books on Business Intelligence, will provide […]

On Being a Database Facilitator Chris Shaw wrote in with thoughts on the posting Monday about being a Database Facilitator – "30 years ago we were just afforded the technology to watch a movie at home. If I wanted to see Star Wars more than once, my only option was to return to the theaters. 15 years ago if I […]

Is Work/Life Balance for DBAs Just a Myth? Many database administrators started their careers in the exact same way: 80-hour work weeks, routine overnight gigs, no life outside the office—this was simply what was considered “normal.” Today, with careers underway, how do DBAs build a life outside of their data? In our webcast next Wednesday, Meredith Ryan-Smith, who is a […]

SSWUG TV With Stephen Wynkoop, Sam Brace and Field Reporter – Kevin Kline If you are thinking about moving into the Cloud, you will want to watch the Interviews with SQL Azure MVP Scott Klein Watch the Show Enterprise ETL with SSIS Training Opportunity For those of you near Denver, Colorado we have an opportunity just for you in association […]

Open Kimono Time for Data Is it time to shift our job goals? I think so. For years it’s been about protecting data. This has run the full range of duties, from protecting data security-wise to protecting data to provide for recovery. I think these are still key, but I think too that our focus is going to necessarily shift. […]

SSWUG-TV With Steven Wynkoop, Sam Brace, and our Field Reporter – Kevin Kline In this new episode of SSWUG-tv we take a look at the purchase of Green Hat by IBM. Come Check It Out Is Entity Framework the successor to ODBC? Lots of good input on this topic. Some of the responses are contradictory. Here’s what some of our […]

Integrating Regular Expressions with SQL A number of people have responded with their take on the use of Regular Expressions in SQL. Many point out how valuable Regular Expressions have been to them using engines already supporting regular expressions. Others extend on this with links to CLR user defined Regular Expression extensions for SQL Server 2005 and later. Based on […]