Archives: June 2012
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
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
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
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may come off the wrong way or just not convey the point I want, but here we are…in a hotel room typing away. In no particular order, just my thoughts as… 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:
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
Create a PowerPivot for SharePoint workbook that is using a SSAS multidimensional cube as… Read more