Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, SQL Server 7 Rss

<< Newer    Items 41 to 60 of 389    Older >>
 

Moving Your Database to a New Server

As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.   Read more...
By Paul Mu 2006/11/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,501 reads

Monitoring File Sizes in SQL Server Part 4

Monitoring in the real world. Roy Carlson concludes his series on space monitoring for your SQL Servers with a real world example of how he found a problem and fixed it.   Read more...
By Roy Carlson 2006/11/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,638 reads

Monitoring File Sizes in SQL Server Part 3

Trending the size data for your databases can be crucial when ordering new hardware or just ensuring that you can handle the load. In Part 3, Roy Carlson looks at how you get the sizes needed for your instances into Excel and generate a chart for trending of this important piece of performance data.   Read more...
By Roy Carlson 2006/11/08 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,889 reads

Monitoring File Sizes in SQL Server Part 2

Continuing with his series on monitoring space, Roy Carlson looks at checking the space in a folder to be sure your SQL Server databases never run out of storage.   Read more...
By Roy Carlson 2006/11/07 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 6,972 reads

Monitoring File Sizes in SQL Server Part 1

Monitoring the file sizes and free space on your SQL Server can be done in a number of ways, but it needs to be done or you will get a phone call when you least expect it. In an interesting read, Roy Carlson brings us a great way with code and reporting to setup your own monitoring system.   Read more...
By Roy Carlson 2006/11/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,662 reads

SQL Server Backup Crib Sheet

It's small and neat but it might just save your data...Robyn Page's crib sheet tells you everything you wanted to know about SQL Server backup but were afraid to ask.  Read more...
By Additional Articles 2006/10/20 | Source: Red-Gate | Category: administration
Rating:  Rate this |   Briefcase | 4,811 reads

Querying System Tables

It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. Raj Vasant brings us a look at some of the information that you can get by directly querying the system tables and explains what is stored in a number of them, including gathering information about computed columns.   Read more...
By Vasant Raj 2006/10/20 (first published: 2005/06/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,199 reads

Low-Cost High Availability: Simple Database Monitoring in a Windows En

The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding.   Read more...
By Additional Articles 2006/10/18 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 3,493 reads

How to Schedule a SQL Server Database Creation Script

Scripting out your SQL Server 2000 objects is useful in any number of ways. You can save off the scripts for version control, generate the scripts needed to migrate to new hardware or a new environment, or just package up your application for deployment. Jon Reade brings us a look at the SCPTXFR utility, which can prove very valuable in managing your scripts.   Read more...
By Jon Reade 2006/10/13 (first published: 2005/04/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,950 reads

Managing DTS packages - Editing, Scheduling, and Viewing Package Logs

In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.   Read more...
By Haidong Ji 2006/10/06 (first published: 2003/01/02) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,640 reads

Exploring SQL Server 2000 Configuration Properties

The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.   Read more...
By Dale Elizabeth Corey 2006/09/29 (first published: 2004/09/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,633 reads

Deploying Scripts To Multiple Instances

Most DBAs manage multiple SQL servers, each handling different needs for your business. Even with the diverse uses for different servers, there is often the need to deploy the same scripts to all servers for various purposes. Author Joe Doherty brings us his scripts and technique for executing a script across multiple servers.   Read more...
By Joe Doherty 2006/09/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,923 reads

Identifying Unused Objects in a Database

Longtime author Leo Peysakhovich answers one of the most common questions seen in discussion areas around the world: how do you identify unused objects?   Read more...
By Leo Peysakhovich 2006/09/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 22,243 reads

Copying Database Backups to an Alternative Location

Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.  Read more...
By Additional Articles 2006/09/08 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 4,309 reads

Controlling Jobs

Have you ever needed to build a job that could run within a certain period of time? Those long maintenance operations, like index rebuilds, need to fit within certain windows of time. New author Joe Doherty brings us a great technique for ensuring those jobs do not run over into your business day and impact normal operations.   Read more...
By Joe Doherty 2006/09/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,282 reads

Alternative to the Microsoft MMC Console

Are you frustrated by the limitations of the MMC console when managing dozens or hundreds or servers? The way Enterprise Manager is fitted into the framework can be a problem for DBAs with lots of servers. Jereme Guenther brings us a technique for his own console that solves some of the limitations of MMC.   Read more...
By Jereme Guenther 2006/07/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,878 reads

Analyzing Disk Capacity for SQL Server

Ensuring that your disk subsystem performs well and does not run out of space is a balancing act that many DBAs learn over time through trial and "out of space" errors. New author Arindam Banerjee takes a look at some of the things to consider when capacity planning.   Read more...
By Arindam Banerjee 2006/07/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,382 reads

The Basics of Sizing a SQL Server Database

Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.   Read more...
By Brian Knight 2008/08/01 (first published: 2001/07/25) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,948 reads

Using XP_EXECRESULTSET To Obtain Database Size Information and More

Have you ever used XP_RESULTSET in SQL Server? If you're like most DBAs, this procedure is rarely used and can be a little complicated to setup. New author J. T. Shyman brings us a look at just how useful this command can be in executing a command on every database.   Read more...
By J. T. Shyman 2006/06/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,666 reads

Attach and Detach..Again

Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!   Read more...
By Andy Warren 2006/06/23 (first published: 2002/04/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,201 reads
<< Newer    Items 41 to 60 of 389    Older >>
 
Tags
configuring (63)    
t-sql (56)    
miscellaneous (52)    
strategies (35)    
security (34)    
programming (30)    
monitoring (27)    
sql server 2005 (26)    
performance tuning (20)    
backup / restore (16)    
sql server 6.5 (16)    
advanced querying (13)    
database design (12)    
visual basic 6 (12)    
installation (11)    
disaster recovery (dr) (10)    
replication (10)    
stored procedures (10)    
dts (9)    
sql-dmo (8)    
best and worst practices (7)    
indexing (7)    
news (7)    
availability (6)    
worst practices (6)    
ado (5)    
.net (4)    
basics (4)    
naming standards (4)    
career (3)    
distributed queries (3)    
service packs (3)    
state of the business (3)    
triggers (3)    
auto-growth (2)    
automated dba (2)    
data file management (2)    
data warehousing (2)    
logins (2)    
maintenance (2)    
maintenance and management (2)    
product reviews (2)    
reviews (2)    
routine database growth (2)    
routine growth (2)    
storage (2)    
system development life cycle (2)    
user defined function (udf) (2)    
utility (2)    
advanced (1)    
analysis services (ssas) (1)    
best practices (1)    
bugs (1)    
data types (1)    
databases (1)    
english query (1)    
grant (1)    
olap server (1)    
openxml (1)    
other (1)    
permissions (1)    
rants (1)    
role (1)    
script (1)    
scripting (1)    
sql puzzles (1)    
system databases (1)    
updategrams (1)    
user (1)    
xml (1)    
xsl (1)