SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Strategies Rss

   Items 1 to 20 of 258    Older >>

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,510 reads

In The Real World - Disaster!

A real world account of disaster recovery. (This article is being republished after the recent hurricane that hit the US East Coast).   Read more...
By Steve Jones 2012/12/12 (first published: 2002/04/22) | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 9,633 reads

Log Shipping vs. Replication

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.   Read more...
By Paul Ibison 2008/06/27 (first published: 2004/06/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 60,056 reads

Best Practices for Database Design

One of the few things that SQL Server does not automatically help you with is the design of your tales, views, and other database objects. Having standards and design techniques can greatly ease the maintenance of your schema as well as ease the transition to having others work with the database. New author J.D. Gonzalez brings us some of his naming techniques to keep things organized.   Read more...
By J.D. Gonzalez 2008/06/20 (first published: 2005/04/06) | Source: SQLServerCentral.com | Category: naming standards
Rating: |  Discuss |   Briefcase | 50,189 reads

Tracking Database Schema Changes with DbPro

Tracking changes to your development environments is important to ensure that your deployments to production go smoothly. Jacob Sebastion brings us a look at how well the Visual Studio Team System Edition for Database Professionals can help you with this task.   Read more...
Rating: |  Discuss |   Briefcase | 6,311 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,233 reads

Keyword Searching in SQL Server

Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers.   Read more...
By Michael Ahmadi 2007/04/09 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,439 reads

Enterprise Architecture – Connect-the-Dots for Adults, Part 4

This article, part 4 in a series, discusses how to use, publish, maintain and govern the enterprise architecture.  Read more...
By Additional Articles 2008/01/29 | Source: TDAN | Category: strategies
Rating: (not yet rated)  Rate this |   Briefcase | 3,260 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...
By Brian Knight 2008/01/18 (first published: 2002/07/12) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 152,991 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...
Rating: |  Discuss |   Briefcase | 7,326 reads

Application Locks (or Mutexes) in SQL Server 2005

Application locks aren't a well known area of locking in SQL Server, but they can be very useful for special scenarios. They work in an analogous way to the lock() construct in .Net and are basicaly user defined mutexes in SQL Server.  Read more...
By Additional Articles 2008/01/15 | Source: SQLTeam.com | Category: strategies
Rating:  Rate this |   Briefcase | 4,039 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,657 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,592 reads

Partitioning - Part 2

Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.   Read more...
By Andy Warren 2007/10/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,992 reads

The Troubleshooting List

SQL Server guru Andy Warren brings us a list of things that he considers when things go wrong. Read about some of the common sense approaches to solving performance and other problems.   Read more...
By Andy Warren 2007/10/03 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,562 reads

SQL Server and SOX

The Sarbanes-Oxley act has changed many IT jobs, usually requiring more work and documentation. Johan Bijnens brings us a list of some things his team has had to do to comply with SOX regulations.   Read more...
By Johan Bijnens 2007/10/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,339 reads

Working Your SOX Off

The Sarbanes-Oxley act has drastically changed the jobs of many DBAs with the audit and reporting requirements this act entails. Brandie Tarvin brings us some hints about how you can go about complying with the new requirements.   Read more...
By Brandie Tarvin 2007/10/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,633 reads

Stop SQL Injection Attacks Before They Stop You

This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, Using .NET features to prevent attacks, and Importance of handling exceptions  Read more...
By Additional Articles 2007/09/19 | Source: MSDN Communities | Category: security
Rating:  Rate this |   Briefcase | 4,870 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...
Rating:  Rate this |   Briefcase | 3,423 reads

What Specification Server Should I Buy?

Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules.   Read more...
By Additional Articles 2007/09/10 | Source: SimpleTalk | Category: miscellaneous
Rating:  Rate this |   Briefcase | 4,328 reads
   Items 1 to 20 of 258    Older >>
miscellaneous (84)    
sql server 7 (64)    
system development life cycle (58)    
disaster recovery (dr) (42)    
security (40)    
administration (36)    
programming (26)    
t-sql (20)    
database design (19)    
availability (16)    
naming standards (15)    
best and worst practices (10)    
configuring (10)    
sql server 2005 (9)    
backup and restore (8)    
performance tuning (7)    
visual basic 6 (6)    
worst practices (6)    
advanced querying (5)    
stored procedures (5)    
.net (4)    
best practices (4)    
career (4)    
installation (4)    
replication (4)    
reviews (4)    
sql-dmo (4)    
basics (3)    
monitoring (3)    
sql server 6.5 (3)    
book reviews (2)    
certifications (2)    
datatypes (2)    
development (2)    
dts (2)    
indexing (2)    
other (2)    
product reviews (2)    
xml (2)    
advanced (1)    
analysis services (ssas) (1)    
data mining (1)    
data modeling (1)    
data warehousing (1)    
high availability (ha) (1)    
kpis (1)    
news (1)    
olap server (1)    
rants (1)    
sql puzzles (1)    
sqlservercentral (1)    
state of the business (1)    
xsl (1)