Microsoft Bob

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

Browse by Tags

Tagged Content List
  • Blog Post: Nested Identity Keys in SQL?

    This weekend I played with partitioning.  I have a table with about 10 million rows spanning the last 6 years of stock history for AMEX, NYSE, Indexes, and NASDAQ.   I partitioned each year into a separate filegroup so that should make it much easier to purge archive the old years and...
  • Blog Post: Using Persisted Computed Columns in SQL Server Indexes

    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.  Calculating this involves data mining stock history...
  • Blog Post: Auto-Generating Pivot Views

    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 generic at this point, but the technique is generic...
  • Blog Post: SQL Server Data Model Monitor Series

    Place holder for Data Model Monitor
  • Blog Post: SQL Server 2005 High-Availability Options (Distilled)

    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 find a lot of material which is very large and complex...
  • Blog Post: Creating the Infrastructure for Capturing a Data Model

    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 this information as the database is modified. ...
  • Blog Post: Monitoring Data Model Changes

    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 a PowerPoint and a paper that I wrote on the...
  • Blog Post: Welcome Back, again...

    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 working for Microsoft as a Sr. Consultant working...
Page 1 of 1 (8 items)