Sign in
|
Join
|
Help
Don Hite at myITforum.com
Select Distinct
DateAdd
(D,+1,
GetDate
())
'Be Sure To Come Back Then too!'
This Blog
Home
Contact
About
Syndication
RSS
Atom
Comments RSS
Search
Go
Tags
Break Time
By Request
Client Health Monitoring
ConfigMgr 2007
HTML Applications
Microsoft SQL Server
MOM 2005
MOSS 2007
myITforum Community
Odds & Ends
Odds & Ends
OpsMgr 2007
Origins
PowerShell
SCE 2007
Server Technologies
SMS 2003
SQL Queries
Vbs Scripts
News
Sign Up For E-Mail Alerts When New Content Is Added To This Blog
Tag Categories:
Break Time
By Request
Client Health Monitoring
ConfigMgr 2007
HTML Applications
Microsoft SQL Server
MOM 2005
MOSS 2007
myITforum Community
Odds & Ends
Origins
OpsMgr 2007
PowerShell
Server Technologies
SMS 2003
SQL Queries
SCE 2007
VBS Scripts
Navigation
Site Home
Home
Bloggers List
Blogs
Photos
Downloads
Archives
June 2009 (5)
March 2009 (4)
February 2009 (12)
December 2008 (44)
November 2008 (48)
October 2008 (61)
September 2008 (57)
August 2008 (56)
July 2008 (49)
June 2008 (50)
May 2008 (56)
April 2008 (44)
March 2008 (71)
February 2008 (52)
January 2008 (33)
December 2007 (123)
November 2007 (68)
October 2007 (71)
September 2007 (68)
August 2007 (80)
July 2007 (87)
June 2007 (72)
May 2007 (89)
April 2007 (75)
March 2007 (62)
February 2007 (51)
January 2007 (61)
December 2006 (48)
November 2006 (51)
October 2006 (58)
September 2006 (49)
August 2006 (21)
July 2006 (43)
June 2006 (18)
May 2006 (14)
April 2006 (5)
Don's Links
E-Mail Don Hite
Don's myITforum Articles
Kansas City Regional Systems Management Users Group
RSS (Really Simple Syndication) Syndication Feed
Don Hite's Blog Catalog Page
Kansas City Regional Systems Management Users Group Blog
Visuals
I Want You
Visit myITforum
Bart Simpson Chalkboard
myITforum Links
Rod Trent's Blog
myITforum Downloads
myITforum Home Page
myITforum News Blog
myITforum User Blogs
myITforum Book Store
myITforum Columnists
myITforum Forums Page
myITforum User Groups
myITforum Wiki Service
myITforum Site News Blog
myITforum Daily Newsletter
myITforum Gear And Apparel
myITforum Newsletters Blog
myITforum Web Browser Toolbar
myITforum Branded News Reader
myITforum E-Mail Discussion Lists
myITforum Home Page Search
myITforum.com Polls
External Links
1E
Faqshop
LabMice
LearnSMS
SMS Utils
SMS Expert
Extended Tools
System Center Tools
Personal Pages
Phil Wilcock's - Farmer Phil's Diary
Duncan McAlynn's Destination: Ireland
Jarvis Davis
Don The Baptist
Blog To Blog
Anthony Clendenen
Dan Thomson
Garth Jones
Michael Mott
Rod Trent
Ron Crumbaker
Ying Li
Jason Scheffelmaer
Scott Moss
Mike Lucero
Matt Broadstock
John Nelson
Brian Tucker
Steve Thompson
Ronni Pedersen
Jason Sandys
Roger Zander
David Stein
myITforum Live Search Engines
myITforum Live Blog's Search
myITforum Live Home Search
myITforum Live Forum's Search
myITforum Live Articles Search
Browse by Tags
All Tags
»
Microsoft SQL Server
(
RSS
)
HTML Applications
MOM 2005
SMS 2003
SQL Queries
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
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:
Microsoft SQL Server
More Posts
Next page »