I wanted to publish this quick blog tonight to answer some of the questions that I have received recently regarding installation from an .ini file. Microsoft has published a great MSDN article that lists the commands and options to use for installing...

I came across this excellent blog by Euan Garden, who is a Group Program Manager at Microsoft. http://blogs.msdn.com/euanga/archive/2006/05/04/585513.aspx In this blog, he tries to answer the most commonly asked question - how to hide databases...

Microsoft launched SQL Server 2005 in November, 2005. This build was called the RTM version. In April, 2006, we launched Service Pack 1 which included a lot of new features and fixes for known bugs. Check out my blog here to learn more about SP1. ...

Due to your company's password policies, you might have to change the password of the domain account used as the startup account by SQL Server services. Your changes will be reflected in the active directory. Next time, when SQL Server services try...

I wanted to post this quick blog to answer a very common question - domain vs local system account for SQL Server services. All this information is out there at Books Online. So I will just put references here. Local System Account is a very privileged...

In SQL Server 2005, you can set collations at the following levels: - Server Level o You set the collation of the server at the time of setup. o The only way to change that is to re-install SQL Server with the right collation. o To find...

Generally, you would set the startup accounts for SQL Server services during the startup. However, there are times when you might want to change it after installation. Many DBAs are so used to Services.msc console that they use it to change...

The answer to this question is NO. However, there are some special considerations, so read on. You don’t need to run SQL Server services under an administrative account or a Domain Admin account – neither on a standalone box nor on a cluster. ...