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
Articles with tag
System Development Life Cycle
Search for
any
content tagged
system development life cycle
<< Newer
Items 21 to 40 of 101
Older >>
Testing SQL Stored Procedures Using LINQ
The need to test a program that accesses and manipulates a back-end SQL Server® database is very common. In many such cases, the application interacts with the back-end data through the use of SQL stored procedures. In this type of scenario, you can think of the stored procedures as auxiliary methods of the system under test; and they must therefore be tested just like any other module in the system.
Read more...
By
Additional Articles
2008/05/08
|
Source:
Microsoft MSDN
|
Category:
system development life cycle
Rating:
Rate this
|
Briefcase
|
4,482 reads
SQL Server source code analysis and management adds database security
SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.
Read more...
By
Additional Articles
2008/05/06
|
Source:
SearchSQLServer
|
Category:
system development life cycle
Rating:
Rate this
|
Briefcase
|
2,483 reads
Connection Strategy for Multiple Database Environments
Greg Larsen looks at one way to design your database connection strategy to simplify changing application connections so you can plug-n-play databases with less administrative overhead when the need arises.
Read more...
By
Additional Articles
2008/04/28
|
Source:
Database Journal
|
Category:
system development life cycle
Rating:
Rate this
|
Briefcase
|
3,858 reads
theSystem - Part II
Continuing on with his series on building a game in SQL Server, Steve Fibich expands the schema and objects in this article.
Read more...
By
Steve Fibich
2008/04/16
|
Source:
SQLServerCentral.com
|
Category:
system development life cycle
Rating:
|
Discuss
|
Briefcase
|
3,086 reads
Tame Your Software Dependencies for More Flexible Apps
Few would disagree that striving for a loosely coupled design is a bad thing. Unfortunately, the software we typically design is much more tightly coupled than we intend. How can you tell whether your design is tightly coupled?
Read more...
By
Additional Articles
2008/04/04
|
Source:
Microsoft MSDN
|
Category:
system development life cycle
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,790 reads
Implementing Error Handling with Stored Procedures
A look at how you can implement error handling in your stored procedures.
Read more...
By
Additional Articles
2008/04/03
|
Source:
Erland Sommarskog's SQL Page
|
Category:
error handling
Rating:
Rate this
|
Briefcase
|
4,760 reads
SQL Server Database Requirements
In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the gaps.
Read more...
By
Additional Articles
2008/03/26
|
Source:
MSSQLTips.com
|
Category:
database design
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,815 reads
Accidently Agile
Longtime SQL Server expert David Poole brings us a look at Agile Development and how he's been converted. (From Feb 2008)
Read more...
By
David Poole
2009/09/18 (first published: 2008/02/14)
|
Source:
SQLServerCentral.com
|
Category:
system development life cycle
Rating:
|
Discuss
|
Briefcase
|
12,657 reads
Object Dependencies in SQL Server
In this video, Randy Dyess shows you how important SQL Server dependencies are and some of the faults with SQL Server 2005 with these. For example, SQL Server will allow you to create a stored procedure that points to a table that doesn't exist. He also shows you how this problem has been corrected in SQL Server 2008.
Read more...
By
Additional Articles
2008/01/30
|
Source:
JumpStartTV
|
Category:
sql server 2005
Rating:
Rate this
|
Briefcase
|
6,564 reads
Putting Unit Tests to Work
Testing is an important part of any software development process, but it's a part that many of us skimp on or ignore because of the tedious nature of testing. Longtime author Grant Fritchey has been working with Visual Studio Team Edition for Database Professionals and has written us an article on how you can make your unit testing easier.
Read more...
By
Grant Fritchey
2007/02/01
|
Source:
SQLServerCentral.com
|
Category:
system development life cycle
Rating:
|
Discuss
|
Briefcase
|
7,321 reads
Business Analysis: A Guide to Better Business Requirements
This article presents ten business analysis guidelines, representing best practices from successful projects.
Read more...
By
Additional Articles
2007/12/03
|
Source:
TDAN
|
Category:
system development life cycle
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,021 reads
Custom check-in policies with VSTS
In this column, I'll dig into check-in notes and policies. You'll learn how check-in notes work and how to write your own custom policy implementations.
Read more...
By
Additional Articles
2007/11/30
|
Source:
Microsoft MSDN
|
Category:
vsts
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,314 reads
.NET Building Blocks: Build a Configurable Database Credential Selector
This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types.
Read more...
By
Additional Articles
2007/11/20
|
Source:
DevX
|
Category:
programming
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,986 reads
Trustworthy Computing: Lessons Learned from Five Years of Building More Secure Software
This article discusses prioritizing code by age, using analysis tools and automation, looking at threats from multiple angles, and the importance of education
Read more...
By
Additional Articles
2007/11/09
|
Source:
Microsoft MSDN
|
Category:
system development life cycle
Rating:
Rate this
|
Briefcase
|
1,423 reads
The Baker's Dozen: 13 Productivity Tips for Transact-SQL 2005
SQL Server 2005 offers T-SQL language features that can improve your productivity.
Read more...
By
Additional Articles
2007/11/07
|
Source:
DevX
|
Category:
t-sql
Rating:
Rate this
|
Briefcase
|
4,685 reads
Are key performance indicators a true measure?
Some managers love to look solely at numbers when assessing performance, and key performance indicators (KPIs) are right up their street. But how useful are they in the context of software development
Read more...
By
Additional Articles
2007/10/12
|
Source:
Builder.com
|
Category:
strategies
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,391 reads
Close These Loopholes - Testing Database Modifications
In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give some examples of unit testing Database Modifications
Read more...
By
Additional Articles
2007/09/18
|
Source:
SimpleTalk
|
Category:
system development life cycle
Rating:
Rate this
|
Briefcase
|
3,154 reads
Close those Loopholes - Testing Stored Procedures
Alex and Alex continue their series of three articles on 'Unit Testing' database development work with some examples of unit testing stored procedures.
Read more...
By
Additional Articles
2007/08/31
|
Source:
SimpleTalk
|
Category:
system development life cycle
Rating:
Rate this
|
Briefcase
|
4,194 reads
Agile on a Fixed Budget
Scott examines strategies for dealing with constraints that business stakeholders may put on software development teams.
Read more...
By
Additional Articles
2007/08/29
|
Source:
Dr. Dobbs
|
Category:
system development life cycle
Rating:
Rate this
|
Briefcase
|
2,421 reads
Revisit What You Know
A thought provoking article from SQL Server expert and trainer Andy Warren. As a DBA you should think about the rules and decrees you have developed over the years and revisit them for application in your current situation.
Read more...
By
Andy Warren
2007/07/30
|
Source:
SQLServerCentral.com
|
Category:
system development life cycle
Rating:
|
Discuss
|
Briefcase
|
3,512 reads
<< Newer
Items 21 to 40 of 101
Older >>
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.