We had a PASS volunteer SIG (Special Interest Group) teleconference today. One item discussed was server consolidation. Microsoft is interested in this area and is seeking input. During the earlier discussion we had, Bill Wunder and Lynda Rab brought up good points like login transfer, collations, tempdb issues, job management and maintenance, resource allocation, and […]

In SQLCMD, if you type ed, it will invoke a text editor and put the last command you run in the editor buffer. The default editor is Edit, a command line editor of DOS. This behavior is very similar to Oracle Sql Plus, by the way. The difference is that in Sql Plus, you can […]

SQLCMD is a command line utility for Sql Server 2005. Like osql and isql, it can be used interactively. It can also be used as a scripting tool to automate a lot of routine tasks. It is the later part that I find exciting and fun. (By the way, isql is not available in Sql […]

By now, you probably know that in SQL Server 2005, a new tool that replaces SQL Server Enterprise Manager and SQL Server Query Analyzer is SQL Server Management Studio (SSMS). It has a lot of good stuff in it, one of them being the reports. SSMS reports provide a snapshot of your server status and […]

I blogged about my 2 failed attempts of silent / command line install of SQL Server 2005 September CTP. So I filed a bug here on MSDN. I am impressed that Microsoft responded very quickly, saying this is not a bug. Thanks to whoever closed the bug. That was a real quick response:) I will […]