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

Articles with tag advanced Rss

Search for any content tagged advanced

<< Newer    Items 21 to 40 of 63    Older >>
 

Database Design: A Point in Time Architecture

In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller presents a solution to this requirement in the form of a Point-in-Time architecture: a database design which allows a user to recreate an image of the database as it existed at any previous point in time, without destroying the current image.  Read more...
By Additional Articles 2007/02/28 | Source: SimpleTalk | Category: advanced
Rating:  Rate this |   Briefcase | 3,412 reads

SQL Stored Procedure to Log Updates, Independent of Database Structure

How many DBAs need a solution to track those changes made for multiple systems? Auditing is becoming more and more prevalent in all systems and having a good solution can really make your DBA job interesting. New author Keren Ramot brings us his technique that works indepedent of the database structure.   Read more...
By Keren Ramot 2007/02/12 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 17,633 reads

CHAPTER FOUR: ORGANIZATIONALLY, WHERE DOES DATA GOVERNANCE FIT?

This is the fourth part of an ongoing series. The series is titled The Data Stewardship Approach to Data Governance. For information regarding future chapters, please use my contact information below. Previous articles were titled The Data Won't Govern Itself, Data Governance Is NOT a Methodology and The Tools of Data Governance.  Read more...
By Additional Articles 2007/01/23 | Source: TDAN | Category: advanced
Rating:  Rate this |   Briefcase | 1,497 reads

Refactoring Databases: The Process

This article describes how to implement a single refactoring within your database. It contains a worked example of the Move Column structural refactoring, whereby we move the Customer.Balance column to the Account table, a seemingly straightforward change to improve the database design.  Read more...
By Additional Articles 2007/01/16 | Source: SimpleTalk | Category: advanced
Rating:  Rate this |   Briefcase | 2,965 reads

Understanding Object Ownership

In SQL Server 2005, object ownership will have a different meaning, but since most of us work with SQL Server 2000, Kathi Kellenberger has written a good introduction to understanding how object ownership works and why you might want to follow certain practices.   Read more...
By Kathi Kellenberger 2007/01/05 (first published: 2005/07/18) | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 50,751 reads

Table Defaults

In working on an existing database, DBAs often look to normalize tables and correct obvious flaws in design. Recently Andy Warren was working on a consulting project and realized that defaults would prevent many issues.   Read more...
By Andy Warren 2007/01/04 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 7,154 reads

A Bit More on Defining Keys

Joe Celko spouts off on one of the basics of database design.  Read more...
By Additional Articles 2006/12/25 | Source: TDAN | Category: advanced
Rating:  Rate this |   Briefcase | 2,798 reads

Design Challenge: Global Address

Are you up to the latest design challenge? A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario with suggested solutions appears each month in this Design Challenge column. The scenario is emailed to more than 1,000 modelers. The responses are then consolidated into this column.   Read more...
By Additional Articles 2006/10/16 | Source: ASPToday | Category: advanced
Rating:  Rate this |   Briefcase | 1,954 reads

The Basics of Sizing a SQL Server Database

Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.   Read more...
By Brian Knight 2008/08/01 (first published: 2001/07/25) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,816 reads

To SP or not to SP in SQL Server: an argument for stored procedures

A seemingly never-ending battle in online database forums involves the question of whether or not database application development should involve the use of stored procedures.  Read more...
By Additional Articles 2006/06/08 | Source: Red-Gate | Category: advanced
Rating:  Rate this |   Briefcase | 2,032 reads

Foreign Keys

Foreign keys are an important part of a relational database. New author Ravi Lobo takes a look at foreign keys from the perspective of a new DBA with some scripts to help you ensure your database is setup correctly.   Read more...
By Ravi Lobo 2006/05/31 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 18,845 reads

TheServerSide Debates: Stored Procedures v Parameterized Queries

Let me start by stating some disclaiming remarks. I'm not against stored procedures in general, I find that the choice why procedures should be used, should be based on proper facts, not on claims without any proof.  Read more...
By Bilal Ahmed 2006/05/29 | Source: ASPToday | Category: advanced
Rating:  Rate this |   Briefcase | 4,145 reads

Don't use stored procedures yet? Must be suffering from NIHS

At just about every talk I give I always try to make several consistent statements. One of which is: ‘Whenever possible use stored procedures to access your data’.  Read more...
By Additional Articles 2006/05/29 | Source: Other | Category: advanced
Rating:  Rate this |   Briefcase | 3,359 reads

Using SQL Server 2005 to document Sarbanes-Oxley compliance

My CIO and I have looked at a number of commercial solutions for documenting Sarbanes-Oxley compliance. However, we decided to use SQL Server 2005's built-in tools to create our own "home-grown" auditing system.   Read more...
By Additional Articles 2006/05/19 | Source: Builder.com | Category: advanced
Rating:  Rate this |   Briefcase | 3,436 reads

Scaling Out SQL Server 2005

This article explains the different technologies that are available for scaling out a SQL Server 2005 database application, focusing on the factors that go into deciding which solution(s) to use in your application.  Read more...
By Additional Articles 2006/05/09 | Source: MSDN Communities | Category: advanced
Rating:  Rate this |   Briefcase | 2,611 reads

Conceptual, Logical, Physical:

As part of my research with the University of Melbourne, I asked 55 attendees of advanced data modeling seminars in the US (25 attendees) and UK (30 attendees) to list the stages in database design, including data modeling.  Read more...
By Additional Articles 2006/05/05 | Source: TDAN | Category: advanced
Rating:  Rate this |   Briefcase | 3,316 reads

Healthcare Data Models Matter

Healthcare applications come and go, but data live on forever. We’ve seen that since the beginning of the computer industry; when we move from legacy systems into more “modern” architectures, we often leave behind applications, but we almost always take along the data into the future. Even though data are so important, we in health-IT don’t seem to spend the quality time necessary to structure our schemas and databases in such a way as to make it easier to maintain in the future. We often don’t design our data models solidly, and we don’t test them well by putting them through simulations or design them for multiple versions.  Read more...
By Additional Articles 2006/03/27 | Source: Other | Category: advanced
Rating:  Rate this |   Briefcase | 2,320 reads

Lookup Table Madness

Are you mad? Not angry, more like crazy when it comes to designing databases in SQL Server? Don Peterson has met a few people he thinks are just that when it comes to building lookup tables. Does it stem from poor understanding of database design? Or do you disagree? Read Don's case against this particular design practice.   Read more...
By Don Peterson 2006/03/24 (first published: 2004/09/08) | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 46,044 reads

Building a Rule Engine with SQL Server

Rules play a central role in a wide variety of applications. In addition to the declarative specification of business rules, the simple rule engine design described in this article can be used to implement state machines, predicate dispatchers, or any other rule-based system.  Read more...
By Additional Articles 2006/03/10 | Source: MSDN Communities | Category: advanced
Rating:  Rate this |   Briefcase | 3,881 reads

The Pitfalls of Foreign Keys

What is the cost of DRI and is it something that you should implement? SQL Server expert David Poole takes a look at the impact of adding DRI to a CMS system and provides some real world results on which you can base your decision.   Read more...
By David Poole 2006/03/02 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 16,270 reads
<< Newer    Items 21 to 40 of 63    Older >>