Recent Posts
Don Hite
Return To Blog Listing
Tags: Break Time, By Request, Microsoft SQL Server, Odds & Ends, PowerShell, SMS 2003 SQL Queries, Vbs Scripts
Recent Posts Tagged With 'microsoft sql server'
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 (SP) 1 6.50.240 - SQL Serve...
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 to <&...
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. Msg 15281, Level 16, State 1, ...
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 2008. SQL Server x86 http://www....
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 default manila envelope color can be ch...
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 operators. New to SQL Serv...
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 media to the Program Files d...
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 2008. The CU1 package build number...
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 name and database name which will accomp...
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 an overview tour of the new fe...
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 can use a maximum of 4 ...
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 Generator you can create scripts to...
