Tag Archives: SQL Server

Export and Email SQL View as CSV Spreadsheet Using Powershell

I’ve been looking for an easy way to export and email the query results from a SQL View as a Spreadsheet (CSV). I’ve finally found a decent solution on Windows using tools provided with either the operating system or the … Continue reading

Posted in Database | Tagged , , | 1 Comment

SQL Server System Rename

On the surface, a SQL Server system rename may appear simple. You rename the underlying Windows box and SQL will automatically use the new name. While that is true for many features in SQL server, there are quite a few … Continue reading

Posted in Database | Tagged | Leave a comment

SQL Server Max Server Memory

It is common to run an application server (like Tomcat, IIS, etc) on the same system as a SQL Server database for small deployments. In this case, the standard memory-hogging behavior of SQL Server may adversely impact the performance of … Continue reading

Posted in Database, System Administration | Tagged , | Leave a comment

SQL Server Default Trace

Microsoft SQL Server database administrators have many excellent logging and debugging tools available to them. Among these is the “default trace.” The SQL Server database engine ships with a special trace enabled and logging *.trc or “trace” files to the … Continue reading

Posted in Database | Tagged , , , , | Leave a comment

SQL Server Emergency Mode Repair

SQL Server databases can become badly damaged if a storage system crashes or write operations are not delivered to the disk. In order to recover from database corruption, the best remedy is a good backup and recovery solution. Popular systems … Continue reading

Posted in Database | Tagged , , , , | Leave a comment

SQL Server Maintenance Plan Change Owner

If your SQL Server 2005 Maintenance Plan (backup, etc) jobs start failing for no apparent reason, check the following. Is the original creator / owner of the Maintenance Plan still a valid Windows or Active Directory user? Does the original … Continue reading

Posted in Database | Tagged , , , , | Leave a comment

JDBC Connectivity for SQL Server

Java programs need connectivity to Microsoft SQL Server, and a popular open source JDBC driver is available to get the job done. I recommend the JTDS driver, find the download and documentation online at http://jtds.sourceforge.net/. What does TDS stand for? Tabular … Continue reading

Posted in System Administration | Tagged , , | Leave a comment

SQL Express Default Instance

As of SQL Express 2008 R2, installing a default instance (not named) requires manually naming the instance to “MSSQLSERVER” for a functioning server on the default port. This problem is documented at http://www.kendalvandyke.com/2009/01/installing-sql-express-2008-as-default.html – bug still exists in the SQL 2008 R2 … Continue reading

Posted in Database | Tagged | Leave a comment