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

Articles with tag Configuring Rss

Search for any content tagged configuring

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

The SQL Server Black Box

Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.   Read more...
By Brian Knight 2003/04/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,276 reads

Standards Are a Good Thing

This week we have another article from Andy that discusses some changes he made at work in conjunction with clustering all his database servers. Not a how-to, just comments about what was changed and why. Worth reading just for the reminder about the potential gotcha that @@ServerName can represent.   Read more...
By Andy Warren 2003/04/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,147 reads

Ways to Determine the Version and SP of SQL Server

There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.   Read more...
By Dinesh Priyankara 2003/02/28 | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 21,846 reads

Troubleshooting Cannot Generate SSPI Context Errors

As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet.   Read more...
By Chad Miller 2005/08/19 (first published: 2003/02/27) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 65,284 reads

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!   Read more...
By Andy Warren 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,336 reads

Getting Rid of Excessive Files and Filegroups in SQL Server

Although there are legitimate reasons for using filegroups, Chad Miller recently encountered a situation where they were used too much. He shows you in this article why and how to remove excessive filegroups.   Read more...
By Chad Miller 2003/02/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,844 reads

Autoclose for Databases

In SQL Server 2000, there is a database option to close the database when it is not in use. Every wonder what this is? Or when it should be used? Steve Jones takes a look at this seldom used option.   Read more...
By Steve Jones 2003/02/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,630 reads

Managing Jobs - Part 1

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.   Read more...
By Andy Warren 2003/01/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,435 reads

Another Disaster (Almost)

Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.   Read more...
By Andy Warren 2003/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,034 reads

Building a Demo System - Part 3

Continuing on looking at demo servers, this article presents an interesting solution to ensuring consistent demos that was deployed out in the field for a client company.   Read more...
By Steve Jones 2003/01/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,622 reads

Beware of Mixing Collations: Converting Collations

With SQL Server 2000 you are able to create databases or columns with a different collating setting than the server. This article will explain a couple of methods Greg has used to successfully change collation settings.   Read more...
By Gregory Larsen 2002/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,581 reads

Beware of Mixing Collations - Part 1

A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.   Read more...
By Gregory Larsen 2002/12/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,017 reads

Building a Demo Server - Part 2

Everyone does demos. You need them to sell your software, but the demo server presents some challenges. Continuing this series, this article looks at moving data between servers.   Read more...
By Steve Jones 2002/12/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,951 reads

Setting a Default Database for your Logins

Andy discusses reasons why he thinks setting the default database to anything other than master is a mistake. We think he does a good job of covering the pros and cons, read the article and join the discussion!   Read more...
By Andy Warren 2002/12/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,316 reads

A Temporary Move

The third part of a series in moving system databases.   Read more...
By Steve Jones 2002/11/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,416 reads

Review of Real-World SQL-DMO

Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!   Read more...
By Andy Warren 2002/11/19 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 5,245 reads

Move Your Master

How often do you move your master database? Hopefully never, but this article looks at an easy technique should you need to perform this trick.   Read more...
By Steve Jones 2002/11/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,970 reads

Manage Multiple SQL Server Installations and Databases with OSQL

This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers.   Read more...
By Randy Dyess 2002/10/24 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 9,801 reads

Adding Linked Servers Using SQL-DMO

Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.   Read more...
By Andy Warren 2002/09/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,116 reads

ANSI Options Part 4 - ANSI_WARNINGS

Part 4 examines more ANSI options that are available in SQL Server. A simple setting with some unexpected (for the author) results.   Read more...
By Steve Jones 2002/09/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,716 reads
<< Newer    Items 41 to 60 of 98    Older >>