SQL Server

warning: Creating default object from empty value in /var/www/html/modules/taxonomy/taxonomy.pages.inc on line 34.

What is SQL and What is the SQL Server Management Studio?

| November 13, 2013

SQL Server Management Studio: A Bold Environment for Developers & Administrators

Computer languages are complicated, requiring in-depth knowledge of the programming trade for most people to master. As with any language, an extra layer of complexity is involved when working with different scripting dialects. This is where SQL and the SQL Server come in, serving to unify these languages, in a sense. The SQL Server Management Studio makes the experience as stress-free as possible.

Shrinking an MS SQL Server Transaction Log

| October 6, 2010

Note: While the information below specifically pertains to SQL Server 2005, the concept is the same for both version 2000 and 2008.

Shinking an MS SQL Server 2005 transaction log may be necessary if the log file grows too large due to missed backups or an extended period of high database activity. The transaction log backup will clear the log out but its size remains until the administrator manually performs a shrink operation.