I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:

The report execution has expired or cannot be found. [rsExecutionNotFound]

This report contains a very large dataset, so my first inclination was that there was some query tuning and indexing review that needed to… Read more

One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it Like To Be a DBA” post series, we’re privileged to have with us a gentleman that not only flexes his technical muscles regularly on his blog but… Read more

Read more

I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly worried, and the kids knew to restart the router when it went down, crossing their fingers for a good connection. I suspected the router might be dying, and was getting… Read more

This will be the easiest entry in this series.  This is a reblog of an article I wrote last year. Simple batch script to generate XMLA and deploy SSAS DB As I was working through some issues with my cube design, I realized that I wanted to deploy my SSAS…

Read more

We here in the IT community are clearly concerned about our weight. More specifically, we’re concerned about our weight going up and up like a growth chart for a high-transaction OTLP database. (SQL tie-in for ya, there.)

Starting to move…

We’re starting to do something about it. I know people… Read more

First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand printing.

Here’s the story.

Book. Nine months of writing. Excellent technical editing. Great copy editing. Book complete about six weeks ago. Yay!

Now things get fun…

Here’s how it works.… Read more

With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any records are being modified at the same time, the data will be read from the rows in version store rather than wait until data modification complete. Such behavior lets prgrammers… Read more

I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent Saturday that involved voter registration.

Last Saturday I went to the library, part of a leisurely weekend afternoon. It’s nice to browse for an hour and grab a stack of… Read more

The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that I’m talking about. If you haven’t booked your ticket yet, then it is about time.

SQLRally Nordic 2012 is taking place Monday, October 1st – Wednesday, October 3rd, at the… Read more

 Back in May, I had a conversation with a sql friend in the community, and well, my friend (who I named SQLBif) was very dismayed with the amount of time spent on SQL Server Community, and expressed frustration that with all this community engagement, event hopping, networking and more, SQLBif was… Read more

The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a regular session during this event.

The session that I’m presenting is:

Table Variables and Temporary Tables: What you NEED to know!

Almost all SQL developers are familiar with table variables… Read more

I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of 1.13 (on a scale of 1 to 5, with 1 being good) for the one I did on professional development. To put that in perspective the highest rating for a… Read more

Being a 2011 finalist I felt I should try and rally all those who truly are exceptional to get their nominations in and quick sharp as the closing date is getting close.

I was lucky enough to be nominated for this award last year and wasn’t going to follow it… Read more

A few days ago, I found a very interesting behavior regarding Service Broker on a customer system. The main thing is that your activation stored procedure is not allowed to block for a very long time, otherwise you will impact the health of your whole SQL Server instance. In this… Read more

Well after being a bit late in trying to book the beta exams I managed to get three of the five I needed for the MCSE data platform booked, taken and I’m pleased to say passed!

Unfortunately due to the fact I did 461, 462 and 465 means I don’t… Read more

Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I did run into this problem myself a couple of weeks ago whilst creating a very specific build to test some functionality and seeing as it took me a little bit… Read more

I had the pleasure of meeting Mr. Cephas Lin, of Microsoft, last year at the SQL Saturday in Indianapolis and then later at the PASS Summit in the fall.

Cephas has been writing content for SQL Server 2012 Always On. Cephas has recently published his first whitepaper, a migration guide… Read more

The requirements for Power View state that it can only use tabular models as data sources.  So if you want to use Power View against a multidimensional cube, you are stuck.  But there is a work-around:

Create a PowerPivot for SharePoint workbook that is using a SSAS multidimensional cube as… Read more

It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held at the convention center from November 6-9. This year will feature more than 170 sessions across 6 tracks from 90 speakers in addition to 2 days of pre-cons; and that… Read more