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
Daily SQL Articles by email:
Sign up
Articles with tag
SQL Server 7
Search for
any
content tagged
sql server 7
<< Newer
Items 41 to 60 of 941
Older >>
Altering a column on a Replicated Table
SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.
Read more...
By
Paul Ibison
2007/11/30 (first published: 2005/01/19)
|
Source:
SQLServerCentral.com
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
35,500 reads
Monitoring on a Budget
Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this
Read more...
By
Bert Carles
2007/11/19
|
Source:
SQLServerCentral.com
|
Category:
monitoring
Rating:
|
Discuss
|
Briefcase
|
9,093 reads
SQL Server Job Scheduling
The scheduling system in SQL Server is quite flexible and powerful, but can be confusing at times. Peter He looks at some of the advanced options you have in automating the various jobs on your server.
Read more...
By
Peter He
2007/11/16 (first published: 2006/03/08)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
37,881 reads
Reverse Engineering Alias Data Types in SQL Server 2000 - Part IV
In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).
Read more...
By
Yakov Shlafman
2007/11/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 7
Rating:
|
Discuss
|
Briefcase
|
1,625 reads
Migrating SQL Server 2000 DTS Packages Across Environments
Many of us still have SQL Server 2000 DTS packages running throughout our environment. New author Owais Bashir Ahmed brings us an interesting technique for moving those packages between servers that might come in handy as you continue to work on these packages in SQL Server 2000.
Read more...
By
Owais Bashir Ahmed
2007/10/09
|
Source:
SQLServerCentral.com
|
Category:
dts
Rating:
|
Discuss
|
Briefcase
|
6,115 reads
Replication Statement Delivery Options - Part 1
Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean.
Read more...
By
Andy Warren
2007/09/24
|
Source:
SQLServerCentral.com
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
4,125 reads
Changing Service Credentials
One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.
Read more...
By
Additional Articles
2007/09/21
|
Source:
SimpleTalk
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
2,335 reads
Monitoring Disk Space and Sending Alerts with TSQL
Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring!
Read more...
By
Haidong Ji
2007/09/14 (first published: 2003/08/13)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
50,997 reads
Capturing Missing Information From SQL Profiler
While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need.
Read more...
By
Solomon Rutzky
2007/09/06
|
Source:
SQLServerCentral.com
|
Category:
monitoring
Rating:
|
Discuss
|
Briefcase
|
9,470 reads
Removing the Builtin Administrators - Some Pitfalls to Avoid
The SQL Server 2000 security model is not the best one of all the RDBMS platforms and requires some work to secure properly. One of the practices that is recommended is removing the builtin/administrators group from accessing the SQL Server. New author Kathi Kellenberger shows us some of the pitfalls she encountered when removing this group from her servers.
Read more...
By
Kathi Kellenberger
2007/08/10 (first published: 2005/01/12)
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
29,486 reads
Server Farm Reporting - Part 2
Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.
Read more...
By
Mark Tierney
2007/08/06
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,798 reads
Using Non-Standard Port for SQL Server
Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.
Read more...
By
Additional Articles
2007/08/03
|
Source:
Database Journal
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
2,987 reads
Beginning SQL Server - Logins and Users
Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security.
Read more...
By
Steve Jones
2007/08/03 (first published: 2004/09/02)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
41,108 reads
Bookmark Lookups
Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.
Read more...
By
Randy Dyess
2008/07/18 (first published: 2005/05/30)
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
37,161 reads
SQL Server Security: Pros and Cons of Application Roles
Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.
Read more...
By
Brian Kelley
2008/07/25 (first published: 2003/08/27)
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
40,096 reads
Pop Rivett and the Expanding Log
When your database transaction log is out of control, there is only one man who can tame it.
Read more...
By
Additional Articles
2007/07/06
|
Source:
SimpleTalk
|
Category:
administration
Rating:
Rate this
|
Briefcase
|
2,549 reads
Updating AS/400 Linked Server Tables from SQL Server
One of the strongest features of SQL Server is the ability to connect to disparate data sources and perform queries across multiple sources. New author Basu Hullur brings us a technique that he used to update data on the AS/400 in a much quicker way than previously.
Read more...
By
Basu Hullur
2007/07/06 (first published: 2006/04/05)
|
Source:
SQLServerCentral.com
|
Category:
distributed queries
Rating:
|
Discuss
|
Briefcase
|
42,566 reads
Maintain DTS packages in SQL Server 2005
Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.
Read more...
By
Additional Articles
2007/07/05
|
Source:
SearchSQLServer
|
Category:
dts
Rating:
Rate this
|
Briefcase
|
4,695 reads
SQL Server 2000 SP3a Support is Ending
Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.
Read more...
By
Press Release
2007/07/05
|
Source:
SQLServerCentral.com
|
Category:
news
Rating:
|
Discuss
|
Briefcase
|
3,193 reads
SQL 2000 DBA Toolkit Part 1
SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys.
Read more...
By
Michael Coles
2007/06/22 (first published: 2006/04/13)
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
30,363 reads
<< Newer
Items 41 to 60 of 941
Older >>
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.