-
Fix Page 404 Error in WordPress
If 1. You use WordPress; 2. You have permalink turned on; 3. You just wrote a page using WordPress but when you view the page, you get 404 page not found error; Then 1. Go to Options->Permalinks; 2. Click Update Permalink Structure. If your .htaccess cannot be updated through the web interface (very likely), copy…
-
Server consolidation and virtualization with Sql Server 2005
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…
-
Change SQLCMD default editor
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 will be fun
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…
-
SQL Server Management Studio Reports — Potential Management and Permission Issues
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…