sql server online help

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Handle errors in the data tier with SQL Server

Handling exceptions in your .NET application code is a simple and straightforward process with try/catch code blocks, but you can monitor exceptions on the database tier as well. We examine error handling in your database code with SQL Server and T-SQL. Developers work hard to graciously handle exceptions so...

Tags: Microsoft SQL Server Transact-SQL, Microsoft SQL Server, Databases, Tony Patton, .NET, server, RAISERROR statement, database, .NET Newsletter, Parameter, Microsoft .NET, Severity, Error, SQL Server Online Help, ROLLBACK TRANSACTION Statement, Storage, Enterprise Software, Software, Data Management, Hardware

Technical articles 2006-06-06

Handle errors in the data tier with SQL Server

Developers work hard to graciously handle exceptions sousers don't have to worry about the arcane system error messages. For thisreason, exception handling is a standard part of every .NET application. Thetry/catch block allows you to catch exceptions and control applicationexecution from that point. Many errors occur during database interaction, but...

Tags: database, Microsoft SQL Server, Microsoft SQL Server Transact-SQL, server, Tony Patton

Technical articles 2006-06-06

Additional Resources

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...

Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management

White papers 2001-07-19

Transferring SQL Server logins between servers or instances

I recently discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. [poll=11] I...

Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren

Blog posts 2007-09-25

Some resources on SQL Server 2005

Here are some helpful resources on SQL Server 2005 for those who are evaluating it and/or preparing for it: Microsoft's SQL Server TechCenter MSDN's SQL Server Development Center  SQL Server 2005 downloads SQL Server 2005 Express Edition the free version of SQL Server Free Virtual...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Jason Hiner

Blog posts 2005-11-11

Fast Track DBA

I am looking for a "Boot Camp" for SQL DBA. I have some knowledge of it but I am trying to gain more experience and it helps that my company is going to pay for it. I am looking for something that is a 2 day Session ...any IdeasSQL ServerI...

Tags: Programming languages, Databases, jabney@..., SQL, server

Discussion threads 2005-06-14

SQL Building Blocks and Server Settings

This hefty (200-page) chapter, taken from the comprehensive Transact-SQL Desk Reference: For Microsoft SQL Server, looks at the building blocks that database designers and users have available for creating and modifying database objects and data. The well-organized information and liberal use of examples make this a terrific resource to use...

Tags: Microsoft SQL Server, Server, SQL, Prentice Hall Inc., Microsoft Corp., Databases, Storage, Enterprise Software, Software, Data Management, Hardware

Book chapters 2005-03-29

SQL Training Options

Hello,I need to take a SQL administrator class and I wanted to get some feedback on some of the training companies that are out there. So far I have narrowed my search to New Horizons, Global Knowledge, Hands On Technology Transfer, and National Seminars. I've had good experiences with...

Tags: Programming languages, Databases, dbell@..., SQL

Discussion threads 2007-07-23

EMS SQL Manager 2008 for SQL Server (zip)

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML...

Tags: Microsoft SQL Server, Server, SQL, SQL Manager 2005, Databases, Enterprise Software, Programming Languages, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

Make the jump from SQL Server 2000/7 to SQL Server 2005 with these notes and tips

There are a number of changes you should understand before you begin planning the leap from SQL Server 2000 or SQL Server 7 to the recently released SQL Server 2005. Migrating from SQL Server 2000 or SQL Server 7 to SQL Server 2005 is not a project...

Tags: Microsoft SQL Server, Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management

Download resources 2006-02-07

Microsoft SQL Server Query Processor Internals and Architecture

This article examines how Microsoft SQL Server queries are processed on the client, how the various clients interact with SQL Server, and what SQL Server does to process clients' requests. Hopefully, knowing how SQL Server processes your queries, and how and when it compiles them or recompiles them, will allow...

Tags: Processor, Microsoft SQL Server, Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

White papers

Best Practices for Upgrading to SQL Server 2005

It is not difficult to move from SQL Server 7 or SQL Server 2000 to SQL Server 2005. The key to any successful upgrade is preparation and researching potential problems. Talk to stakeholders, level with them, and get their support, and the upgrade will be a success. SQL Server 2005...

Tags: Microsoft SQL Server, Best Practice, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management

White papers 2008-02-19

Teratrax Performance Monitor (msi)

Monitor SQL Server performance on all enterprise servers from a single interface. Analyze and chart real-time and historical execution of SQL code across users and applications. Isolate SQL Server hardware utilization and correlate it with SQL statements and SPs. Be the first to know about slow and failed SQL Server...

Tags: Microsoft SQL Server, SQL, Databases, Enterprise Software, Software, Data Management

Software downloads 2006-06-16

EMS SQL Manager 2008 Lite for SQL Server (zip)

EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only it's basic functionality. EMS SQL Manager Lite for SQL Server is...

Tags: Microsoft SQL Server, Server, SQL, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 Service Pack 4 (Intel) (exe)

SQL Server 7.0 Service Pack 4 (SP4) addresses specific issues that were discovered in SQL Server 7.0 and Microsoft Data Engine MSDE 1.0 since their ship date. Because SQL Server Service Packs are cumulative, SP4 includes all fixes from previously released Service Packs, and can be applied to an original...

Tags: Microsoft SQL Server 7.0, Microsoft SQL Server, Microsoft Data Engine, Service Pack, Microsoft Corp., Intel Corp., SQL Server 7.0 Service Pack 4, Databases, Enterprise Software, Software, Data Management

Software downloads 2002-08-24

SQL 2000 server/ODBC

Hello. I have installed SQL server 2000 personal edition on a desktop PC to establish a local SQL server for databases connecting via ODBC data source. When I attempt to SQL server verify authenticity of the databases login id, it tells me "connection failed"...SQL server error 11001...SQL...

Tags: hardware, Microsoft SQL Server, ODBC, rcelentano@..., server, SQL

Q&A 2005-04-26

Online Event Software Gets Disaster Recovery With SQL Server 2005 Database Mirroring

ServiceU helps organizations ranging in size from small churches to Fortune 500 companies operate concerts, conferences, and other events with its online event management software, including ticket sales, event registration, and facility and resource scheduling. The company needed to ensure high availability of its services, and increase its scalability to...

Tags: Microsoft SQL Server, Mirroring, Microsoft SQL Server 2005, ServiceU, Disaster Recovery, Databases, Enterprise Software, Data Management, Software

Case studies

SQL Server 2005 Security Best Practices - Operational and Administrative Tasks

This paper covers some of the operational and administrative tasks associated with Microsoft SQL Server 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system. Each topic describes a feature and best practices. For additional information on the specifics...

Tags: Microsoft SQL Server, Best Practice, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management

White papers 2007-03-01

What's New in SQL Server Agent for Microsoft SQL Server 2005 Beta 2

This paper provides an overview of new features for the SQL Server Agent job scheduling service for Microsoft SQL Server 2005 Beta 2. SQL Server Agent for SQL Server 2005 Beta 2 provides a more robust security design than earlier versions of SQL Server. This improved design gives system administrators...

Tags: Agent, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Real Estate, Enterprise Software, Software, Data Management, Business Operations

White papers 2004-09-02

Reliable and Scalable Technology Becomes Mission-Critical Tool for World Leading Online Grocery Retailer

Tesco.com is the world's largest online grocery retailer. It has several million registered customers and at its busiest times, processes 3,000 orders an hour. When Tesco launched the online service, as a pilot in 1997, it wanted a technology infrastructure that didn't require huge investment and scaled as the operation...

Tags: Tesco, Microsoft SQL Server, Retail Company, Microsoft SQL Server 2000, Microsoft Corp., Grocery, Food & Beverage, Retail, Databases, Manufacturing, Enterprise Software, Software, Data Management

Case studies