Author Archives: Bob L

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 … Continue reading →

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 … Continue reading →

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 … Continue reading →

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 … Continue reading →

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 … Continue reading →

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 … Continue reading →

Can’t believe it has been 6 months since I posted anything.  No, I haven’t been dead; No, it isn’t that I haven’t been doing anything worthwhile to blog about.  Once again tyranny of the urgent has robbed from the important.  … Continue reading →

Place holder for Data Model Monitor

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 … Continue reading →

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 … Continue reading →