﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Articles tagged Strategies, Programming</title><link>http://www.sqlservercentral.com/</link><description>Articles tagged Strategies, Programming posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Using DMO to Restore a Database</title><description><![CDATA[This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.

]]></description><guid>http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/</guid><pubDate>2006/06/16</pubDate><link>http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/</link></item><item><title>Dynamic SQL or Stored Procedure</title><description><![CDATA[We&#39;ve had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can&#39;t.


]]></description><guid>http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/</guid><pubDate>2005/08/26</pubDate><link>http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/</link></item><item><title>Single Point of Administration</title><description><![CDATA[Whether you write TSQL code or front end VB code against your SQL Server, it pays to have some good development practices that make your life easier. Jonathan Stokes has written a good article showing some of the good practices you should use.
]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/singlepointofadministration/2010/</guid><pubDate>2005/08/15</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/singlepointofadministration/2010/</link></item><item><title>Worst Practices - Part 1 of a Very Long Series!</title><description><![CDATA[Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!


]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticespart1ofaverylongseries/471/</guid><pubDate>2004/12/03</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticespart1ofaverylongseries/471/</link></item><item><title>Architecting Disconnected Mobile Applications Using a Service Oriented</title><description><![CDATA[The Windows Mobile platform, which includes Microsoft .NET Compact Framework and Microsoft SQL Server CE, encapsulates the complex tasks of communication management and data exchange while your device is in a disconnected state. (16 printed pages)]]></description><guid>http://www.sqlservercentral.com/redirect/articles/1540/</guid><pubDate>2004/10/13</pubDate><link>http://www.sqlservercentral.com/redirect/articles/1540/</link></item><item><title>Dealing With Changing Data</title><description><![CDATA[As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you&#39;re building web/disconnected apps and need anything besides last update wins, this one is for you.
<!-- Free trial of SQL Backup™ -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup"><img alt="SQL Backup" height="68" src="http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Free trial of SQL Backup™</strong><br />“SQL Backup was able to cut down my backup time <br>significantly AND achieved a 90% compression at <br>the same time!” Joe Cheng. <a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup">Download a free trial now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/articles/Performance+Tuning/dealingwithchangingdata/1233/</guid><pubDate>2003/12/19</pubDate><link>http://www.sqlservercentral.com/articles/Performance+Tuning/dealingwithchangingdata/1233/</link></item><item><title>Custom Log Shipping</title><description><![CDATA[One of our favorite authors is back with a great how-to on log shipping. This isn&#39;t the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don&#39;t need it now, it&#39;s worth looking at to gain a better understanding of how shipping works.
]]></description><guid>http://www.sqlservercentral.com/articles/Administration/customlogshipping/1201/</guid><pubDate>2003/11/26</pubDate><link>http://www.sqlservercentral.com/articles/Administration/customlogshipping/1201/</link></item><item><title>Managing Jobs - Part 4</title><description><![CDATA[Andy has been busy lately on a project you&#39;ll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA&#39;s, if you&#39;re not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.
]]></description><guid>http://www.sqlservercentral.com/articles/Administration/managingjobspart4/1037/</guid><pubDate>2003/06/25</pubDate><link>http://www.sqlservercentral.com/articles/Administration/managingjobspart4/1037/</link></item><item><title>Lessons from my first Project as a Project Manager</title><description><![CDATA[David tries his hand at Project Management and what follows is a list of tips and problems from that experience. As David points out, it&#39;s interesting to see things from the other (not developer or DBA) point of view.
]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/lessonsfrommyfirstprojectasaprojectmanager/1006/</guid><pubDate>2003/06/04</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/lessonsfrommyfirstprojectasaprojectmanager/1006/</link></item><item><title>Customers Don't Know What They Want</title><description><![CDATA[This article on the JoelonSoftware site discusses project management and customer expectations. It has a great discussion of why non-technical users place so much value on what they can see (the GUI) while developers place so much value in what can&#39;t be seen (yeah, the code!). It&#39;s actually more interesting than that, take a look!]]></description><guid>http://www.sqlservercentral.com/redirect/articles/1002/</guid><pubDate>2003/06/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/1002/</link></item><item><title>An Automated Solution for Migrating Database Structures</title><description><![CDATA[This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you&#39;ve never seen the need for a schema compare tool (Steve Jones!), this is worth reading.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/982/</guid><pubDate>2003/05/06</pubDate><link>http://www.sqlservercentral.com/redirect/articles/982/</link></item><item><title>Dynamic SQL or Stored Procedure</title><description><![CDATA[We&#39;ve had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can&#39;t.


]]></description><guid>http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/</guid><pubDate>2005/08/26</pubDate><link>http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/</link></item><item><title>Change Management</title><description><![CDATA[This article looks at change management from the perspective of the DBA, including how to use source control to your advantage and planning for 'self-healing' apps.]]></description><guid>http://www.sqlservercentral.com/articles/Administration/changemanagement/939/</guid><pubDate>2003/03/18</pubDate><link>http://www.sqlservercentral.com/articles/Administration/changemanagement/939/</link></item><item><title>Managing Jobs Part 3</title><description><![CDATA[This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn&#39;t.
]]></description><guid>http://www.sqlservercentral.com/articles/Administration/managingjobspart3/936/</guid><pubDate>2003/03/11</pubDate><link>http://www.sqlservercentral.com/articles/Administration/managingjobspart3/936/</link></item><item><title>Managing Jobs - Part 2</title><description><![CDATA[Jobs are pretty basic aren&#39;t they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!
]]></description><guid>http://www.sqlservercentral.com/articles/Administration/managingjobspart2/919/</guid><pubDate>2003/02/14</pubDate><link>http://www.sqlservercentral.com/articles/Administration/managingjobspart2/919/</link></item><item><title>Managing Jobs - Part 1</title><description><![CDATA[How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn&#39;t work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.
]]></description><guid>http://www.sqlservercentral.com/articles/Administration/managingjobspart1/906/</guid><pubDate>2003/01/31</pubDate><link>http://www.sqlservercentral.com/articles/Administration/managingjobspart1/906/</link></item><item><title>Worst Practice - Bad Comments</title><description><![CDATA[This one is pretty interesting, Andy discusses a few things he sees in comments that not only fail to add value, they end up costing extra time. There&#39;s room for discussion here, but definitely a discussion worth having - comments can make you or break you, here&#39;s a chance to think about what you think is important in commenting and pass that on to your development team.

]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticebadcomments/893/</guid><pubDate>2003/01/23</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticebadcomments/893/</link></item><item><title>Another Disaster (Almost)</title><description><![CDATA[Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.
]]></description><guid>http://www.sqlservercentral.com/articles/Administration/anotherdisasteralmost/881/</guid><pubDate>2003/01/14</pubDate><link>http://www.sqlservercentral.com/articles/Administration/anotherdisasteralmost/881/</link></item><item><title>Creating Your Dream Project</title><description><![CDATA[In this article, columnist Christopher Duncan shows you how to create your dream development project.
<!-- SQL Server monitoring made easy -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse"><img alt="SQL Response" height="68" src="http://www.red-gate.com/images/marketing/SSC/response_ico.gif" width="68" border="0"/></a></td>
  <td><strong>SQL Server monitoring made easy </strong><br />"Keeping an eye on our many SQL Server instances<br> is much easier  with SQL Response." Mike Lile.<br><a href="http://www.red-gate.com/products/SQL_Response/offers/easy_monitoring.htm?utm_source=ssc&utm_medium=rss&utm_content=easy_monitoring200912&utm_campaign=sqlresponse">Download a free trial of SQL Response now. </a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/creatingyourdreamproject/851/</guid><pubDate>2002/11/15</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/creatingyourdreamproject/851/</link></item><item><title>VBScript Classes to Query SQL Server for Backup Information</title><description><![CDATA[A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.

]]></description><guid>http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups1/783/</guid><pubDate>2002/08/22</pubDate><link>http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups1/783/</link></item><item><title>The Case for SQL Logins - Part Two</title><description><![CDATA[In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.

]]></description><guid>http://www.sqlservercentral.com/articles/Administration/thecaseforsqlloginsparttwo/780/</guid><pubDate>2002/08/19</pubDate><link>http://www.sqlservercentral.com/articles/Administration/thecaseforsqlloginsparttwo/780/</link></item><item><title>Review of Refactoring: Improving the Design of Existing Code</title><description><![CDATA[It&#39;s not a SQL book and the code examples are in Java, but there is a lot to like about this book. What is refactoring? How would you find it useful? Read the review to find out!
]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/reviewofrefactoringimprovingthedesignofexistingcod/722/</guid><pubDate>2002/07/02</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/reviewofrefactoringimprovingthedesignofexistingcod/722/</link></item><item><title>Version Control for Stored Procedures</title><description><![CDATA[Version control for stored procedures isn&#39;t always popular and certainly isn&#39;t easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.
]]></description><guid>http://www.sqlservercentral.com/articles/Administration/versioncontrolforstoredprocedures/681/</guid><pubDate>2002/05/10</pubDate><link>http://www.sqlservercentral.com/articles/Administration/versioncontrolforstoredprocedures/681/</link></item><item><title>Analyzing Requirements and Defining Solution Architectures</title><description><![CDATA[Andy says it&#39;s not the greatest book for preparing for the 70-100 exam, but the case study is worth reading for it&#39;s explanation of the Microsoft Solution Framework. Read the full review!
]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/analyzingrequirementsanddefiningsolutionarchitectu/561/</guid><pubDate>2002/01/02</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/analyzingrequirementsanddefiningsolutionarchitectu/561/</link></item><item><title>70-100 MCSD Architectures Exam Cram</title><description><![CDATA[Should you use this book to prepare for the 70-100 exam? Read the review and find out!
]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/70100mcsdarchitecturesexamcram/562/</guid><pubDate>2001/12/26</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/70100mcsdarchitecturesexamcram/562/</link></item><item><title>Enforcing Security in Multi-Tier Applications</title><description><![CDATA[The major part of the article, however, is dedicated to a topic that often confuses people and leads to some of the strongest disagreements among IT professionals and developers: the benefits and drawbacks of enforcing security in the middle (or business) tier versus the data tier.
]]></description><guid>http://www.sqlservercentral.com/redirect/articles/558/</guid><pubDate>2001/12/25</pubDate><link>http://www.sqlservercentral.com/redirect/articles/558/</link></item><item><title>Worst Practices - Part 1 of a Very Long Series!</title><description><![CDATA[Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!


]]></description><guid>http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticespart1ofaverylongseries/471/</guid><pubDate>2004/12/03</pubDate><link>http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticespart1ofaverylongseries/471/</link></item><item><title>Executing Multiple Scripts in a Folder using the ScriptRunner Utility</title><description><![CDATA[Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.
]]></description><guid>http://www.sqlservercentral.com/articles/Administration/scriptrunner/292/</guid><pubDate>2001/06/14</pubDate><link>http://www.sqlservercentral.com/articles/Administration/scriptrunner/292/</link></item><item><title>Using DMO to Restore a Database</title><description><![CDATA[This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.

]]></description><guid>http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/</guid><pubDate>2006/06/16</pubDate><link>http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/</link></item></channel></rss>