sql server management

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

10 things you should know about SQL Server 2005 Management Studio

SQL Server 2005 Management Studio is a phenomenal advance over the tools provided with SQL Server 2000. Check out the improvements in SQL Server Management Studio, which makes it easier to locate errors in your code and allows you to keep tabs on your reports. By Arthur Fuller and...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, SQL Server Management Studio, Databases, Guest Contributor, Enterprise software, SQL Server Management, server, SQL Server Newsletter, Solution, Tool, SQL Server 2005 Management Studio, SQL Server Integration Services, Software, Data Management

Technical articles 2006-02-03

Additional Resources

The Guru's Guide to SQL Server 2000 Memory Management Intervals - Level 300

This presentation reveals the secrets of how SQL Server manages memory resources internally. It will discus the SQL Server memory management architecture and then looks at its implementation in detail. This webcast discusses the various types of Windows memory resources and how SQL Server makes use of them. See the...

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

Webcasts

The Database Utility for SQL Server: A Highly Available, Flexible, Simple Approach to SQL Server Consolidation

Recent years have seen an explosion in the use of SQL Server. The proliferation of SQL Server and the cost-effective industry-standard servers on which it runs has brought tremendous benefits. Yet, this very success has also created ongoing problems for administrators responsible for its deployment and management. This whitepaper outlines...

Tags: Hewlett-Packard Co., Microsoft SQL Server, Consolidation, Databases, Enterprise Software, Servers, Software, Data Management, Hardware

White papers 2007-04-24

Introducing the New SQL Server Management Studio-Level 100

This webcast provides an overview of the new tools in SQL Server 2005, including SQL Server Management Studio, Database Tuning Advisor and SQLCMD. It also explains the enhancements that have been made to existing tools such as Profiler and SQL Agent.

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

Webcasts

MSDN Webcast: Introducing the New SQL Server Management Studio - Level 100

Get an overview of the new tools in SQL Server 2005, including SQL Server Management Studio, Database Tuning Advisor and SQLCMD. Also see the enhancements that have been made to existing tools such as Profiler and SQL Agent.

Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Server, Databases, Productivity, Enterprise Software, Software, Data Management

Webcasts

Editing Transact-SQL Code in SQL Server 2005 Beta 2

Management Studio is the primary tool for developing Transact-SQL queries in Microsoft SQL Server 2005 Beta 2. This paper introduces you to the Management Studio Transact-SQL editing facilities, highlighting some of its more interesting and compelling new features for Transact-SQL development. This paper explains how Management Studio differs from, and...

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

White papers 2004-10-01

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

Managing SQL Server Express With SQL Server 2005 Management Studio Express Edition

SQL Server 2005 Management Studio Express Edition SSMSE provides the database developer and administrator with a robust set of tools for working with Microsoft SQL Server Express Edition. Based on the same technology and functionality as that in SQL Server Management Studio, SSMSE uses Microsoft Visual Studio .NET 2005 user...

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

White papers 2006-03-01

Understanding Microsoft Internal Storage Management

Microsoft SQL Server is built in such a way that it can be managed by Database Administrators DBA with a wide range of skills and experience. SQL Server masks the complexity of managing a Relational Database Management System RDBMS to make it more appealing to administrators with various skill sets....

Tags: Database Administrator, Storage Management, Microsoft SQL Server, Storage, Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

White papers 2005-01-01

How do I... Install SQL Server 2005 Express Edition and SQL Server Management Studio Express?

With the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has entered the small, free database market with a splash trumping even their own Microsoft SQL Desktop Edition. SQL Server Management Studio Express -- a full-featured management tool comparable to the...

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

Download resources 2006-08-04

MS SQL Maestro (exe)

MS SQL Maestro is a powerful Windows GUI solution for SQL Server administration and database management. MS SQL Maestro supports for SQL Server 2000/2005/2008 versions, and all of the most important SQL Server features, including XML data type and XML indexes support, availability of schemas, support for CRL Procedures, synonyms,...

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

Software downloads 2008-01-15

ESG Lab Report: HP PolyServe Software for Microsoft SQL Server White Paper - Highly Available SQL Server Consolidation

Database applications are increasingly being deployed on cost-effective industry-standard servers using Microsoft SQL Server. Third-party application and in-house developers have embraced SQL Server due to its low cost and ease of deployment. This has produced a phenomenon in recent years known as SQL Server sprawl. With each database application typically...

Tags: PolyServe Inc., Hewlett-Packard Co., Microsoft SQL Server, Consolidation, Microsoft Corp., Databases, Enterprise Software, Servers, Software, Data Management, Hardware

White papers 2007-11-01

Upgrading Microsoft Dynamics CRM 3.0 to Use a Microsoft SQL Server 2005 Database

Microsoft Dynamics CRM 3.0 provides a flexible and scalable customer relationship management application for the company. Microsoft CRM uses Microsoft SQL Server database software for its data storage and integrates tightly with Microsoft SQL Server Reporting Services to provide some of the Microsoft CRM reporting capabilities. Although Microsoft CRM supports...

Tags: Microsoft Dynamics, Microsoft SQL Server, Microsoft Corp., Microsoft CRM, Microsoft SQL Server 2005, CRM, Microsoft Dynamics CRM 3.0, Enterprise Software, Databases, Customer Relationship Management (CRM), Software, Data Management

White papers 2006-09-22

SQL Server Management Studio Express and Backwards Compatibility

I downloaded the SQLServer2005_DTS.msi install and ran it on a workstation that has Microsoft SQL Server Management Studio v.9.00.1399.00installed and I was able to see the legacy Sql Server 2000 packages on another server. Works Great! My Issue is w

Tags: programming, sql server, software, business@..., Microsoft SQL Server Management Studio, Microsoft SQL Server, DTS, server

Discussion threads 2006-11-30

Changing the name of your SQL Server

Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to perform the change. 1. Open SQL...

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

Blog posts 2007-09-22

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

SQL Server 2008 Manageability

Microsoft SQL Server 2008 builds on the management capabilities of previous versions and provides a variety of tools and frameworks to help to manage the enterprise data environment. The comprehensive management automation capabilities of SQL Server 2008 reduce the administrative overhead that is required to maintain data services and ensure...

Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Change Management, Databases, Enterprise Software, Tools & Techniques, Management, Software, Data Management

White papers 2008-01-01

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

EMS SQL Management Studio for SQL Server (zip)

EMS SQL Management Studio is a complete solution for database administration and development. SQL Studio unites all must-have tools that focus on the most critical database management tasks in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or...

Tags: Microsoft SQL Server, Server, SQL, EMS SQL Management Studio, SQL Studio, Databases, Storage, Enterprise Software, Software, Data Management, Hardware

Software downloads 2007-01-19

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