Microsoft Bob

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

    A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously

    • 3 Comments
    With SQL Server 2008, Microsoft re-architected SQL Server Reporting Services (SSRS) to no longer have an IIS dependency. It now relies directly on HTTP.SYS and handles web protocols independently. This is a good thing, in a lot of respects (see http:...
  • 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

    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

    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

    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

    Indexes and SSDs and Random versus Sequential Access

    • 0 Comments
    If you’re one of the dozen or so people who follow my blog, you’re aware that I’m using SSDs for my doctoral research project involving simulations to find solutions to complex data correlation problems. I finally have started to get...
  • Microsoft Bob

    SSIS – Chunking number of inserts with a For Each container

    • 1 Comments
    My main customer utilizes SSIS for some SQL and Oracle integration requirements. One challenge they’ve had is timeouts from the Oracle side. We’ve tried everything to eliminate the issue in terms of extending timeout values within SSIS, but...
  • Microsoft Bob

    Memory via PCIE-SSD as the authoritative data source

    • 0 Comments
    i've blogged a few times about Fusion-IO devices and my experiences with SSD. I've been thinking about the implications of large in-memory databases that retain persistence and transactional capabilities. Turns out the game may be changing long-term to...
  • 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

    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

    Managing Index Fragmentation and Compression

    • 0 Comments
    For today, I recycle bits from a couple of excellent authors in the SQL community. The first script is for optimizing compression. I “borrowed” this from Paul Nielson, author of the SQL Bible. You can visit his SQL Server bible site at http://www.sqlserverbible...
  • Microsoft Bob

    1/4 TB SQL Database backup in under 1 Minute!!! (3.05 GBPS transfer rate)

    • 0 Comments
    With the addition of another SATA SSD as well as another SLC Duo to serve as the target destination, the same SQL database which now has a total of 233 GB of used space was backed up in less than 1 minute using the same server referenced in my prior 2...
  • Microsoft Bob

    Back again, Dealing with Storage-aligned Index oddities

    • 0 Comments
    I’m back after being on leave for past several weeks in case you wonder why I haven’t posted. To quote Joy Gresham from the move ShadowLands “I wasn’t dead, I was just in America (fill-in-the-blank)” This was one of my favorite...
  • 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

    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

    The potential of SSD for millions of IOPS on increasingly larger databases

    • 0 Comments
    NOTE: There is an update to this article at http://blogs.msdn.com/b/microsoftbob/archive/2010/11/08/pcie-ssd-update-optimizing-sql-backup-performance.aspx regarding the throughput I was able to achieve on my own configuration with the Fusion-io backup...
  • Microsoft Bob

    More clarifications on 3.05 GB/s SQL backup potential for much higher throughput

    • 0 Comments
    A couple of clarifications - including potential for much greater backup throughput beyond 3 GB/s up to 9 GB/s for this hardware: 1) Contrary to the video, 10 GbE is not the fastest practical Ethernet for server-to-server communications. 40 GbE network...
  • 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

    Nested Identity Keys in SQL?

    • 0 Comments
    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...
  • 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

    Using Checksum to create random data sets

    • 0 Comments
    Here’s a quick tip if you don’t want to try to use random and figure out seed, etc.  If you’ve got a lot of columns in a table, it is pretty likely that the checksum for all those data values are going to be random across your primary keys. I recently...
  • 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

    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...
  • Microsoft Bob

    PCIE SSD Update - Optimizing SQL Backup Performance

    • 0 Comments
    In my last blog entry ( http://blogs.msdn.com/b/microsoftbob/archive/2010/11/06/the-potential-of-ssd-for-millions-of-iops-on-increasingly-larger-databases.aspx ), I shared the throughput numbers backing up from 2 Fusion-IO devices to a 4-spindle 15K SAS...
  • 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...
Page 1 of 2 (41 items) 12