|
|
|
|
|
| | Total Hits: 110 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| | 
My job function is a Network Administrator, not a SQL Server DBA or Developer, but I work with SQL Server on a regular basis. I could use some pointers to improve my skills. What would be a good SQL Server primer for me? What are some high level SQL Server topics that I should be aware of for my regular tasks? Where can I get some additional information to brush up on my skills?... |
| | Total Hits: 310 | 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: 119 | 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: 298 | 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: 217 | 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: 547 | 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: 129 | Today: 0 | Author: Brian Knight | Rating: |
| |
Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.... |
| | Total Hits: 238 | 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: 484 | 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: 373 | 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: 409 | 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.... |
| | Total Hits: 395 | Today: 0 | Author: Narayana Vyas Kondreddi | Rating: |
| |
This article discusses how to generate SQL scripts for repetitive tasks, using T-SQL
... |
| | Total Hits: 511 | 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: 615 | Today: 0 | Author: Divya Kalra &Narayana Vyas Kondreddi | Rating: |
| |
This article explains best practices for system administration in a Microsoft SQL Server 7.0 / 2000 environment, including regular maintenance tasks.
... |
| | Total Hits: 478 | Today: 0 | Author: Andy Warren | Rating: |
| |
In this article I'd like to continue that discussion by looking at four of the fixed database roles; db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter.... |
| | Total Hits: 1413 | Today: 0 | Author: Randy Dyess | Rating: |
| |
Trace flags are used to temporarily enable or disable specific database functions allowing you to change default database behavior or to observe hidden database behavior and will remain in effect until they are either manually turned off or SQL Server is restarted. Keep in mind that most trace flags are undocumented and Microsoft can and will change the behavior of the flag between SQL Server versions, service packs or hotfixes.... |
| | Total Hits: 353 | Today: 0 | Author: Andy Warren | Rating: |
| |
In that article I outlined a "trick" you can use if the new server will have the same logical drive configuration as the old one. If the logical drive configuration is different or you only want to move a portion of your files, usually the easiest way is to detach them from the original server and then attach to the new one, which gives you the chance to change the physical locations of the files for each database. The downside to that is that if you have a lot of databases to move, it gets very... |
| | Total Hits: 359 | 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: 378 | Today: 0 | Author: Brad M. McGehee | Rating: |
| |
The purpose of this article is to show you how to install SQL Server 2000 Enterprise Edition onto a Windows 2000, two-node cluster using an Active/Passive configuration. Installing SQL Server 2000 clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL Server 2000, and time.
... |
| | Total Hits: 3 | Today: 0 | Author: Microsoft Press | Rating:  |
| |
Over the years, an increasing number of organizations have turned to Microsoft SQL Server because it embodies the Microsoft Data Platform vision to help organizations manage any data, at any place, and at any time. The biggest challenges organizations face with this increase of SQL Server installations have been in management.... |
|
|
|
|
|
|
|
|
|
|
|
|
|