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 – 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.
SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion
Two days ago, I was participating TechEd India 2011 and I had a great time presenting on various subjects. My computer fortunately behaved very well and I consider myself lucky for it. However, very next day, today, when I went to the office and turned on the machine, it did not start SQL Server. I was a bit confused and very quickly checked SQL Server Services. I noticed that services were OFF. I tried to turn on the services, but it keeps on giving me following error about request failed.
SQL SERVER – Denali – Improvement in Startup Options
I often work with advanced features of the SQL Server and this really led me to change how SQL Server is starting up. Recently I was changing the start up options in SQL Server and I was very delighted when I saw the startup option screen in Denali. It has really improved and is very convenient to use. Now I realized that the more I use Denali, the more I love it.
SQL SERVER – 32 Bit – 64 Bit – HTML5 – Database Backup Restore
During TechEd India I was attending HTML5 session along with regular Database sessions. Couple of attendees were discussing database there and I find the incidence very interesting.
SQL SERVER – 2012 – Zoom Query Editor
SQL Server next version ‘Denali’ is coming up with very neat feature which can be used while presentations, group discussion or for people who prefers large fonts.
SQL SERVER – Sharing your ETL Resources Across Applications with Ease
Frequently an organization will find that the same resources are used in multiple ETL applications, for example, the same database, general purpose processing logic, or file system locations. Creating an easy way to reuse these resources across multiple applications would increase efficiency and reduce errors. Moreover, not every ETL developer has the same skill set, and it is likely that one developer will be more adept at writing code while another is more comfortable configuring database connections. Real productivity gains will come when these developers are able to work independently while still making their work available to others assigned to the same project. These are the benefits of a centralized version control system.