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
Content with tags
T-SQL
,
SQL Server 7
,
Strategies
,
Administration
Items 1 to 10 of 10
Making Good Use of Sysforeignkeys Table - Part 1: Display table relati
Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.
Read more...
By
Jeffrey Yao
2004/06/01
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
11,616 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,581 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,605 reads
Managing Jobs Part 3
This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.
Read more...
By
Andy Warren
2003/03/11
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
7,112 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,452 reads
The Case for SQL Logins - Part Two
In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.
Read more...
By
Andy Warren
2002/08/19
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
6,780 reads
Interact with SQL Server's Data and Procedure Cache
This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
Read more...
By
Randy Dyess
2002/08/15
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
13,819 reads
SQL Maintenance Plans - Under the Covers!
In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!
Read more...
By
Andy Warren
2002/05/21
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
9,208 reads
Version Control for Stored Procedures
Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.
Read more...
By
Andy Warren
2002/05/10
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
13,424 reads
Executing Multiple Scripts in a Folder using the ScriptRunner Utility
Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.
Read more...
By
Andy Warren
2001/06/14
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
9,641 reads
Items 1 to 10 of 10
Tags
miscellaneous
(8)
programming
(6)
configuring
(4)
database design
(4)
visual basic 6
(3)
naming standards
(2)
sql-dmo
(2)
stored procedures
(2)
.net
(1)
advanced querying
(1)
backup and restore
(1)
indexing
(1)
monitoring
(1)
performance tuning
(1)
security
(1)
system development life cycle
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.