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 21 to 40 of 68    Older >>
 

An Introduction to Test Driven Development

There are lots of systems for developing software, but it often seems that DBAs don't adhere to any of them. New author Sudheer Palyam brings us a look at one that he has used in developing T-SQL applications, whereby the test scripts are written first.   Read more...
Rating: |  Discuss |   Briefcase | 9,857 reads

The Myth of Bandwidth and Application Performance

This whitepaper is intended to shed light on the issues affecting application performance in the wide area, and to give IT managers the knowledge required to design strategic enterprise application acceleration and deployment solutions  Read more...
By Additional Articles 2006/02/07 | Source: Other | Category: system development life cycle
Rating:  Rate this |   Briefcase | 3,032 reads

Running VirtualPC Images Effeciently

I have not been a real big fan of using VPC until recently with the Betas and releases of Visual Studio and SQL 2005. Now I can’t stop creating images with different environments for testing Service Packs, OS, Project Server, VS/SQL2005, etc. I want to share with you and also record the steps I used for making my images run efficiently.   Read more...
Rating:  Rate this |   Briefcase | 3,916 reads

Secrets of successful IT projects

Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.   Read more...
By Additional Articles 2005/12/05 | Source: Red-Gate | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,403 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,672 reads

SQL database control and deployment

If you develop SQL databases, you know how difficult it can be to promote from the development environment to production with any level of confidence that the databases are the same. When you have upgrades, it’s difficult to identify changes as well, especially when there are multiple developers making changes to multiple databases. The problem is compounded if your target environment is a client’s system over which you have no control. It’s staggering to think about what can happen if there are 600-plus client systems that have various versions of your database.   Read more...
By Additional Articles 2005/09/06 | Source: Red-Gate | Category: system development life cycle
Rating:  Rate this |   Briefcase | 2,626 reads

Calling All Editing Buffs

Author Sean McCown would like to see some improvements in the editing tools that are available. He's proposed some changes and ideas to make a better tool. Join the discussion and see if you can get the SQL Server vendors to build something to make every DBA's job easier.   Read more...
Rating: |  Discuss |   Briefcase | 4,114 reads

Single Point of Administration

Whether you write TSQL code or front end VB code against your SQL Server, it pays to have some good development practices that make your life easier. Jonathan Stokes has written a good article showing some of the good practices you should use.   Read more...
By Jonathan Stokes 2005/08/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,909 reads

Administering a Development Environment

In any well run development environment, you will have a separate SQL Server for developers to work on, completely different from your production server. However there are a few tricks that Jason Hall brings us that you might want to implement to ensure a smooth running environment.   Read more...
Rating: |  Discuss |   Briefcase | 7,525 reads

10 Things You Shouldn't Do with SQL Server

I posted a blog entry and a forum entry in a couple places to ask the question, "What are the things you see developers doing with SQL Server data access that they shouldn't?" The list grew to about 25 or 26 things that were hot topics (so much that the Microsoft SQL Server product team was passing the thread around).   Read more...
Rating:  Rate this |   Briefcase | 7,264 reads

Anatomy of an IT disaster: How the FBI blew it

Some FBI agents ruefully refer to the trilogy project, a massive initiative to modernize the FBI's aging technology infrastructure, as the "Tragedy" project. It certainly has all the earmarks of tragedy: the best intentions, catastrophic miscommunication, staggering waste.   Read more...
By Additional Articles 2005/04/08 | Source: Other | Category: system development life cycle
Rating:  Rate this |   Briefcase | 5,005 reads

Version Control - Part 4 - Rolling Back

Part 4 of Steve Jones' series on version control. This article examines how back out your changes from your live systems.   Read more...
By Steve Jones 2005/03/31 (first published: 2001/12/17) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 8,567 reads

Using Source Control to Develop Smarter

Veteran and novice developers alike need source control management (SCM). Also known as asset management, and source code management, SCM helps you (and your team) manage development projects, and the components and code that make up the project. There are many benefits to using source control management, most notably the ability to develop code faster, smarter and more accurately. Source control management tools help you control your code; especially in multiple developer projects.   Read more...
By Additional Articles 2005/03/29 | Source: Other | Category: system development life cycle
Rating:  Rate this |   Briefcase | 1,986 reads

The Trustworthy Computing Security Development Lifecycle

This paper discusses the Trustworthy Computing Security Development Lifecycle (or SDL), a process that Microsoft has adopted for the development of software that needs to withstand malicious attack. The process encompasses the addition of a series of security-focused activities and deliverables to each of the phases of Microsoft's software development process. These activities and deliverables include the development of threat models during software design, the use of static analysis code-scanning tools during implementation, and the conduct of code reviews and security testing during a focused "security push". Before software subject to the SDL can be released, it must undergo a Final Security Review by a team independent from its development group. When compared to software that has not been subject to the SDL, software that has undergone the SDL has experienced a significantly reduced rate of external discovery of security vulnerabilities. This paper describes the SDL and discusses experience with its implementation across Microsoft software.  Read more...
Rating:  Rate this |   Briefcase | 1,186 reads

Version Control - Part 3 - Migrating Objects to Production

Part 3 of Steve Jones' series on version control. This article examines how migrate your changes to your live systems.   Read more...
By Steve Jones 2005/03/25 (first published: 2001/12/10) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 12,538 reads

Migration to Production

SQL Server is an easy to use product in many ways, much better than the other major RDBMSs out there. However it's source control and ease of moving changes from development to production needs some work. Having a solid process is as important as good tools and new author Grant Fritchey brings us his proven method for moving changes through QA into production.   Read more...
Rating: |  Discuss |   Briefcase | 9,345 reads

Version Control - Part 2 - Tracking Changes

Part 2 of Steve Jones' series on version control. This article examines how you can track the changes you have made in a development cycle.   Read more...
By Steve Jones 2005/03/18 (first published: 2001/11/26) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 13,159 reads

Version Control -Part 1- Dealing with Code

Part 1 of Steve Jones series on version control and SQL Server. This article examines how you can work with version control and SQL objects.   Read more...
By Steve Jones 2005/03/11 (first published: 2001/11/22) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 20,392 reads

Generate SQL Automatically Without Compromising Quality

Most database developers dread including such navigation features as paginated reports, hierarchical navigation, filtering, and full-text search because the amount of time they take to develop is not proportional to the utility or interest they create. In addition, connecting individual pages and controls to the database is mind-numbing work. Since writing SQL is non-trivial in any circumstance, it typically requires a specialist DBA's involvement. ..... As Web-based applications proliferate to bring more functionality directly to end-users, writing every SQL statement for every web-based application in your shop is likely to become a never-ending Sisyphean task for your DBA.   Read more...
By Additional Articles 2005/03/10 | Source: Other | Category: system development life cycle
Rating:  Rate this |   Briefcase | 2,162 reads

Coding Standards Part 2 - Formatting

The second part of Steve Jones' series on coding standards within SQL Server.   Read more...
By Steve Jones 2004/12/17 (first published: 2002/07/01) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 30,462 reads
<< Newer    Items 21 to 40 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)