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

Content with tags Strategies, Miscellaneous Rss

   Items 1 to 20 of 91    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

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,382 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,763 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,542 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,616 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 | 3,215 reads

An Auditing Solution with XML And XSL

Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.   Read more...
By David McKinney 2007/08/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,985 reads

10 things you can do to give old servers a second life

To run with the pack in terms of performance, productivity, and competition, servers that are long in the tooth have to be put out to pasture regularly. But there might be (and usually is) some life left in these early retirees, and they can still be put to good use.  Read more...
By Additional Articles 2007/08/17 | Source: Builder.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,744 reads

How Much Scalability Do You Have or Need?

How many cores (or hardware threads) can your code harness to get its answers faster?  Read more...
By Additional Articles 2007/08/16 | Source: Dr. Dobbs | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,736 reads

Service-Component Architectures

Service-Component Architectures (SCA) provide a programming model for implementing Service-Oriented Architectures (SOA)  Read more...
By Additional Articles 2007/08/14 | Source: Dr. Dobbs | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,770 reads

Compatibility of SQL Server 2005 and 2000 coexisting

When installing a SQL Server 2005 instance on your SQL 2000 machine, there are upgrade and compability issues such as linked servers, multi-server administration and log shipping.  Read more...
By Additional Articles 2007/08/06 | Source: SearchSQLServer | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,126 reads

Server Farm Reporting - Part 1

Managing a large number of servers can be quite the challenge for many DBAs and it seems to get worse each year as more servers are added without an increase in staffing. New author Mark Tierney brings us the first part of a series on the framework he's built to help manage his servers.   Read more...
By Mark Tierney 2007/08/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,229 reads

Server System Architecture, 2007

A look at Intel and AMD architectures for the future.   Read more...
By Additional Articles 2007/07/16 | Source: SQL Server Performance | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,972 reads

Optimize disk configuration in SQL Server

Proper disk configuration can result in a lifetime of high performance for SQL Server databases. Go beyond storage capacity requirements and consider drive performance.  Read more...
By Additional Articles 2007/07/04 | Source: SearchSQLServer | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,026 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,382 reads

Use SQLIOSIM to simulate SQL Server disk activity

I regularly use SQLIO.EXE to gauge the maximum throughput a disk subsystem can sustain. Recently Microsoft released SQLIOSIM.EXE to provide better results for this type of test. However they didn't release any documentation on the tool and I could never figure out what it was trying to tell me. It looks like they finally did release a Knowledge Base article on SQLIOSIM. Give it a spin. I'd be curious to hear what you think of the tool.   Read more...
By Additional Articles 2007/03/30 | Source: Microsoft MSDN | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,414 reads

Citrix MetaFrame, SQL Server, and the DBA

In this article, Brian looks at how Citrix MetaFrame can use SQL Server for its internal data repository. The basic operation of SQL Server in a Citrix MetaFrame installation is covered. In addition, Brian looks at how a DBA is an integral part of the support team for a successful Citrix MetaFrame farm.   Read more...
By Brian Kelley 2007/03/02 (first published: 2002/05/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 26,393 reads

Why RAID is (usually) a Terrible Idea

Your development system might be as valuable as your servers, but is it worth setting up with RAID? Read an interesting argument from one of the largest custom computer builder.  Read more...
By Additional Articles 2007/02/14 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 6,473 reads

Processing event logs using DumpEvt and SQL Server

As a DBA, you can find very useful information in the Windows event logs. About important events, the health of your SQL Server and the operating system it runs on. Unfortunately, the logs also contain a lot of useless information. Some applications have a tendency to log hundreds of events every day, filling up the logs very quickly with info that you, as a DBA, do not need. But you still need to see that important message that informs you the server is going to crash if you don’t take action.   Read more...
By Additional Articles 2006/12/28 | Source: SQL Server Performance | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,998 reads

Contract Coding: Ensuring your Client pays up

Damon Armstrong learned the hard way about the consequences of not having a clearly defined project scope or work contract  Read more...
By Additional Articles 2006/10/27 | Source: Red-Gate | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,640 reads
   Items 1 to 20 of 91    Older >>
 
Tags
sql server 7 (29)    
programming (24)    
administration (20)    
t-sql (14)    
database design (9)    
configuring (7)    
security (6)    
system development life cycle (6)    
visual basic 6 (6)    
availability (5)    
.net (4)    
best and worst practices (4)    
career (4)    
naming standards (4)    
performance tuning (4)    
stored procedures (4)    
backup / restore (3)    
disaster recovery (dr) (3)    
sql server 2005 (3)    
worst practices (3)    
book reviews (2)    
certifications (2)    
indexing (2)    
monitoring (2)    
replication (2)    
reviews (2)    
sql-dmo (2)    
xml (2)    
advanced querying (1)    
analysis services (ssas) (1)    
best practices (1)    
data mining (1)    
data types (1)    
data warehousing (1)    
development (1)    
dts (1)    
olap server (1)    
sql puzzles (1)    
state of the business (1)    
xsl (1)