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 » Design » Tips   (RSS)
Showing page 1 of 2 (11 total posts)
  • In the Cloud, Everything Costs Money

    I’ve been teaching my daughter about budgeting. I’ve explained that most of the time the money coming in is from only one or two sources – and you can only change that from time to time. The money going out, however, is to many locations, and it changes all the time. She’s made a simple debits and credits spreadsheet, and I’m having her research ...
    Posted to Buck Woody (Weblog) by BuckWoody on July 10, 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
  • Book Review (Book 11) - Applied Architecture Patterns on the Microsoft Platform

    This is a continuation of the books I challenged myself to read to help my career - one a month, for year. You can read my first book review here, and the entire list is here. The book I chose for April 2012 was: Applied Architecture Patterns on the Microsoft Platform. I was traveling at the end of last month so I’m a bit late posting this ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 15, 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
  • “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
  • 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
  • Cluster Nodes as RAID Drives

    I'm unable to sleep tonight so I thought I would push this post out VERY early. When you don't sleep your mind takes interesting turns, which can be a good thing. I was watching a briefing today by a couple of friends as they were talking about various ways to arrange a Windows Server Cluster for SQL Server. I often see an ''active'' node ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 25, 2010
  • Using linked servers, OPENROWSET and OPENQUERY

    SQL Server has a few mechanisms to reach out to another server (even another server type) and query data from within a Transact-SQL statement. Among them are a set of stored credentials and information (called a Linked Server), a statement that uses a linked server called called OPENQUERY, another called OPENROWSET, and one called OPENDATASOURCE. ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 16, 2010
  • Tools and Processes for “Fitting it all in”

    Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that will really get done – it’s optimistic to be sure. On the other hand I have several systems I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 18, 2010
  • Code that Writes Code

    I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to a point in time? In other words, load it with some “base data”? I thought this might be a good ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 25, 2009
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement