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

Content with tags Programming, Strategies Rss

   Items 1 to 20 of 29    Older >>
 

Using DMO to Restore a Database

This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.   Read more...
By Andy Warren 2006/06/16 (first published: 2001/05/07) | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 24,529 reads

Dynamic SQL or Stored Procedure

We'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't.   Read more...
By Andy Warren 2005/08/26 (first published: 2003/04/23) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 47,237 reads

Single Point of Administration

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.   Read more...
By Jonathan Stokes 2005/08/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,911 reads

Worst Practices - Part 1 of a Very Long Series!

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!   Read more...
By Andy Warren 2004/12/03 (first published: 2001/10/09) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 33,727 reads

Architecting Disconnected Mobile Applications Using a Service Oriented

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)  Read more...
By Additional Articles 2004/10/13 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,389 reads

Dealing With Changing Data

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're building web/disconnected apps and need anything besides last update wins, this one is for you.   Read more...
By Christoffer Hedgate 2003/12/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,421 reads

Custom Log Shipping

One of our favorite authors is back with a great how-to on log shipping. This isn'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't need it now, it's worth looking at to gain a better understanding of how shipping works.   Read more...
By Chris Kempster 2003/11/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,254 reads

Managing Jobs - Part 4

Andy has been busy lately on a project you'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's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.   Read more...
By Andy Warren 2003/06/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,980 reads

Lessons from my first Project as a Project Manager

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's interesting to see things from the other (not developer or DBA) point of view.   Read more...
By David Poole 2003/06/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,727 reads

Customers Don't Know What They Want

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't be seen (yeah, the code!). It's actually more interesting than that, take a look!  Read more...
By Additional Articles 2003/06/03 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,000 reads

An Automated Solution for Migrating Database Structures

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've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.  Read more...
By Additional Articles 2003/05/06 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 2,225 reads

Dynamic SQL or Stored Procedure

We'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't.   Read more...
By Andy Warren 2005/08/26 (first published: 2003/04/23) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 47,237 reads

Change Management

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.  Read more...
By Chris Kempster 2003/03/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,891 reads

Managing Jobs Part 3

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't.   Read more...
By Andy Warren 2003/03/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,109 reads

Managing Jobs - Part 2

Jobs are pretty basic aren'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!   Read more...
By Andy Warren 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,336 reads

Managing Jobs - Part 1

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'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.   Read more...
By Andy Warren 2003/01/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,435 reads

Worst Practice - Bad Comments

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's room for discussion here, but definitely a discussion worth having - comments can make you or break you, here's a chance to think about what you think is important in commenting and pass that on to your development team.   Read more...
By Andy Warren 2003/01/23 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,403 reads

Another Disaster (Almost)

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.   Read more...
By Andy Warren 2003/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,034 reads

Creating Your Dream Project

In this article, columnist Christopher Duncan shows you how to create your dream development project.   Read more...
By Christopher Duncan 2002/11/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,647 reads

VBScript Classes to Query SQL Server for Backup Information

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.   Read more...
By Bruce Szabo 2002/08/22 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,115 reads
   Items 1 to 20 of 29    Older >>
 
Tags
miscellaneous (24)    
sql server 7 (15)    
administration (11)    
t-sql (9)    
database design (6)    
visual basic 6 (6)    
configuring (5)    
.net (4)    
naming standards (4)    
sql-dmo (4)    
stored procedures (4)    
disaster recovery (dr) (3)    
security (3)    
system development life cycle (3)    
availability (2)    
backup / restore (2)    
book reviews (2)    
career (2)    
certifications (2)    
monitoring (2)    
performance tuning (2)    
reviews (2)    
best and worst practices (1)    
replication (1)    
sql puzzles (1)    
worst practices (1)