THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices » Development   (RSS)
  • Preparation is key to a successful cloud deployment

    If you want to be wise, watch the actions and outcomes of others. Emulate the successful actions, and avoid the actions that cause failure. That’s true in life in general - and in technology projects in specific.  I’ve worked with several clients who have created or migrated an application to “the cloud” - meaning using Microsoft Windows ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 1, 2012
  • Cloud Computing Patterns: Using Data Transaction Commitment Models for Design

    There are multiple ways to store data in a cloud provider, specifically around Windows and SQL Azure. As part of a “Data First” architecture design, one decision vector – assuming you’ve already done a data classification of the elements you want to store – is to decide the transaction level you need for that ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 14, 2012
  • Application Lifecycle Management Overview for Windows Azure

    Developing in Windows Azure is at once not that much different from what you’re familiar with in on-premises systems, and different in significant ways. Because of these differences, developers often ask about the specific process to develop and deploy a Windows Azure application - more formally called an Application Lifecycle Management, or ALM. ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 7, 2012
  • Rip and Replace or Extend and Embrace?

    As most of you know, I don’t like the term “cloud” very much. It isn’t defined, which means it can be anything. I prefer “distributed computing”, which is more technically accurate and describes what you’re doing in more concrete terms. So when you think about Windows and SQL Azure, you don’t have ...
    Posted to Buck Woody (Weblog) by BuckWoody on September 13, 2011
  • Plan for Diagnostics in Cloud Computing From the Git-Go

    “Git-Go” is something we say in the South that means “right at the start”. I’ve seen several applications for on-premise systems that don’t have much in the way of diagnostics - the developers rely on a debugger, the event logs on the server and client workstation, and most of all, the ability to watch the system from end-to-end. This approach ...
    Posted to Buck Woody (Weblog) by BuckWoody on September 6, 2011
  • Cloud Computing and the Importance of Code Diagrams

    Most mature development shops use various code diagrams to give a symbolic representation of high-level and database code structures. Standards such as Business Process Model Notation (BPMN), Entity Relationship Diagrams (ERD) and the Unified Modeling Language (UML) are a few I use all the time. In the Distributed Computing (Cloud Computing) ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 3, 2011
  • SQL Server Best Practices: Protect CmdExec

    In SQL Server, there are times that you need to do things in the operating system, and to allow that there is a feature called CmdExec. This is not always a good thing –whenever you leave the confines of SQL Server and go out to the operating system, you can cause issues, not the least of which are security-related. This best practice is ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 3, 2009
  • What is a physical database?

    A bit of terminology that gets beaten to death is that of the “physical” database.  I would think most every DBA uses this term (I do), but…to mean what?  I think there are two common utilizations: The layer of tables, constraints, indexes, etc used to store data The actual on-disk structures. Frankly, until 3 years ago, I ...
    Posted to Louis Davidson (Weblog) by drsql on June 11, 2009
  • disallow results from triggers

    A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.  Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor usage of them will allow you to shoot your foot off in a heartbeat as I discussed in my earlier ...
    Posted to Louis Davidson (Weblog) by drsql on June 6, 2009
  • Data correctness during the development process

    During all phases of development, particularly when building a completely new system, it is very common to have a need for data to test with.  As important as this is for a UI system, the need is doubled is when you are working on a reporting system.  While Everyone knows that the process of getting test data can be a fickle ...
    Posted to Louis Davidson (Weblog) by drsql on October 9, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement