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

Content with tags Strategies, Database Design Rss

   Items 1 to 20 of 24    Older >>
 

Is XML the Answer?

New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.   Read more...
By Don Peterson 2008/05/02 (first published: 2003/10/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 64,213 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,639 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,639 reads

Stored Procedure Naming Conventions

As your SQL Server applications grow, chances are that you have more and more objects, especially stored procedures that you need to keep track of. An organized environment is key to being able to prevent the duplication of code and effort. Joe Sack brings us a look at how he names stored procedures to easy identification.   Read more...
By Joseph Sack 2005/10/03 | Source: SQLServerCentral.com | Category: naming standards
Rating: |  Discuss |   Briefcase | 22,422 reads

Is XML the Answer?

New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.   Read more...
By Don Peterson 2008/05/02 (first published: 2003/10/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 64,213 reads

Database Standards and Conventions

Having a good set of naming conventions for your SQL Server objects is one of the most vital things to a company. In the long duration of a business, it saves money and time as programmers are transferred internally and don't need to relearn object names. As learning curves lower, cost lowers. This article covers some of the conventions that Brian Knight uses and why he uses them.   Read more...
By Brian Knight 2005/02/25 (first published: 2001/05/29) | Source: SQLServerCentral.com | Category: naming standards
Rating: |  Discuss |   Briefcase | 27,708 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,540 reads

Best Practices in an Adhoc Environment

This short article looks at some mistakes developers should avoid when they also have the task of designing the database, database objects, or TSQL used to access it.   Read more...
By Sharad Nandwani 2003/12/16 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,907 reads

Is XML the Answer?

New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.   Read more...
By Don Peterson 2008/05/02 (first published: 2003/10/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 64,213 reads

An Automated Solution for Migrating Database Structures

This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.  Read more...
By Additional Articles 2003/05/06 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 2,225 reads

A Lookup Strategy Defined

Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.   Read more...
By David Sumlin 2003/02/20 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 12,484 reads

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!   Read more...
By Andy Warren 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,336 reads

Managing Jobs - Part 1

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.   Read more...
By Andy Warren 2003/01/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,435 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,540 reads

Beware to the System Generated Constraint Name

New columnist Gregory Larsen used to not care what his objects were called until recently when he began to become concerned with the system generated constraint names. This short article tells you why.   Read more...
By Gregory Larsen 2002/08/16 | Source: SQLServerCentral.com | Category: naming standards
Rating: |  Discuss |   Briefcase | 7,053 reads

Interact with SQL Server's Data and Procedure Cache

This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.   Read more...
By Randy Dyess 2002/08/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,793 reads

Designing a Flexible Task Management Database

In this article by Jamie Voss, he shows the methodology he used to develop his task management database.   Read more...
By Jamie Voss 2002/05/20 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 5,973 reads

Version Control for Stored Procedures

Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.   Read more...
By Andy Warren 2002/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,367 reads

Analyzing Requirements and Defining Solution Architectures

Andy says it's not the greatest book for preparing for the 70-100 exam, but the case study is worth reading for it's explanation of the Microsoft Solution Framework. Read the full review!   Read more...
By Andy Warren 2002/01/02 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 3,540 reads

70-100 MCSD Architectures Exam Cram

Should you use this book to prepare for the 70-100 exam? Read the review and find out!   Read more...
By Andy Warren 2001/12/26 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 3,704 reads
   Items 1 to 20 of 24    Older >>
 
Tags
naming standards (10)    
miscellaneous (9)    
programming (6)    
administration (5)    
sql server 7 (5)    
t-sql (4)    
basics (3)    
configuring (3)    
best and worst practices (2)    
best practices (2)    
career (2)    
certifications (2)    
data types (2)    
monitoring (2)    
system development life cycle (2)    
advanced (1)    
book reviews (1)    
performance tuning (1)    
reviews (1)    
security (1)    
sql-dmo (1)    
stored procedures (1)    
visual basic 6 (1)