Browse by Tags

All Tags » Microsoft SQL Server (RSS)
Thursday, February 05, 2009 12:55 PM

SQL Server Versioning Information

Here you will find SQL Server 6.5 to SQL Server 2008 Version information to January 2009. SQL Server 6.5 6.50.201 - SQL Server 6.5 Release To Manufacturing (RTM) 6.50.213 - SQL Server 6.5 Service Pack...
Posted by dhite | with no comments
Filed under:
Monday, December 22, 2008 9:37 AM

SQL Query Logical Operators

Provided here is a table containing the SQL logical operations with a brief description of each. Operator Description = Equal to != or <> Not equal to > Greater than >= Greater than or equal...
Posted by dhite | with no comments
Filed under:
Saturday, December 06, 2008 8:17 AM

SQL Server Blocked Access To Procedure Sys.Xp_Cmdshell Error Resolution

If you receive an error similar to the one below it means that the extended procedure Command Shell (CmdShell) is not enabled. This is by default in SQL 2005 and can be easily rectified tow different ways...
Posted by dhite | with no comments
Filed under:
Sunday, November 16, 2008 7:43 PM

The SQL Server RML Utilities For SQL Have Been Updated To Include SQL Server 2008

The Replay Markup Language (RML) Utilities for SQL Server has been updated this week and are available for download from the links below. The RML utilities can be used for SQL server 2000, 2005 and now...
Posted by dhite | with no comments
Filed under:
Monday, November 10, 2008 5:49 PM

Modifying The SQL 2008 Server Management Studio Query Connection Status Bar Default Color

In SQL Server 2008 the new Connection Status Bar at the bottom of the Query editor window shows you your connection status as well as information about your query such as the number of Rows returned. The...
Posted by dhite | with no comments
Filed under:
Sunday, November 02, 2008 3:17 PM

SQL Server 2008 New Compound Assignment Operands

An operator or operand is a symbol specifying what action is performed on an expression. SQL Server uses several categories such as Arithmetic operators, Assignment operators, Logical operators and Comparison...
Posted by dhite | with no comments
Filed under:
Sunday, October 12, 2008 3:19 PM

Rebuilding or Restoring The SQL Server 2008 Master Database

Here you will find information on how to rebuild the SQL Server 2008 Master Database. One of the improvements to SQL Server 2008 is that when you install it the SQL databases are copied from the installation...
Posted by dhite | with no comments
Filed under:
Sunday, October 05, 2008 2:42 PM

SQL 2008 Cumulative Update 1 For SQL Server 2008 Download

The Cumulative Update 1 (CU1) has been released for SQL Server 2008 and includes several hot fixes for the Microsoft SQL Server 2008 issues that have been fixed since the initial release of SQL Server...
Posted by dhite | with no comments
Filed under:
Sunday, September 28, 2008 1:47 PM

Creating A SQL Server Auto Logon Desktop Shortcut

In SQL Server 2005 there is no native auto logon to automatically logon however you can create a taskbar or desktop shortcut and pass the trusted connection command line switch as well as the SQL server...
Posted by dhite | with no comments
Filed under:
Sunday, September 14, 2008 3:51 PM

SQL 2008 TechNet Webcasts

Provided here are links to Microsoft TechNet SQL 2008 Webcasts available in Windows Media Player (WMA), Zune and MP3 format. SQL-300 What's New In Microsoft SQL 2008 In this session, we will go through...
Posted by dhite | with no comments
Filed under:
Sunday, September 07, 2008 12:23 PM

SQL Server 2008 Memory Support

In Microsoft SQL Server 2008 the Standard, Enterprise, Developer and Web editions can use whatever the Operating Systems maximum allowed memory is. Windows Server 2003 Windows Server 2003 Standard Edition...
Posted by dhite | with no comments
Filed under:
Sunday, August 24, 2008 1:04 PM

Fabio Cozzolino’s SQL Script Generator 0.1.3123

This is a freeware download of the SQL Script Generator by Fabio Cozzolino. SQL Script Generator is a tool designed to create or generate Insert and Update statements into SQL scripts. With SQL Script...
Posted by dhite | with no comments
Filed under:
Sunday, August 17, 2008 3:28 PM

Microsoft SQL Server 2008 Final Release Editions Information

Here you will find information describing the various Release Candidate 0 (RC0) Microsoft SQL Server 2008 Editions as Microsoft SQL Server 2008 was released to manufacturing earlier this month and is currently...
Posted by dhite | with no comments
Filed under:
Sunday, August 10, 2008 8:32 AM

SQL Server 2008 32-Bit Version Upgrade Paths

Provided here are the Microsoft SQL Server 2008 32-Bit version upgrade paths for SQL Server 2008 Standard and SQL Server 2008 Enterprise. The following 32-Bit versions can be upgraded to either the SQL...
Posted by dhite | with no comments
Filed under:
Sunday, August 03, 2008 3:11 PM

SQL Server Wiki – Major Release Version Information

Provided here is a Microsoft SQL Server Wiki chart showing the release name, version number, year of release and code name (if any) for the major release versions of Microsoft SQL Server from Version 1...
Posted by dhite | with no comments
Filed under:
Sunday, July 20, 2008 8:22 AM

Installing SQL Server 2005 On Windows Server 2008

In order to install Microsoft SQL Server 2005 on a Microsoft Windows Server 2008 you must have SQL Server 2005 Service Pack (SP) 2 installed. To install Microsoft SQL Server 2005 on Windows Server 2008...
Posted by dhite | with no comments
Filed under:
Sunday, July 13, 2008 8:18 AM

The Microsoft SQL Server 2008 RC0 Books Online Download

The Microsoft SQL Server 2008 RC0 Books Online (BOL) is now available for download from Microsoft at the link below. SQLServer2008_BOL.msi Download: http://go.microsoft.com/?linkid=9187951
Posted by dhite | with no comments
Filed under:
Sunday, June 29, 2008 7:18 AM

SQL Server 2008 RC 0 Has Been Released

Microsoft SQL Server 2008 Release Candidate (RC) 0 has been released and is available for download to TechNet Plus and MSDN subscribers. TechNet Plus http://technet.microsoft.com/en-us/subscriptions/downloads...
Posted by dhite | with no comments
Filed under:
Sunday, June 01, 2008 7:35 AM

SQL 2005 Extended Stored Procedure CmdShell Turned Off Error Message

If you attempt to execute a command using the SQL Extended Stored Procedure (XP) CmdShell (Command Shell Interface) using a script such as the one shown below: Exec Master .. Xp_CmdShell CommandLine You...
Posted by dhite | 1 comment(s)
Filed under:
Monday, May 26, 2008 7:38 AM

Opening The SQL Server Management Studio From The Command Line

Here you will find information on how to start the SQL Server Management Studio (SSMS) from a shortcut or from the command line. The following will open the SSMS by using Windows Authentication and will...
Posted by dhite | with no comments
Filed under:
Sunday, May 18, 2008 7:24 AM

Freeware Microsoft SQL Server Centric .NET Code Generator

The SQL Server Centric .NET Code Generator (OlyMars) is a freeware release by Pascal Belaud of Microsoft in France and is designed to perform the following: SQL Server Centric .Net Code Generator (code...
Posted by dhite | with no comments
Filed under:
Sunday, May 11, 2008 7:59 AM

Changing Your SQL 2005 Server Authentication Mode

Here you will find the steps necessary to change your SQL 2005 Authentication mode manually on the fly as opposed to scripting the process. Follow the steps below to change your server’s authentication...
Posted by dhite | with no comments
Filed under:
Sunday, May 04, 2008 7:09 AM

SQL Developer 2.3.0 Released

SQL Developer is a database administration and query tool that provides a single consistent interface for various databases. Visually navigate through your database structure, create and execute SQL queries...
Posted by dhite | with no comments
Filed under:
Sunday, April 20, 2008 7:15 AM

SQL Server 2008 Versions

Here you will find information that will help you decide what version of Microsoft SQL Server 2008 you will need to fit your needs. Enterprise Full featured version including both the core database engine...
Posted by dhite | with no comments
Filed under:
Sunday, April 13, 2008 7:42 AM

Ready To Migrate Or Upgrade To SQL 2005 ?

If you are still running Microsoft SQL server 2000 or even SQL Server 7.0 now is the time to upgrade to SQL Server 2005 if at all possible. Sooner or later you will have to make the upgrade as all of the...
Posted by dhite | with no comments
Filed under:
Sunday, April 06, 2008 7:52 AM

Codeplex SQL 2005 Service Manager

This release of the standalone SQL 2005 Service Manager version 1.0.0.12 is designed for running on Windows XP, Windows 2003 and Windows 2008. There is also a Windows Vista version as well as a separate...
Posted by dhite | with no comments
Filed under:
Sunday, March 30, 2008 7:41 AM

PssDiag Diagnostics Manager Utility For SQL Server 7.0 And SQL 2000

The PssDiag Data collection utility is a Microsoft Product Support Services (PSS) diagnostic data collector tool for Microsoft SQL Server used by PSS engineers to collect diagnostic data from end user...
Posted by dhite | with no comments
Filed under:
Sunday, March 16, 2008 8:39 AM

SQLCAT.com

The Microsoft SQL Customer Advisory Team (CAT) has had a great Blog page over on MSDN: http://blogs.msdn.com/sqlcat and now they have a great on hosted by Telligent the Makers of out very own Community...
Posted by dhite | with no comments
Filed under:
Sunday, March 02, 2008 8:15 AM

SQL 2005 Sever Node Reports

In the SQL Server Management Studio (SSMS) using the object explorer you can view several predefined reports showing you a number of things about your server such as activity and performance information...
Posted by dhite | with no comments
Filed under:
Sunday, February 24, 2008 2:56 PM

Exporting And Importing SQL 2005 Registered Server Information

Here you will find the steps necessary to export and then import SQL 2005 registered server information from one database server to another. 1. From the “Registered Servers” window (CTRL+ALT...
Posted by dhite | with no comments
Filed under:
More Posts Next page »