Editorials

Editorials

On Error Resume Next

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 […]

Editorials

On Being a Database Facilitator

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 […]

Editorials

System Testing

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 […]

Editorials

Is There a Place for Test Recorders Anymore?

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 […]

Editorials

Open Kimono Time for Data

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. […]

Editorials

Integrating Regular Expressions with SQL

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 […]

Editorials

Is Entity Framework the Next ODBC?

Is Entity Framework the Next ODBC? What made ODBC a viable technology? It created a single interface for which drivers could be written allowing access to a data store. ODBC drivers were written for text files, Excel Documents, Microsoft Exchange, ISAM Files, Relational Databases, and much more. The key was, there was a common interface used by an ODBC consumer; […]