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

Articles with tag Strategies Rss

Search for any content tagged strategies

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

SQL Server patch pros and cons

A patch to your SQL Server system can cause problems, but an unpatched SQL Server is unprotected. Learn the pros and cons of SQL Server patches.   Read more...
By Additional Articles 2007/09/04 | Source: SearchSQLServer | Category: security
Rating:  Rate this |   Briefcase | 2,306 reads

Close those Loopholes - Testing Stored Procedures

Alex and Alex continue their series of three articles on 'Unit Testing' database development work with some examples of unit testing stored procedures.   Read more...
Rating:  Rate this |   Briefcase | 3,814 reads

Agile on a Fixed Budget

Scott examines strategies for dealing with constraints that business stakeholders may put on software development teams.   Read more...
By Additional Articles 2007/08/29 | Source: Dr. Dobbs | Category: system development life cycle
Rating:  Rate this |   Briefcase | 2,095 reads

13 disasters for production web sites and their solutions

Learn about 13 production disasters that can bring down your business  Read more...
By Additional Articles 2007/08/23 | Source: CodeProject.com | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 3,683 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,988 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,750 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,737 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,772 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,134 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

Revisit What You Know

A thought provoking article from SQL Server expert and trainer Andy Warren. As a DBA you should think about the rules and decrees you have developed over the years and revisit them for application in your current situation.   Read more...
Rating: |  Discuss |   Briefcase | 3,505 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,274 reads

Encryption: Not the End-All Fix for Data Privacy

Many state data-breach laws exempt encrypted data from PR-nightmare public-notice requirements, but don't let that fool you into thinking it's an easy answer to the data privacy challenge. Here's the lowdown on loopholes, caveats and options to consider when applying encryption.  Read more...
By Additional Articles 2007/07/17 | Source: Intelligent Enterprise | Category: security
Rating:  Rate this |   Briefcase | 1,942 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,973 reads

Stop SQL Injection Attacks Before They Stop You

This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.  Read more...
By Additional Articles 2007/07/09 | Source: MSDN Communities | Category: security
Rating:  Rate this |   Briefcase | 4,170 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,028 reads

SQL 2000 DBA Toolkit Part 1

SQL Server 2005 builds some great encryption tools into the product, but what if you are stuck with SQL Server 2000? SQL Server expert Michael Coles brings us the first part of a series along with a free toolkit to manage encryption and keys.   Read more...
By Michael Coles 2007/06/22 (first published: 2006/04/13) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 30,273 reads

Maintaining a Log of Database Changes - Part 1

This article looks at logging your database changes from a developer's perspective.   Read more...
Rating:  Rate this |   Briefcase | 4,272 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,383 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,417 reads
<< Newer    Items 21 to 40 of 258    Older >>