Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Content with tags
SQL Server 7
,
SQL Server 6.5
<< Newer
Items 21 to 40 of 43
Older >>
Reducing Round Trips
One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.
Read more...
By
Andy Warren
2005/07/15 (first published: 2002/01/24)
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
19,941 reads
SQL Server Security Part 1
In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.
Read more...
By
Chris Kempster
2005/02/11 (first published: 2002/01/14)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
50,073 reads
Lock View: sp_lock2
An alternative procedure for viewing locks based on sp_lock.
Read more...
By
Alexander Chigrik
2001/07/24
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
7,447 reads
Encrypting Data With the Encrypt Function
One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.
Read more...
By
Brian Knight
2006/05/29 (first published: 2001/07/17)
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
33,048 reads
Non_Continuous Replication
Replicating continuously minimizes latency, but at a cost. If you're replicated a lot of databases, read this article for some ideas about how to trade latency for overhead by runnig your agents in non-continous mode.
Read more...
By
Andy Warren
2001/05/15
|
Source:
SQLServerCentral.com
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
4,700 reads
Securing Your SQL Server
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
Read more...
By
Brian Knight
2001/05/14
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
6,449 reads
Using the Public Role to Manage Permissions
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
Read more...
By
Andy Warren
2001/05/10
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
17,345 reads
Sweeping Up The Slackers
Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.
Read more...
By
Steve Jones
2001/05/07
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
5,050 reads
Duplicate Key Inserted Error During Replication
If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.
Read more...
By
Andy Warren
2004/10/15 (first published: 2001/05/04)
|
Source:
SQLServerCentral.com
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
8,480 reads
Altering Replicated Tables
Need to make changes to table that is an article in a publication? Read this article to get step by step instructions on how to do it without doing a new snapshot!
Read more...
By
Andy Warren
2001/05/02
|
Source:
SQLServerCentral.com
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
7,218 reads
Analyze Databases Using Coefficient
In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.
Read more...
By
Additional Articles
2001/05/02
|
Source:
SQL Server Performance
|
Category:
performance tuning
Rating:
Rate this
|
Briefcase
|
1,396 reads
DSN-Less Connections
Confused about the difference between using a DSN or DSN-less connection? This article by Andy warren explains the differences and offers some insight into when each is appropriate.
Read more...
By
Andy Warren
2001/05/02
|
Source:
SQLServerCentral.com
|
Category:
configuring
Rating:
|
Discuss
|
Briefcase
|
5,054 reads
Moving Logins - A Gotcha!
This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5
Read more...
By
Andy Warren
2004/05/12 (first published: 2001/05/01)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
10,828 reads
Log Your Changes
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
Read more...
By
Steve Jones
2001/04/30
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
5,355 reads
Automatically Gathering Server Information Part 8
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Read more...
By
Steve Jones
2001/04/29
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
6,503 reads
Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
Read more...
By
Brian Knight
2001/04/29
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
8,838 reads
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Read more...
By
Steve Jones
2001/04/25
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
5,495 reads
Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Read more...
By
Steve Jones
2001/04/24
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
6,704 reads
Introduction to DSN's
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
Read more...
By
Andy Warren
2001/04/23
|
Source:
SQLServerCentral.com
|
Category:
configuring
Rating:
|
Discuss
|
Briefcase
|
7,850 reads
Not All SQL Server Indexes Are Created Equal
Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.
Read more...
By
Additional Articles
2004/09/24 (first published: 2001/04/22)
|
Source:
SQL Server Performance
|
Category:
performance tuning
Rating:
Rate this
|
Briefcase
|
4,689 reads
<< Newer
Items 21 to 40 of 43
Older >>
Tags
administration
(16)
security
(9)
monitoring
(7)
performance tuning
(6)
configuring
(3)
programming
(3)
replication
(3)
strategies
(3)
t-sql
(3)
ado
(1)
advanced querying
(1)
basics
(1)
best and worst practices
(1)
database design
(1)
dts
(1)
miscellaneous
(1)
sql server 2005
(1)
sql-dmo
(1)
upgrading
(1)
worst practices
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.