Friday, January 30, 2009

Welcome to SQL Sets

Hello and welcome to the SQL Sets product blog. It is here that we will communicate news, high light features, discuss future releases and offer tips & tricks for getting the most out of SQL Sets.

What is SQL Sets?

The one-floor elevator pitch for SQL Sets is:

SQL Sets allows you to quickly capture and organize snapshots of your SQL Server data into a single, self-contained file called a Portable Data Document.

Why SQL Sets (or What "pain" does this solve for me)?

There wouldn't be much point to the product if it didn't solve some fundamental "pain" experienced by IT professionals every day. In this case, it's the lack of an easy way to share, collaborate on and store snapshots/slices of SQL Server data. Sure, cutting and pasting from SQL Management Studio into emails and Word or Excel documents can get you part of the way there, but it is cumbersome and somehow leaves you wanting more.

Once the data is copied and pasted....it loses its context, is awkward to work with and cannot be easily refreshed...it is basically "homeless". The goal of SQL Sets is to provide a native document format and environment for working with these offline slices of your database. That's where the idea of a Portable Data Document comes into play. It is to SQL Sets what an .xls file is to Excel and a .doc file is to Word (sorry for stirring those painful SAT analogy memories ;-)).

The SQL Sets application is specifically tailored to work with relational data and provides shortcuts and utilities for extracting meaningful subsets of data from your database. It also allows you to work with data in ways that make sense for relational data, not free form text or numbers as Word and Excel are suited for. This functionality includes Bookmarks, Annotations, Grouping, Sorting and Filtering.

With that said, we look forward to hearing from you as to how we can improve on SQL Sets to make your life as an IT and business professional a little bit easier than it is today!