http://www.sqlservercentral.com/Articles tagged Strategies posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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. http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/2008/06/27http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/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. http://www.sqlservercentral.com/articles/Naming+Standards/bestpracticesfordatabasedesign/1815/2008/06/20http://www.sqlservercentral.com/articles/Naming+Standards/bestpracticesfordatabasedesign/1815/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. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3004/2008/05/19http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3004/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. http://www.sqlservercentral.com/articles/Miscellaneous/isxmltheanswer/1147/2008/05/02http://www.sqlservercentral.com/articles/Miscellaneous/isxmltheanswer/1147/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. http://www.sqlservercentral.com/articles/Miscellaneous/2875/2008/02/21http://www.sqlservercentral.com/articles/Miscellaneous/2875/This article, part 4 in a series, discusses how to use, publish, maintain and govern the enterprise architecture.http://www.sqlservercentral.com/redirect/articles/61866/2008/01/29http://www.sqlservercentral.com/redirect/articles/61866/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. http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/2008/01/18http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/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. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/2805/2008/01/16http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/2805/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.http://www.sqlservercentral.com/redirect/articles/61919/2008/01/15http://www.sqlservercentral.com/redirect/articles/61919/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. http://www.sqlservercentral.com/articles/Security/2773/2007/12/26http://www.sqlservercentral.com/articles/Security/2773/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 developmenthttp://www.sqlservercentral.com/redirect/articles/61200/2007/10/12http://www.sqlservercentral.com/redirect/articles/61200/Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques. http://www.sqlservercentral.com/articles/Miscellaneous/3242/2007/10/08http://www.sqlservercentral.com/articles/Miscellaneous/3242/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. http://www.sqlservercentral.com/articles/Miscellaneous/3211/2007/10/03http://www.sqlservercentral.com/articles/Miscellaneous/3211/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. http://www.sqlservercentral.com/articles/Security/3203/2007/10/02http://www.sqlservercentral.com/articles/Security/3203/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. http://www.sqlservercentral.com/articles/Miscellaneous/3178/2007/10/01http://www.sqlservercentral.com/articles/Miscellaneous/3178/This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, Using .NET features to prevent attacks, and Importance of handling exceptionshttp://www.sqlservercentral.com/redirect/articles/3239/2007/09/19http://www.sqlservercentral.com/redirect/articles/3239/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 Modificationshttp://www.sqlservercentral.com/redirect/articles/3240/2007/09/18http://www.sqlservercentral.com/redirect/articles/3240/Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules. http://www.sqlservercentral.com/redirect/articles/3207/2007/09/10http://www.sqlservercentral.com/redirect/articles/3207/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. http://www.sqlservercentral.com/redirect/articles/3195/2007/09/04http://www.sqlservercentral.com/redirect/articles/3195/Alex and Alex continue their series of three articles on 'Unit Testing' database development work with some examples of unit testing stored procedures. http://www.sqlservercentral.com/redirect/articles/3204/2007/08/31http://www.sqlservercentral.com/redirect/articles/3204/Scott examines strategies for dealing with constraints that business stakeholders may put on software development teams. http://www.sqlservercentral.com/redirect/articles/3193/2007/08/29http://www.sqlservercentral.com/redirect/articles/3193/Learn about 13 production disasters that can bring down your businesshttp://www.sqlservercentral.com/redirect/articles/3173/2007/08/23http://www.sqlservercentral.com/redirect/articles/3173/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. http://www.sqlservercentral.com/articles/Security/3179/2007/08/20http://www.sqlservercentral.com/articles/Security/3179/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.http://www.sqlservercentral.com/redirect/articles/3162/2007/08/17http://www.sqlservercentral.com/redirect/articles/3162/How many cores (or hardware threads) can your code harness to get its answers faster?http://www.sqlservercentral.com/redirect/articles/3165/2007/08/16http://www.sqlservercentral.com/redirect/articles/3165/Service-Component Architectures (SCA) provide a programming model for implementing Service-Oriented Architectures (SOA)http://www.sqlservercentral.com/redirect/articles/3166/2007/08/14http://www.sqlservercentral.com/redirect/articles/3166/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.http://www.sqlservercentral.com/redirect/articles/3115/2007/08/06http://www.sqlservercentral.com/redirect/articles/3115/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. http://www.sqlservercentral.com/articles/Miscellaneous/3103/2007/08/01http://www.sqlservercentral.com/articles/Miscellaneous/3103/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. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3119/2007/07/30http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3119/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. http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3004/2008/05/19http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/3004/