Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Administration


Search:
What's New - What's Hot
Interview with Carl Speshock, Author of the Microsoft SQL Server 2000 Database Administrator's Guidebook  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

Carl Speshock has been a DBA in the Houston area for over 6 years, and is moving back to Oregon, although he will continue to maintain some presence in Texas. Most recently, he has consulted to Shell Oil Products USA and Shell Services International. In addition to this book, he has authored an article on Full Text Indexes for the April 2002 edition of Access/VB/SQL Magazine....

SQL Server - MERGE Example  Version: 0.00     Price: $0.00  
Total Hits: 35  |  Today: 0Author: beyondrelational.com      Rating:  
Read Reviews | Write Review |  Your Rating: 

Using SQL Server MERGE command...

SQL Server for Network Administrators     
Total Hits: 122  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your 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?...

Follow Up on Rolling Sums - Self Joins vs User Variables     
Total Hits: 38  |  Today: 0Author: Jay Pipes      Rating:  
Read Reviews | Write Review |  Your Rating: 

Damien, of course, is correct, that I could have used a user variable like the above to generate the rolling sum, instead of using a self join. However, there are some complications. First, let's look at what happens if I rewrite Lenz' original GROUP BY statement to include a user variable to calculate running totals....

SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability to Admins and Users     
Total Hits: 252  |  Today: 0Author: Carl Nolan      Rating:  
Read Reviews | Write Review |  Your 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...

Quickly Shrinking the Transaction Log      
Total Hits: 321  |  Today: 0Author: Krishnan M Kaniappan      Rating:  
Read Reviews | Write Review |  Your 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.
...

Auditing Your SQL Server Environment Part II     
Total Hits: 154  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Over the last few years I have been a roving SQL Server DBA contractor and tended to work contacts in small and mid-size companies that involved organizing, documenting and then tuning/optimizing existing SQL Servers in those companies. I have noticed one very disturbing truth over the years; no one seems to document anything. In fact, I was usually thankful if I could find something or someone who knew the sa passwords on each SQL Server installation, let alone knew anything else about their se...

Chapter 2: Multi-Server Administration  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Microsoft Press      Rating:  
Read Reviews | Write Review |  Your 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....

Daylight Saving Time Changes     
Total Hits: 43  |  Today: 0Author: Peter Gulutzan and Dmitri Lenev      Rating:  
Read Reviews | Write Review |  Your Rating: 

his year many American states and Canadian provinces will switch to daylight saving time on March 11 (the second Sunday of March) instead of switching on the first Sunday of April as happened during previous years....

MySQL on Windows? Absolutely!     
Total Hits: 42  |  Today: 0Author: Robin Schumacher      Rating:  
Read Reviews | Write Review |  Your Rating: 

The admission I'm about to make will likely cause me to lose some friends/colleagues in the open source world, but I have to be honest: I like using Microsoft Windows. Except for Windows 3.0-3.1, I always have. Further, I personally much prefer managing databases on Windows than Unix and will also give Windows the nod over Linux in certain areas. See, I came from managing DB2 on the mainframe to running data warehouses with Teradata on their proprietary platform, and then did a long run with Ora...

Getting Started with SMO in SQL 2005 - Backups     
Total Hits: 129  |  Today: 0Author: Jasper Smith      Rating:  
Read Reviews | Write Review |  Your 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 backups using SMO in SQL2005. For information on how to build and compile a SMO application please review Getting Started with SM...

Getting Started with SMO in SQL 2005 - Restores     
Total Hits: 132  |  Today: 0Author: Jasper Smith      Rating:  
Read Reviews | Write Review |  Your 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...

Verify and Change the MSDE System Administrator Password     
Total Hits: 310  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article discusses the steps you can use to change the SQL Server sa (system administrator) password...

How SQL Server Determines an Execution Plan Using Available Indexes and Statistics     
Total Hits: 564  |  Today: 0Author: Nils Bevaart      Rating:  
Read Reviews | Write Review |  Your 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...

Automatic Email Alerts for Low SQL Server Disk Space     
Total Hits: 326  |  Today: 0Author: Muthusamy Anantha Kumar aka The MAK      Rating:  
Read Reviews | Write Review |  Your Rating: 

Usually SQL Server database administrators use the feature "Auto Growth" in the database configuration, in order allows automatic file growth when the database tries to expand. Though it is a good feature, sometimes SQL Server runs out of hard disk space. This article illustrates how to set up email notification when SQL Server is running out of Hard Disk Space....

Clustering SQL Server 2000 from 500 Feet     
Total Hits: 142  |  Today: 0Author: Brian Knight      Rating:  
Read Reviews | Write Review |  Your 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....

Services for SQL Server 2000     
Total Hits: 250  |  Today: 0Author: Brian Kelley      Rating:  
Read Reviews | Write Review |  Your 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!...

How to use trace flags in SQL Server 2000     
Total Hits: 163  |  Today: 0Author: SqlServerCentral      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2000 trace flags can dramatically alter the behavior and functionality of the server. This article describes how to set the status of trace flags in SQL Server 2000 to on or off. It also describes what effects setting the status of a trace flag has (and what effects it does not have). Most of the information can be found in Books Online1, though the information contained there is not complete and even confusing in some parts. In this article I have tried to present the complete inform...

How to Schedule a SQL Server Database Creation Script     
Total Hits: 217  |  Today: 0Author: SQLServerCentral      Rating:  
Read Reviews | Write Review |  Your Rating: 

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....

Querying System Tables     
Total Hits: 196  |  Today: 0Author: sqlservercentral      Rating:  
Read Reviews | Write Review |  Your Rating: 

It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. the author of this article 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....


1  2  3  4  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net