|
|
|
|
|
Total Hits: 24 | Today: 0
|
Author: Jasper Smith
|
Rating:
|
|

In this series of articles, I'll demonstrate how to use SMO (SQL Management Objects) to do a variety of common DBA tasks including Backups, Restores,Index Maintenance, Integrity checks and more. These are some of the operations available in the SMO database maintenance utility available on this site - ExpressMaint. In this article we will concentrate on how to perform restores using SMO in SQL2005. For information on how to build and compile a SMO application please review Getting Started with S...
|
|
|
|
Total Hits: 112 | Today: 0
|
|
Rating:
|
|

This step-by-step article discusses the steps you can use to change the SQL Server sa (system administrator) password...
|
|
|
|
Total Hits: 115 | Today: 0
|
Author: Carl Nolan
|
Rating:
|
|

SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition. The article then concentrates on XML support, covering XML data retrieval and manipulation, queries, and HTTP...
|
|
|
|
Total Hits: 176 | Today: 0
|
Author: Joe Chang
|
Rating:
|
|

Many production databases today are in the tens or hundreds of gigabytes in size. That size is not a problem for production hardware. However, developers generally like to work on their personal computers, including notebooks with limited disk capacity, so a 10-100GB database size is an issue. Furthermore, it can be impractical to transfer such large data files over the network on a regular basis, if working time is lost. For this reason, it is preferable to work on a smaller sized database with...
|
|
|
|
Total Hits: 402 | Today: 0
|
Author: Nils Bevaart
|
Rating:
|
|

As a SQL Server DBA, one of my tasks is to monitor the performance of our databases. Our primary database holds the data of over 18 million people. A web-based application queries the database with a variety of search options. When examining the performance of these queries, most performed very well. But on the other hand, a few queries have resulted in a time-out. One of the first steps in analyzing the time out problem was to find the search pattern used in the slow running queries. I found th...
|
|
|
|
Total Hits: 180 | Today: 0
|
|
Rating:
|
|

This article describes how to configure the SQL Server for .NET applications. By default, the SQL Server denies access to user accounts that have not explicitly been granted access to a database, a table, or a view. By default, ASP.NET applications run in the context of the ASPNET user account. Unless you permit access to the ASPNET user account, an ASP.NET application cannot read and cannot update data in an SQL Server database. This article describes the process that you can use to permit an A...
|
|
|
|
Total Hits: 276 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|

sp_readerrorlog can be used to read the SQL Server error logs from within T-SQL. If you call sp_readerrorlog without any parameters, it will display the current error log. You can go back to previous error logs, by specifying a number as the first parameter. So far so good. ...
|
|
|
|
Total Hits: 303 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|

This article discusses how to generate SQL scripts for repetitive tasks, using T-SQL ...
|
|
|
|
Total Hits: 319 | Today: 0
|
Author: Guy van den berg
|
Rating:
|
|

Index Tuning Wizard - The Problem of Automatic Index Selection. As if by magic…New to SQL Server 7.0 the Index Tuning Wizard is one of the many novel self-administrative features included in this release. Within this series of articles I'll take a look at the wizard, how best to use it and how to interpret its’ output....
|
|
|
|
Total Hits: 231 | Today: 0
|
Author: Krishnan M Kaniappan
|
Rating:
|
|

In this article I would like to discuss about the following two things: 1) About shrinking the transaction log. 2) Different ways of taking the database offline. ...
|
|
|
|
Total Hits: 301 | Today: 0
|
Author: Peter A. Bromberg
|
Rating:
|
|

If you have a discussion forum or other database - enabled service on your site that accumulates significant amounts of textual data, and you want to provide users with a powerful way to search this content based on words or sentences, then the SQL Server Fulltext query engine could be just the thing for you. ...
|
|
|
|
Total Hits: 461 | Today: 0
|
|
Rating:
|
|

This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server....
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: Brad McGehee
|
Rating:
|
|

Before you even begin building a SQL Server 2005 cluster, you must ensure that your network infrastructure is in place. Here's a checklist of everything that is required before you begin installing a SQL Server 2005 cluster. In many cases, these items are the responsibility of others on your IT staff. But it is your responsibility to ensure that all of these are in place before you begin building your SQL Server 2005 cluster....
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: extremeexperts
|
Rating:
|
|

Also called as RDB this is a new concept in SQL Server 2005 which I thought was worth taking a look at. In previous version of SQL Server 2000 whenever we had to upgrade a system defined object we had to drop and recreate. And rollback of the same was also something that we as DBA's had to break our heads. All the service packs have a disclaimer that states we backup our databases before we start the installation sequence . Even though I recommend it strongly, let us take a tour of how the new ...
|
|
|
|
Total Hits: 51 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|

I am working at an organization where I need to have access to my SQL Servers around the clock. I do not have a company laptop to check into the environment and troubleshoot issues directly so I am looking for alternatives to meet the need. We are on a tight budget so I wanted to find out what native tools are available. Do you have any suggestions for SQL Server tools to meet this 24X7 management need?...
|
|
|
|
Total Hits: 191 | Today: 0
|
Author: Michael Balloni
|
Rating:
|
|

Relational databases like Microsoft's SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data and relinquishes the lock. There are exceptions, but let's not go there....
|
|
|
|
Total Hits: 129 | Today: 0
|
Author: Brian Kelley
|
Rating:
|
|

This article will concentrate on the basic services under which SQL Server 2000 runs. By understanding how SQL Server operates and the permissions thereof, we can quickly narrow down on issues that will occur in a production environment. Also, we can help our NT administrators understand what they shouldn't stop and/or disable when SQL Server needs to be kept running. Ever have a system administrator shut down the SQL Server Agent service running backups by mistake? Not a pretty sight!...
|
|
|
|
Total Hits: 362 | Today: 0
|
|
Rating:
|
|

A poor database design can cripple an application, producing problems with redundancy, inaccuracy, consistency, and concurrency of your data. Normalization is a process that serves to reduce, if not eliminate, these problems with data. Since most businesses use 3rd normal form in the logical model, I’ll take you through 1st, 2nd, and 3rd NF’s....
|
|
|
|
Total Hits: 239 | Today: 0
|
|
Rating:
|
|

The starting point in normalizing the current database was to analyze the existing program and database. Because the program is old and has been updated many times there is no programmer available to discuss design issues. The new database design will be based on user input, the existing program, and the existing database....
|
|
|
|
Total Hits: 306 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|

In this article I am going to explain, how to track file growths, especially the database files. First of all, why is it important to track database file growth? Tracking file growth, helps you understand the rate at which your database is growing, so that you can plan ahead for your future storage needs. It is better to plan ahead, instead of running around when you run out of disk space, isn't it? So, how can we track file growths? There are a couple of ways....
|
|
|
|
|
|