SQL Utility « SQL Server Journey with SQL Authority

Archive for the ‘SQL Utility’ Category

SQL SERVER – A Quick Look at expressor Data Quality Solutions

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on January 11, 2012 | 1 Comment »

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 functionality of your installation – [...]

Read Full Post »

SQL SERVER – CSVExpress and Quick Data Load

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on November 13, 2011 | 1 Comment »

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 have in your life. I [...]

Read Full Post »

SQL SERVER – Database Dynamic Caching by Automatic SQL Server Performance Acceleration

Posted in About Me, Pinal Dave, PostADay, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on October 31, 2011 | Leave a Comment »

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

Read Full Post »

SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool

Posted in PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, T SQL, Technology on October 3, 2011 | 14 Comments »

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 I install SQLBackupAndFTP and configure [...]

Read Full Post »

SQL SERVER – SafePeak – The Plug and Play Immediate Acceleration Solution

Posted in PostADay, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, T SQL, Technology on August 11, 2011 | 19 Comments »

Introduction Given how important performance is these days among SQL Server critical applications, I was excited to look into a new product by SafePeak Technologies (www.SafePeak.com) 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. While [...]

Read Full Post »

Older Posts »