expressor Studio is a new data integration platform that is being marketed as the most easy to use tools of its kind. But “easy to use” can be a relative term – an expert can find a very complex system easier, but a beginner might be stumped. A recent article online discussed exactly what makes expressor Studio so easy use, and here is my view on this subject.
SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar
“I have text files and I need to create interactive reports for my boss – do you have few minutes of time right now? Let us discuss.” I often get questions from people who are new to technology and struggling to get something done. However, this time it was not…
Read MoreSQL SERVER – A Quick Look at expressor Data Quality Solutions
Last month I described the extension framework that allows one to easily add functionality to an expressor Studio installation. I then used this added functionality – the input and output operators to SalesForce.com – to develop an example application. But expressor has a second mechanism that allows you to easily enhance the…
Read MoreSQL SERVER – CSVExpress and Quick Data Load
One of the newest ETL tools is CSVexpress.com. This is a program that can quickly load any CSV file into ODBC compliant databases uses data integration. For those of you familiar with databases and how they operate, the question that comes to mind might be what use this program will…
Read More
SQL SERVER – Database Dynamic Caching by Automatic SQL Server Performance Acceleration
My second look at SafePeak’s new version (2.1) revealed to me few additional interesting features. For those of you who hadn’t read my previous reviews SafePeak and not familiar with it, here is a quick brief: SafePeak is in business of accelerating performance of SQL Server applications, as well as their scalability, without making code changes to the applications or to the databases. SafePeak performs database dynamic caching, by caching in memory result sets of queries and stored procedures while keeping all those cache correct and up to date. Cached queries are retrieved from the SafePeak RAM in microsecond speed and not send to the SQL Server. The application gets much faster results (100-500 micro seconds), the load on the SQL Server is reduced (less CPU and IO) and the application or the infrastructure gets better scalability.
SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool
Scroll down at the end of this post to win my SQL Wait Stats Book. I have used this tool extensively since 2009 at numerous occasion and found it to be very impressive. What separates it from the crowd the most – it is it’s apparent simplicity and speed. When…
Read More
SQL SERVER – SafePeak – The Plug and Play Immediate Acceleration Solution
Let us learn about SafePeak – The Plug and Play Immediate Acceleration Solution.
Introduction – Plug and Play
Given how important performance is these days among SQL Server critical applications, I was excited to look into a new product by SafePeak Technologies that aims to immediately resolve, in a plug-and-play way, the performance, scalability and peaks challenges of SQL Server applications on the Cloud, hosting servers and enterprise data centers.