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.
SQL SERVER – Query to Recent Query on Server with Execution Plan Function to Get SQL
This blog post is written in response to the T-SQL Tuesday hosted by Matt Velic. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a…
Read MoreSQL 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 MoreSQL SERVER – Add New Column With Default Value
SQL Server is a very interesting system, but the people who work in SQL Server are even more remarkable. The amount of communication, the thought process, the brainstorming that they do are always phenomenal. Today I will share a quick conversation I have observed in one of the organizations that…
Read MoreSQLAuthority 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 MoreSQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 3
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 MoreSQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 2
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