The steps in developing
any application can be represented as a linear sequence where each step in the
sequence is a function, which passes its output to its successor function.
Adherence of a ‘waterfall development model’ ensures quality software, which is
‘complete’, ‘efficient’, ‘usable’, ‘consistent’, ‘correct’ and ‘flexible’.
These traits are also some of the core underpinnings of a well-built database.
The waterfall model can be applied to database design theory as effectively as
it is applied to other software engineering theory. The steps can
be summarised as follows:
Subscribe to:
Post Comments (Atom)
SQL Script to list out name of tables and its records in the database
SET NOCOUNT ON DBCC UPDATEUSAGE(0) -- DB size. EXEC sp_spaceused -- Table row counts and sizes. CREATE TABLE #temptable ( [name] NVA...
-
There are multiple ways to do this. 1) INSERT INTO SELECT This method is used when table is already created in the database earlier...
-
1. Direct connections via the Internet These connections can be used to attach to SQL Servers sitting naked without firewall protection...
-
It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penet...
No comments:
Post a Comment