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 21 to 40 of 98    Older >>
 

Common QA for deploying SQL Server in a SAN Environment

Detailed question/answer paper on deploying SQL Server in a Storage Area Network (SAN) Environment.   Read more...
By Additional Articles 2005/01/04 | Source: Other | Category: configuring
Rating:  Rate this |   Briefcase | 2,286 reads

Best Practices are always the Best

On this site, we have taken a contrarian approach to looking at the ways to configure SQL Server with our Worst Practices series. However Microsoft still looks at it from the other side and release a tool called the Best Practices Analyzer for SQL Server. Author Dinesh Asanka brings us a short look at this tool.   Read more...
By Dinesh Asanka 2004/11/11 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 12,562 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,629 reads

Review of SQL2K Resource Kit

Good enough for your bookshelf? This one meets that requirement for Brian, click the link to find out why.   Read more...
By Brian Kelley 2004/04/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,893 reads

The Need For Speed - Upgrading Your Servers

Do you have the need for more speed on your servers? How do you go about squeezing more speed out of the database when faced with an upgrade? Steve Jones walks through some of his thought process when looking at ugprade for one of his servers.   Read more...
By Steve Jones 2004/03/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,453 reads

SQL Server Security Part 2

In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...
By Chris Kempster 2005/11/04 (first published: 2004/01/30) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,069 reads

Snapshot Replication for the Beginner

Andy continues writing about replication, this week discussing the many options available when creating a snapshot publication. As we noted on his last article, this one may take longer than usual to load due the large number of images but we think the readability of having it all one page is worth while.   Read more...
By Andy Warren 2004/01/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,740 reads

Getting Ready to Replicate

We've asked Andy to put together some articles that tackle replication from a beginner perspective, a tutorial type approach PLUS comments on what you should or should not do. This week he covers the steps needed to set up a server for replication. More images than usual so the page may take a little longer to load, but we think worthwhile so that you can see every step along the way. Let us know what you think.   Read more...
By Andy Warren 2004/01/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,993 reads

Building a Demo Server

Everyone does demos. Selling software relies upon people viewing your software in action and being confident it will work. Managing a demo server can be a challenge and this series will look at different problems and options you have.   Read more...
By Steve Jones 2004/01/14 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 6,509 reads

Using WMI

Get started with using WMI (Windows Mgmt Instrumentation) by seeing two good scripts to start with, one to reboot the server, another to list all the services.   Read more...
By Haidong Ji 2003/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,637 reads

The Guru's Guide to SQL Server Architecture and Internals

New book! This new book by Ken Henderson (author of other 'GURU' books abou SQL) promises an all inclusive approach to the internals. Sample chapters and other info available by following the link. We'll try to get a review up soon!  Read more...
By Additional Articles 2003/11/17 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,144 reads

Build a lot of DSN's in a hurry!

This article by Andy Warren offers a free utility that will generate DSN's for all or just a subset of the databases on a server in seconds.   Read more...
By Andy Warren 2003/09/19 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 10,007 reads

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.   Read more...
By Andy Warren 2003/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,025 reads

Managing Max Degree of Parallelism

Herve has done some work experimenting with max degree of parallelism (DOP) on some large multi processor blocks and based on that, has some recommendations for you if you're using more than 8 processors. Good reading!   Read more...
By Herve Roggero 2003/06/23 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 30,093 reads

Is Windows 2003 Really Faster?

Is Windows 2003 really faster for a SQL Server/IIS environment? Let us do all the leg work for you! We are about to upgrade the SQLServerCentral.com web and SQL Server from Windows 2000 to Windows 2003. As part of the case study, we are going to capture a baseline of the server's overall performance before the upgrade and then again after the upgrade. We will then document the experience and benchmark numbers.   Read more...
By Brian Knight 2003/06/10 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 12,865 reads

SQL Server 2000 SP 3: What's New in Security

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...
By Brian Kelley 2005/12/09 (first published: 2003/06/05) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 29,969 reads

Economies of Speed Whitepaper

Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.   Read more...
By Additional Articles 2003/05/08 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,153 reads

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.   Read more...
By Mike Pearson 2003/05/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,920 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

AWE Adventures

Joseph recently had to upgrade a server from 4g to 8g of memory. Read how he did it and learn about some interesting aspects of AWE. For example, if you have 6.5g configured for use by SQL, how will task manager show used by sqlserver.exe?   Read more...
By Joseph Sack 2003/04/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,728 reads
<< Newer    Items 21 to 40 of 98    Older >>