Microsoft Bob

NOTE: The views expressed on this blog are my own and may not reflect the views of Microsoft
Posts
  • Microsoft Bob

    Cautions with Indexed Views

    • 0 Comments
    If you’ve been following my blog, you may remember an article I did extolling the virtues of indexed views - http://blogs.msdn.com/microsoftbob/archive/2009/05/13/sql-data-warehousing-tip-2-indexed-views.aspx .  I stand behind that and have found...
  • Microsoft Bob

    Some Uses for Query Hints

    • 0 Comments
    Some of you are all set to flame me just because of my title. I know because a couple of years back, I would have probably been one of the first to say “NO!”, when anybody started talking about query hints. But, like everything else in this world, they...
  • Microsoft Bob

    Getting the full exception from .NET

    • 0 Comments
    While we're on the topic of .NET coding, here's another technique.  If you thought my last post was short, here's an even shorter one... Ever wanted to make sure you returned an error message with all of the inner exceptions?  I know I've wasted...
  • Microsoft Bob

    Fun with Enums and a Generic File Date/Time Stamper

    • 0 Comments
    Time for a break from SQL stuff for a little .NET.  Have you ever wanted to use the integer value of an ENUM instead of the actual Enum Value?  For example, here is an enum I created to map datetime formats. public enum FileDatePrecision {...
  • Microsoft Bob

    Using NTILE with Cross Reference Values to Create Dimensions

    • 0 Comments
    I confess  lack of depth in SQL Analysis Services (SSAS).  I've read quite a bit about the capabilities including data mining, and played with a couple of the wizards, but just haven't had time to immerse deeply into end-to-end scenarios. ...
  • Microsoft Bob

    Using Persisted Computed Columns in SQL Server Indexes

    • 0 Comments
    As part of my research work, I generate thousands of simulations on an almost daily basis for various scenarios.  One of my scenarios involves determining strategies for selecting the most profitable short and long stock entry/exit positions. ...
  • Microsoft Bob

    Auto-Generating Pivot Views

    • 0 Comments
    Coming back from the Sci-Fi world of AI, etc to some real world scenarios...  Earlier I posted a generic stored procedure that automatically unpivots data so that columns become rows.  Today, I provide the inverse capability, although not truly...
  • Microsoft Bob

    Generating a List of Calendar Dates

    • 0 Comments
    For today, here’s a simple trick.  Ever need to get a list of all the calendar dates for a period?  This is very simple using a user defined function with a table.   Below is a simple version.  I have a more complex version I...
  • Microsoft Bob

    Dumping SQL data in pivoted format

    • 0 Comments
    Technorati Tags: SQL Server , Tips If you’re like me and spend a lot of time in SQL Query Analyzer, querying data directly, you may find the column display format tedious for tables with lots of columns or where you are only working with a couple of entries...
  • Microsoft Bob

    SQL Data Warehousing – Tip 2 – Indexed Views

    • 0 Comments
    Last time we discussed the use of a period table to consolidate analysis into smaller segments of data.  This can be done for an analytical application where the details are not needed or as part of a rollup.  Today, we’re going to look at how...
  • Microsoft Bob

    SQL Data Warehousing Tips 1 - Building a Period table

    • 0 Comments
    Recently, I started a personal project for analyzing stock market trends and calculating the optimal trading strategies. I've learned a lot of new stuff about LINQ and SQL 2008 from this. Based on that I'm opening a new series on data warehouse tips....
  • Microsoft Bob

    Windows Home Server and Backups for the Paranoid

    • 3 Comments
    I recently discovered to my chagrin that Windows Home Server is not exactly a secure backup platform.  Let me explain before I get in too much trouble... On the plus side, The latest versions of WHS connectors can actually backup BitLocker and EFS...
  • Microsoft Bob

    SQL Server 2005 High-Availability Options (Distilled)

    • 0 Comments
    Have you ever been asked by a high-level architect or CIO what Microsoft's approach is to a given scenario?  If you have, then you know the challenges faced because as you read through MSDN and TechNet and even at the Microsoft.com site level, you...
  • Microsoft Bob

    Creating the Infrastructure for Capturing a Data Model

    • 0 Comments
    At this point, all I've given you is a set of tables that can store metadata about database tables and their relationships - they pretty much reflect a subset of what you can get from the system views.  Let's take a look at the process for capturing...
  • Microsoft Bob

    Monitoring Data Model Changes

    • 0 Comments
    Have you ever wanted to view how a database model has evolved over time? It's not that hard to setup an infrastructure for supporting this. In this series of articles, I'll go over the process for this. For a jump start on the whole process, I've provided...
  • Microsoft Bob

    Welcome Back, again...

    • 0 Comments
    After a false start a couple months back, I'm determined to get more involved in the community and start blogging daily and not let all the distractions get me away from this. My background includes over 22 years in software development. I am currently...
Page 2 of 2 (41 items) 12