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   (RSS)
Showing page 5 of 16 (157 total posts)
  • “I could use a little help here” or “I can do it myself, thank you” for Cloud Projects

    Windows Azure allows you to write code in languages within the .NET stack, you can use Java, C++, PHP, NodeJS and others. Code is code - other than keeping things stateless, using a Web or Worker Role in Azure is not all that different from working with an on-premises system. However…. Working in a scalable, component-based stateless ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 3, 2012
  • Why do I need two Instances in Windows Azure?

    Windows Azure as a Platform as a Service (PaaS) means that there are various components you can use in it to solve a problem: Compute “Roles” - Computers running an OS and optionally IIS - you can have more than one ''Instance'' of a given Role Storage - Blobs, Tables and Queues for Storage Other Services - Things like the ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 20, 2012
  • Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

    Here's an evergreen question. It's a question that never completely goes away. But lately, I've been getting it a few times per week. So I thought it's time to readdress the question, which usually takes some form of the following:I can't really do effective development on my little dev laptop because our production SQL Server database is 15 ...
    Posted to Kevin Kline (Weblog) by KKline on March 16, 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
  • Bad Habits to Kick : Thinking a WHILE loop isn't a CURSOR

    I see a lot of people suggest while loops instead of cursors in situations where row-based processing is required (or, at least, where folks think that row-based processing is required). Sometimes the justification is that constructing a while loop is simpler and more straightforward than constructing a cursor. Others suggest that a while loop is ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 26, 2012
  • Bad Habits to Kick : Using AS instead of = for column aliases

    This one is quite subjective, and I'm sure I will face plenty of opposition - not only because it's a preference thing and many people are married to their preferences, but also because it violates the strict interpretation of the standard. Personally, I'm more worried about the former than the latter - I have no concerns whatsoever that ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 23, 2012
  • Bug-Out Bags and Cloud Architecture Considerations

    I served in the U.S. Military for a while, and as part of my training we had to maintain a “Bug-Out Bag”, which was a large duffle-bag full of certain items that we could live on/fight with in an emergency. I’ve carried the spirit of that idea forward with me into civilian life, in Florida and especially here in the Pacific Northwest. In Florida ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 20, 2012
  • Must-Have Resources - SQL Server Backup & Recovery

    One of the things that drives me crazy as I'm getting older is that my brain is losing the capacity to differentiate version numbers. As I speak travel around speaking with customers and at conferences, I find my self saying things like ''I can't recall if this problem was fixed in SQL Server 2000 or 2005. But you don't have to worry about that ...
    Posted to Kevin Kline (Weblog) by KKline on December 8, 2011
  • Windows Azure Best Practices: Affinity Groups

    When you create a Windows Azure application, you’ll pick a subscription to put it under. This is a billing container - underneath that, you’ll deploy a Hosted Service. That holds the Web and Worker Roles that you’ll deploy for your applications. Along side that, you use the Storage Account to create storage for the application. ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 28, 2011
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement