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

Content with tags Miscellaneous, Database Design Rss

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

Globalization in SQL Server

SQL Server can support many different languages through Unicode. Author Dinesh Asanka brings us a basic article on how the server supports different languages.   Read more...
By Dinesh Asanka 2005/07/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,900 reads

SOA, Multi-Tier Architectures and Logic in the Database

If you are a developer creating Web services, a webmaster creating database-enabled pages or a database administrator (DBA) tuning SQL queries for a 24x7 web site, you've probably experienced the phenomenon known as "web time." The computer industry has never been quiet, but recent years have been particularly frenetic. The popularity of the web produced a flurry of software-development activity. New versions, new technologies, and new products appeared seemingly overnight. Web time became a useful phrase for describing compressed development cycles between new product releases and documentation that is obsolete before it arrives from the printer.   Read more...
By Additional Articles 2005/05/25 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,070 reads

DATA STRATEGY INTRODUCTION

A Chief Financial Officer (CFO) was approached by the CEO and asked for an accounting of the company’s financial assets. The CFO gave a vague response indicating a lack of knowledge of the corporate bank accounts, had little idea what was in each account, and had no idea about the status of accounts receivable. The Board of Directors asked the CEO about the intended use of the corporate assets and were told “there is no plan for their use.” The CFO and the CEO were soon pursuing new personal interests.   Read more...
By Additional Articles 2005/05/23 | Source: TDAN | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,143 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

Data Driven Architecture

Most SQL Server developers and DBAs are familiar with the concept of using a database as a back end to a web site or other application. However the database can be used to store more than just the data that users will edit. An interesting approach to application design begins with some knowledge of the metadata about the underlying data structures and using this to drive the application's behavior. New author Jim Craddock has utilized just such a concept in one if his applications and he brings us a look at how this works.   Read more...
By Jim Craddock 2005/02/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,902 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,783 reads

Building a 24 x 7 Database

Over the last few years, corporations have invested billions of dollars to integrate the automations of core business systems in large ERP applications. This paper looks at the risk of downtime and solutions for building an around-the-clock database.   Read more...
By Additional Articles 2004/11/24 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,081 reads

An Interview with Ralph Kimball

Ralph Kimball, founder of The Kimbaal Group, shares some thoughts on data with PASS.   Read more...
By Additional Articles 2004/11/08 | Source: PASS | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,153 reads

An Introduction to Database Models

Frank returns this week with a good non academic overview of the different types of database models and some of the features/problems that are native to each.   Read more...
By Frank Kalis 2004/02/12 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,490 reads

Using Bits to Store Data

David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around.   Read more...
By David Poole 2004/01/06 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,364 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

Worst Practice - Defining Rows that Exceed The Max Length

Andy started writing about worst practices a long time ago and returns this week with one that is short and sweet - why defining rows that exceed 8060 characters is a very bad idea and how you can avoid it.   Read more...
By Andy Warren 2003/12/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,721 reads

Store Key - Storing Misc Data

This article proposes a system where extra data is stored in a simple row based table and retrieved using the 'store key'. It's not a new concept of course, but the author explains how and why he chose to implement. Feedback should be interesting!   Read more...
By Narayana Raghavendra 2003/12/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,977 reads

Database Migration Tool

New product designed to help you move from one database platform to another. (Not Reviewed)  Read more...
By Additional Articles 2003/11/21 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,148 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,871 reads

Design A Database Using an Entity-Relationship Diagram

New Author! Ramesh talks a little about database theory, using the ERD, and how you can put it to work.   Read more...
By Ramesh Gummadi 2003/10/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 21,492 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

Problem Solving With Information Schema Columns

Directly accessing system tables is discouraged - so what's the alternative? Using the Information Schema should allow you to create code that survives upgrades. Beyond that, what can you do with it? Joe has four great examples to get you started.   Read more...
By Joseph Sack 2003/09/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 13,458 reads

SQL and Java Go on a Date

Chris discusses some issues he had trying to use SQL dates from within Java. Interesting stuff and brings up the point that if you have dates stored in local time, having users in multiple time zones can be a large headache.   Read more...
By Christoffer Hedgate 2003/09/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,566 reads

Normalizing Dates

Jon has been off in the land of C# and web apps for a while, but a recent project has him investigating OLAP and then coming up with a custom solution that met his needs. Jon helped us get this site off the ground, good to have him back for a guest appearance!   Read more...
By Jon Winer 2003/09/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,167 reads
<< Newer    Items 21 to 40 of 53    Older >>
 
Tags
programming (14)    
strategies (9)    
sql server 7 (8)    
t-sql (7)    
administration (6)    
basics (4)    
configuring (4)    
visual basic 6 (3)    
advanced (2)    
best and worst practices (2)    
book reviews (2)    
career (2)    
certifications (2)    
data warehousing (2)    
monitoring (2)    
naming standards (2)    
reviews (2)    
stored procedures (2)    
ado (1)    
best practices (1)    
data types (1)    
indexing (1)    
installation (1)    
performance tuning (1)    
sql-dmo (1)    
worst practices (1)    
xml (1)