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

Content with tags Miscellaneous, Administration Rss

<< Newer    Items 21 to 40 of 66    Older >>
 

Custom Log Shipping

One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.   Read more...
By Chris Kempster 2003/11/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,474 reads

Using VBScript to Automate Tasks

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.   Read more...
By Haidong Ji 2008/03/07 (first published: 2003/11/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 100,355 reads

Review of AdeptSQL

Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.   Read more...
By Chris Kempster 2003/11/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,402 reads

New Table Structure Compare Tool in Beta

Aladdin is an "alter table" script generation tool for SQL Server 7/2000. Aladdin is currently in BETA. They are currently looking for for 25 people willing to use the beta product and report their experiences. Users who fully participate in the beta will get a free, single user license when the product is released. To participate in the Aladdin BETA program, please download the software and send an email to Ken Otto: ottosoft@hotmail.com - Subject: Aladdin Beta Test.   Read more...
By Additional Articles 2003/10/01 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,007 reads

Create Maintenance Job with a Click without using a Wizard

Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily.   Read more...
By Robin Back 2003/08/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,635 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,059 reads

Example VSS Framework - Source Code Management - Part 1

We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs.   Read more...
By Chris Kempster 2003/07/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,490 reads

Managing Jobs - Part 4

Andy has been busy lately on a project you'll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.   Read more...
By Andy Warren 2003/06/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,985 reads

SQL and IIS on the same Box?

David takes us through why he believes trying to run SQL and IIS on the same box is a bad idea. It's a common notion that it IS a bad thing to do, but you have real justification? Read this and you will!   Read more...
By David Poole 2003/06/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,942 reads

Importing And Analyzing Event Logs

Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!   Read more...
By Gheorghe Ciubuc 2003/05/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,796 reads

Changing Rogue Database Collations

Collations hard to sort out (I know, bad joke)? Mike did what a good DBA gets paid to do, figure out an easy way to fix something and remove the chance of a user mistake at the same time. Good explanation and a couple scripts show how to handle column level collations.   Read more...
By Mike Pearson 2003/05/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,595 reads

Integrating SQL LiteSpeed in your existing Backup Infrastructure

This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration.   Read more...
By Jeremy Kadlec 2003/05/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,351 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,226 reads

An Automated Solution for Migrating Database Structures

This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.  Read more...
By Additional Articles 2003/05/06 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 2,302 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,961 reads

Using Query Analyzer Templates

Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea!   Read more...
By Gregory Larsen 2003/04/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,593 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

mssqlXpress v1.02 Released

This is a product we haven't reviewed yet, but looks interesting. A SQL editor type app, features listed include integration with Visual SourceSafe, 'intellisense' statement completion, and keyboard macro's.   Read more...
By Additional Articles 2003/04/04 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,003 reads

Managing Jobs Using TSQL

We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.   Read more...
By Randy Dyess 2003/04/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,724 reads

Change Management

This article looks at change management from the perspective of the DBA, including how to use source control to your advantage and planning for 'self-healing' apps.  Read more...
By Chris Kempster 2003/03/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,954 reads
<< Newer    Items 21 to 40 of 66    Older >>
 
Tags
sql server 7 (52)    
t-sql (26)    
programming (23)    
configuring (20)    
strategies (20)    
monitoring (8)    
backup / restore (7)    
performance tuning (7)    
stored procedures (7)    
visual basic 6 (7)    
database design (6)    
security (6)    
indexing (5)    
replication (5)    
data warehousing (4)    
dts (4)    
.net (3)    
best and worst practices (3)    
installation (3)    
sql-dmo (3)    
worst practices (3)    
ado (2)    
availability (2)    
disaster recovery (dr) (2)    
distributed queries (2)    
naming standards (2)    
triggers (2)    
user defined function (udf) (2)    
analysis services (ssas) (1)    
basics (1)    
career (1)    
data (1)    
dba (1)    
english query (1)    
function (1)    
olap server (1)    
openxml (1)    
reporting services (ssrs) (1)    
schema (1)    
sql server 2005 (1)    
sql server 6.5 (1)    
state of the business (1)    
updategrams (1)    
views (1)    
warehouse (1)    
xml (1)    
xsl (1)