Secondary Menu

SQL

In the days that I was an Oracle database admin (long long time ago) the two most important applications I used to manage a database were SQLNet and SQL Plus. SQL-Net for providing database connectivity and SQL Plus as the command line interface. For Microsoft SQL Server the kind of equivalent to Oracle’s SQL Plus is SQLCMD. But for a long time this utility was only available with a full SQL Server installation or as Read More …

I got a bit confused by all the different SQL Server 2008 Express downloads that exist, so spend a little time in getting some insight. If you want to download SQL Server 2008 Express you have the following options: Package Download Microsoft® SQL Server® 2008 Express Edition Service Pack 1 Download Microsoft® SQL Server® 2008 Express with Tools Download Microsoft® SQL Server® 2008 Express with Advanced Services Download Then I recommend reading the following Read More …

When you install SQL Server 2000 / 2005 / 2008 you can configure under what user account the services are running. In the past i’ve often seen people selecting “local system”, I also selected that….not thinking too much about security then and it was the easiest to do with no need to create an additional user account and as long as you don’t need to access any other domain resources that worked fine. Today from Read More …