Couple of months ago I had the opportunity to share with my first look at SafePeak, a new and unique software solution for improving SQL Server performance and solving bottlenecks, accelerates the data access and cuts the CPU and IO of your SQL Server. SafePeak unique approach not just tells you about the problems but actually resolves them automatically and improves SQL Server performance and the performance of the applications dramatically. Let us read about Performance Acceleration.
SQL SERVER – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry
In this blog post we will see three new DMVs which are introduced in Denali. The DMVs are very simple and there is not much to describe them. So here is the simple game. I will be asking a question back to you after seeing the result of the each of the DMV and you help me to complete this blog post.
SQLAuthority News – SQL Server 2008 SP3 Available to Download
This news is one week late but still very useful as per my perspective. Please note this are for SQL Server 2008 and will not work with SQL Server 2008 R2. SQL Server 2008 Service Pack 3 Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008…
Read MoreSQL SERVER – SQLPASS Memory Lane of 2009 and 2010
Today is the last day of the SQLPASS 2011 and I will be soon posting SQL Server 2011 experience over here. We all change, life change, event changes, experiences change and but memory hardly changes. I have quite commonly noticed that we all remember the good memories for long time…
Read More
SQLAuthority News – SQLPASS – Today FREE 100 SQL Wait Stats Book Print Copy – Book Signing
“If there’s a book you really want to read, but it hasn’t been written yet, then you must write it.” ~Toni Morrison I wrote book on SQL Wait Stats. [Amazon] | [Flipkart] | [Kindle] I really wanted to learn about SQL Wait Stats. There was no real book available so I…
Read MoreSQLAuthority News – SQLPASS – 100 SQL Wait Stats Book Print Copy Giveaway – A Book Every Minute for an Hour Tomorrow
“Appreciation is a wonderful thing: It makes what is excellent in others belong to us as well” – Voltaire “The greatest of all gifts is the power to estimate things at their true worth” – Francois De La Rochefoucauld Please Note: The date and time are Thursday 13 at 1…
Read MoreSQL SERVER – expressor Studio 3.4 Rules Editor – ETL Graphical Coding Tool
New in the expressor Studio 3.4 release is the rules editor. This graphical coding tool replaces the transform editor of earlier versions. The rules editor works in concert with the newly introduced attribute propagation functionality to minimize the amount of data mapping and coding you need to provide. The expressor…
Read More
SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2011 – Seattle
For the third year in a row, I am attending the SQLPASS Summit, October 11-14. Every year I have explained my reasons for attending this conference in Seattle, and this year I will state those reasons again. WHY? I have written two articles on this subject, which you can read…
Read More
SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You!
I really never thought that I would be writing this post – honestly! After 1900th post and almost 5 years, this has been a journey and lots of learning. I get to write a 100 “mile stone” post 3-4 times a year, so I am happy to be writing this one. I am eagerly looking forward to my 2000th blog post as well.
SQLAuthority News – System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance
Microsoft is continuously releasing System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance