How to get the SQLCMD standalone for Microsoft SQL Server Management

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 …

ToolTip: Microsoft Product Support Reports and Microsoft Product Support Reports Viewer

If you get tasked to do some system troubleshooting and you just want to get as many information possible from a client, then have a look at the Microsoft Product Support Report Tool and the Product Support Reports Viewer. The Microsoft Product Support Reports Viewer 2.0 can be downloaded from here and the Microsoft Product Support Reports from here First launch the Microsoft Product Support Tool, which is a self-extracting executable (no installation needed). Once Read More …

App-V Management Server Setup and SQL Server Configuration

During the Installation of the App-V Management Server on a Windows Server 2008 with SQL Server 2008 Express installed I ran into an problem specifying the database server and got an error as shown in the picture below. The installation program could not connect to the configuration data store. Please see the installation log file for more information. I solved the problem by opening the SQL Server Configuration Manager and enabled TCP/IP in the SQL Read More …

SQL Server 2008 Express Installation Sources

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 …

SQL Server services user account

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 …