expressor Studio is sold as an easy Data Integration tool, but easy is relative. My view of its top 10 ease of use features, like a single .exe install.
SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar
A friend needed interactive reports for his boss from plain text files. Our one hour chat, from CSV to Excel Pivot Table, turned into a webinar.
SQL SERVER – A Quick Look at expressor Data Quality Solutions
A quick look at expressor data quality solutions: reusable operator templates that add data quality features to expressor Studio, and how to use them.
SQL SERVER – CSVExpress and Quick Data Load
CSVexpress loads any CSV file into ODBC compliant databases quickly. Here is why it helps when writing load scripts for every RDBMS is a pain.
SQL SERVER – Database Dynamic Caching by Automatic SQL Server Performance Acceleration
My second look at SafePeak 2.1, which speeds up SQL Server apps with Database Dynamic Caching of query and procedure results in memory, with no code changes.
SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool
SQL Backup and FTP backs up SQL Server databases, then zips, encrypts and sends them, with setup in a minute or two. Here is why I have used it since 2009.
SQL SERVER – SafePeak – The Plug and Play Immediate Acceleration Solution
SafePeak is a Plug and Play caching proxy between your application and SQL Server that aims to speed it up with no code or database changes. My first look.