SQL SERVER – Transaction Log Impact Detection Using DMV – dm_tran_database_transactions

Just a few days ago before I received the email from blog reader asking if there is any DMV which can provide details about the effect of a transaction on the transaction log file. Absolutely! Here is a quick script which can provide the necessary details: SELECT transaction_id, DB_NAME(database_id) DatabaseName, database_transaction_begin_time…
Read More

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)

Recently I formatted my computer and installed fresh SQL Server in it. I installed the AdventureWorks database in my database. Once done, I wanted to run few test scripts on my database. Just like every DBA, I decided to take backup of my database – this way I can restore it back to attain an original database state. As soon as I ran the backup command I ended up with the following error. This error is due to a permissions issue on the local disk and user account which is running SQL Server. In this blog post we will talk about the operating system error.

Read More

SQL SERVER – expressor Studio Includes Powerful Scripting Capabilities

One of the major problems in developing a data integration application is writing transformation code.  Many tools try to meet this need by providing a large number of operators that minimize coding through configuration. Specialized operators are fine for basic transformations, but most ETL transformations require logic specific to the…
Read More

SQL SERVER – TempDB in RAM for Performance

Performance Tuning is always the most interesting subject when we talk about software application. While I was recently discussing performance tuning with my friend, we started to talk about the best practices for TempDb. I also pointed my friend to the excellent blog post written by Cindy Gross on the subject: Compilation of SQL Server TempDB IO Best Practices. One of the discussion points was that we should put TempDB on the drive which is always giving better performance.

Read More

SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day Next

Read my complete experience series of TechEd 2011, Bangalore TechED 2011 – Bangalore – An Unforgettable Experience – Day 0 TechED 2011 – Bangalore – An Unforgettable Experience – Day 1 TechED 2011 – Bangalore – An Unforgettable Experience – Day 2 TechED 2011 – Bangalore – An Unforgettable Experience…
Read More