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 » Development   (RSS)
Showing page 1 of 6 (53 total posts)
  • How In-Memory Database Objects Affect Database Design: Hybrid Code

    In my first attempts at building my code, I strictly went with either native or on-disk code. I specifically wrote the on-disk code to only use features that worked in-memory. This lead to one majorly silly bit of code, used to create system assigned key values. How would I create a customer number that was unique. We can’t use the Max(value) + 1 ...
    Posted to Louis Davidson (Weblog) by drsql on August 8, 2014
  • Cloud Computing Architecture Patterns: Don’t Focus on the Client

    Normally I try to put topics in the positive in other words ''Do this'' not ''Don't do that''. Sometimes its clearer to focus on what *not* to do. Popular development processes often start with screen mockups, or user input descriptions. In a scale-out pattern like Cloud Computing on Windows Azure, that's the wrong place to start. Start with the ...
    Posted to Buck Woody (Weblog) by BuckWoody on June 6, 2013
  • One more reason to to understand query plans, not directly performance related

    One of the things that separates a good programmer from a great one is a firm understanding about what is going on inside the computer. For some programming languages, it is very obvious what is going on inside the computer because you are working at a very low level. For example, if you are a C/C++ programmer writing an OS, you will know a lot ...
    Posted to Louis Davidson (Weblog) by drsql on January 22, 2013
  • Cloud Computing - just get started already!

    OK - you've been hearing about ''cloud'' (I really dislike that term, but whatever) for over two years. You've equated it with just throwing some VM's in some vendor's datacenter - which is certainly part of it, but not the whole story. There's a whole world of - wait for it - *coding* out there that you should be working on. If you're a ...
    Posted to Buck Woody (Weblog) by BuckWoody on October 30, 2012
  • Utility Queries–Structure of Tables with Identity Column

    Edit: At the suggestion of a much knowledgable commenter who shall remain named Aaron, I changed from using schema_name() function to using sys.tables. When writing code that is expected to have reuse, it can be safer to use the tables rather than functions because the tables will work in the context of the database that is in the from ...
    Posted to Louis Davidson (Weblog) by drsql on September 2, 2012
  • Windows Azure End to End Examples

    I’m fascinated by the way people learn. I’m told there are several methods people use to understand new information, from reading to watching, from experiencing to exploring. Personally, I use multiple methods of learning when I encounter a new topic, usually starting with reading a bit about the concepts. I quickly want to put those into ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 29, 2012
  • 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
  • Java Resources for Windows Azure

    Windows Azure is a Platform as a Service – a PaaS – that runs code you write. That code doesn’t just mean the languages on the .NET platform – you can run code from multiple languages, including Java. In fact, you can develop for Windows and SQL Azure using not only Visual Studio but the Eclipse Integrated Development ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 12, 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement