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

Content with tags Strategies, System Development Life Cycle Rss

<< Newer    Items 41 to 60 of 68    Older >>
 

Worst Practices - Part 1 of a Very Long Series!

Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!   Read more...
By Andy Warren 2004/12/03 (first published: 2001/10/09) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 33,734 reads

Worst Practices - Objects Not Owned by DBO

Last week Andy launched a new series about Worst Practices by talking about why the Hungarian naming convention is bad for column names. This week he's at it again, declaring that the practice of having objects owned by anyone other than dbo is BAD! Agree or disagree, we think you'll enjoy reading this article and adding your thoughts to the discussion!   Read more...
By Andy Warren 2004/11/12 (first published: 2002/09/12) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 37,552 reads

Keeping QA Up To Date - Part 2

Working with a QA server in SQL Server 2000 is something everyone should learn to do. Having some staging area between development and production will help ensure a more stable environment and smoother deployments. After a little hiatus, Steve Jones continues with this series looking at moving the latest backup over to QA.   Read more...
Rating: |  Discuss |   Briefcase | 6,541 reads

The Daily Database Build

From SQLTeam's Bill Granazio, a look at how he ensures his database scripts are always working.  Read more...
Rating:  Rate this |   Briefcase | 764 reads

DB Change Management - An Automated Approach - Part 4

The final installment in Darren Fuller's series on change management in SQL Server. If you haven't read the others, be sure to go through them before reading this one to learn how automating your version control in SQL Server is needed for any development shop.   Read more...
Rating: |  Discuss |   Briefcase | 7,131 reads

How To Find SQL Server Objects

SQL Server can grow to encompass hundreds of databases on a single server, each having hundreds or thousands of objects within it. A truly scalable RDBMS. However, how many times have you been searching through the Object Browser in QA or the left pane in Enterprise Manager searching for an object? New Author Ashish Kaushal gives us a method to easily search your server for that long lost object.   Read more...
By Ashish Kaushal 2004/08/17 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 16,244 reads

DB Change Management: An Automated Approach - Part 3

Part 3 of Darren Fullers series on automating change management for SQL Server. A must read if you perform development and need a system to ensure that all changes are tracked.   Read more...
Rating: |  Discuss |   Briefcase | 9,308 reads

DB Change Management - An Automated Approach - Part 2

The second part of the series by Darren Fuller on SQL Server change management, version control, and ways that you can automate this approach. If you do any type of SQL Server development, having a version control system is key to ensuring stability and keeping to your deadlines. Whether you agree with this approach or not, it's good information to have.   Read more...
Rating: |  Discuss |   Briefcase | 10,022 reads

Database Change Management: An Automated Approach

SQL Server change management is tough. The tools don't integrate with version control systems, there isn't good administrative controls to enforce control, and often you need to buy a third party tool to make this work. New Author Darren Fuller takes a look at the various ways in which you can implement version control in SQL Server. This is part one of a four part series on version control in SQL Server.   Read more...
Rating: |  Discuss |   Briefcase | 13,051 reads

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,607 reads

Change Management in Your Database

SQL Server has no change management integrated with the native tools. This means that each person must develop their own method of handling changes, or live with the chaos that will inevitably ensue. There are a number of articles written about various ways to handle change management and Dinesh Asanka shares his here. Read on and see if this helps you get a handle on changes in your environment.   Read more...
Rating: |  Discuss |   Briefcase | 7,189 reads

Keeping QA Up To Date

Do you have to refresh a test or QA server from the production system? Do you have a good process or is it a spur of the moment, let's get it done thing? Here's a look at Steve Jones' process, which was used weekly for well over a year.   Read more...
Rating: |  Discuss |   Briefcase | 7,710 reads

Data Migration : Step by Step

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.   Read more...
By Chris Kempster 2005/11/25 (first published: 2004/03/24) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 47,730 reads

Stored Procedure Development Cycle

This month Robert covers the process he uses for developing stored procedures. In many ways it reflects how software is developed, but it does have it's minor differences. This is a high level process discussion, not a line by line example of the entire process - by design of course.   Read more...
By Robert Marda 2003/09/03 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 10,628 reads

SQL Server Upgrade Recommendations and Best Practices - Part 1

This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective.   Read more...
By Jeremy Kadlec 2003/03/03 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 8,922 reads

Initial Installation of the Production Database

Your software has passed all testing phase(s) and it is time to install your database into production. Andy Jones will outline below how he accomplished this task. This article is concerned with an evolving system and how to migrate it to production.   Read more...
By Andy Jones 2003/02/04 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 6,213 reads

Server Hardware Standards

Standards are important in the computer business, both the hardware and software side. After looking at Coding Standards in a previous series, Steve Jones looks at the server side of standards beginning with hardware.   Read more...
By Steve Jones 2003/01/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,014 reads

Who Needs Change Management?

You have spent thousands of dollars on that cool technology; clustering, redundant controllers, redundant disks, redundant power supplies, redundant NIC cards, multiple network drops, fancy tape backup devices and the latest and greatest tape technology. You are all set. There is no way your going to have downtime. Right?   Read more...
By Greg Robidoux 2003/01/16 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,869 reads

Creating Your Dream Project

In this article, columnist Christopher Duncan shows you how to create your dream development project.   Read more...
By Christopher Duncan 2002/11/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,647 reads

Worst Practices - Objects Not Owned by DBO

Last week Andy launched a new series about Worst Practices by talking about why the Hungarian naming convention is bad for column names. This week he's at it again, declaring that the practice of having objects owned by anyone other than dbo is BAD! Agree or disagree, we think you'll enjoy reading this article and adding your thoughts to the discussion!   Read more...
By Andy Warren 2004/11/12 (first published: 2002/09/12) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 37,552 reads
<< Newer    Items 41 to 60 of 68    Older >>
 
Tags
miscellaneous (6)    
sql server 7 (5)    
t-sql (4)    
advanced querying (3)    
naming standards (3)    
programming (3)    
administration (2)    
availability (2)    
database design (2)    
installation (2)    
visual basic 6 (2)    
.net (1)    
basics (1)    
best and worst practices (1)    
best practices (1)    
dts (1)    
kpis (1)    
stored procedures (1)    
xml (1)