SQL SERVER – Import CSV into Database – Transferring File Content into a Database Table using CSVexpress
SQLAuthority News – 5th Anniversary Giveaways
SQLAuthority News – History of the Database – 5 Years of Blogging at SQLAuthority
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.