You folks might have already know that a new version of SQL Server is on the way to market. Right now beta version of SQL Denali (aka SQL Server 2011) is released. In this version addition of startup parameter is made easy and effort less. In previous version we will be adding it in a text box separating each entry with semi colon(;) . There is a chance that we might miss that semi colon and it will result in SQL server startup failure. To over come this in this version they have made it simple by adding the parameter in a list. To add or modify startup parameter try the below steps
Category Archives: General - Page 2
Configuring Change Data Capture
Posted by Vidhya Sagar
on October 30, 2010
1 comment
Does Extension matter for Creating a database?
Posted by Vidhya Sagar
on August 12, 2010
4 comments
We have 3 types of file extensions in SQL Server. MDF, NDF and LDF each one representing Primary, Secondary and Log file respectively. Do you think these extensions are need to be given to the respective files? If your answer is yes then you are wrong. You can give any extension as you like or else you can even interchange these 3 extensions to primary, secondary and log file. Extension plays a important role for us to understand which file is what where as when you attach the db, SQL (by pointing the primary file) knows where the log file and the additional files for the db, it will attach the database without any errors. This is because SQL will check the primary file (which you have pointed) and if it’s in right format then it will start reading the header page to fetch additional details about other files and attach the database. Read more »
Performance Data Collector – Part 2
Posted by Vidhya Sagar
on July 25, 2010
4 comments
Last month I’ve wrote an article on Performance Data Collector part one, I thought of writing part 2 soon however I was stuck with Organizing SQL Code Camp with my fellow MVP Deepak & Sugesh. Now it’s almost a month so thought of writing the second part. In this part we are going to see how to customize the data collection, retrieval of reports from PDW (Performance Data Warehouse) etc.
SQL Code Camp at Chennai–Great Success
Posted by Vidhya Sagar
on July 21, 2010
3 comments
I, Deepak & Sugesh have organized SQL Code Camp – One full day event for SQL Server last Saturday (17th July 2010). We are happy to say that this is the first one full day event for SQL Server held in India and we are proud that we are organizing it. Deepak and Sugesh has already created a post so I’m not going to write much about the event. You can find our experiences and learning from the link below.