SQLSaturday Denmark re-cap

This past Saturday, Microsoft Denmark hosted the first SQLSaturday event in Denmark, orcestrated by Régis Baccaro (blog|twitter) and David Peter Hansen (blog|twitter). I was fortunate enough to be selected as speaker, and was presenting the title “The Power of Custom Assemblies in Analysis Services” which I have blogged about here.

Prior to the event, three prominent guests were each presenting a pre-con. Jen Stirrup (blog|twitter) on “Data Visualisation Deep-Dive using SQL Server 2012″, Denny Cherry (blog|twitter) on “SQL Server 2012 in a Highly Available World” and Mark Rasmussen (blog|twitter) on “A deep dive into the depths of the SQL Server storage engine and MDF file format”. I attended the latter.
The pre-con was a really great, and hard, session on how to decipher the MDF file from SQL Server, using OrcaMDF. Hats of to Mark for doing a hell of a show :)

The Friday was finished off with a tour on the Canals of Copenhagen with several of the other speakers and volunteers. After the tour, we went dining at Tony’s, an New York/Italian style restaurant, and it seemed that everbody had a great time. I enjoyed the immediate company of Mark Rasmussen (blog|twitter), Erik Svensen (blog|twitter), Andre Kamman (blog|twitter), Bob Duffy (blog|twitter) and Daniel Lewandowski (LinkedIn) and had plenty of good disussions and red wine during the evening. At 00:30 I signed off…

As far as my own presentation goes, this was my first time presenting on an international stage. And as the room started filling, it struck me what I was about to face. A room full of equally or better talented SQL Server professionals, ready to dissect my presentation.

@vestergaardj presenting at #sqlsat196

As we got closer to the beginning of my session, I got more and more nerveous. I think it even showed through, and that’s when it’s too much. I believe you have to have some thrilling sensation going “on stage”, but it’s too much when it interferes with the performance. I’m going to Work on that :)
Otherwise I got some really good and qualified questions from the audience and I think I managed to answer all of them to a satisfying degree. All in all I am looking foward to seing the session evaluations.

After the nerve wrecking experience, I was free to attend any session I wanted. At first I just sat in the presenters room, contemplating, going over what had just happened. After a Little while I started to chat with Daniel Lewandowski, who was presenting later on that afternoon on Security in Analysis Services. A topic I’m only too familiar with, ref: Analysis Services Dimension Security. I also got to talk to Mihail Mateev (blog|twitter) who showed me the capabilities of the Infragistics suite. Very impressive. I have been using the Infragistics suite in earlier Work situations, but haven’t had a chance to look at it for the last couple of years. They haven’t been sitting on their hands in the meanwhile, I can tell you that much.
I missed a couple of sessions, but gained connections and insight into components and tech anyhow, so that’s kinda of a win anyhow.
I went of to attend the session on security in Analysis Services and saw that Daniel Lewandowski did an excellent job presenting the topic. He got jinxed by what I believe is a bug in SSMS, so he had to redo some steps in his demo. But he kept his calm and got through in style. In between this session and the last, I tended to my volunteer duties, got to chat with other attendees and got a feeling of the general mood the approx. 150 attendees. As the last seesion of the day, I went to see my old boss, Erik Svensen who did a brilliant presentation on “Design a metro style dashboard in Excel & PowerPivot“.

Finally the raffle was held, and the sponsors could hand over some really really cool presents to the Winners. A mountain bike valued at app. $2000 was by many seen as the main prize, but two courses, and iPad mini, a Nokia Lumia 920, a ride in a Ferrari, an Xbox and big bowl of candies was accepted by the individual Winners with just as much joy.

After spending 3 hours on cleaning the volunteers and some of the remaining speakers went to dine at Wokbaren, a Thai inspired restaurant in the center of Copenhagen. Here I got to chat with Niko Neugebauer (blog|twitter) with whom I’d talked to at past SQLRally Nordic, and to my surprise, he remembered our conversation in great, almost creepy, detail :)
After finishing dinner the party broke up, some going for a night in town, and others for a night in bed. I was on the latter team.

In hindsight, I am very happy to have been a part of the volunteers who made such an effort, and was paid a smashing event in return. It’s not my last SQL Saturday, and certainly not my last as volunteer. I can only hope, that if I apply another SQLSaturday, that I get to speak again. That was an awsome experience. Now I’m going to catch up with the latest episode of Game of Thrones :D

Posted in Programming | Tagged , , | Leave a comment

Free SQL Server training

On April the 19th three world-renowned speakers will be presenting three topics on Microsoft SQL Server. A seat for one of these all-day sessions is available at very reasonable price (800DKK). This is probably going to be the most inexpensive training you will ever get in your career, unless of course the event returns and gets funded in the same way as this time. Either way, you win!
Book your seat at: http://sqlsat196precon.eventbrite.com/

The following day is a free community driven event, where speakers, world-renowned as well as first timers, will be presenting 1 hour sessions on various topics. See the full schedule of all four tracks: http://sqlsaturday.com/196/schedule.aspx

SQLSat196 Speaking

I will be presenting The Power of Custom Assemblies in Analysis Services, and is scheduled at 10:10 on track 4 in meeting room C+D. Since I am presenting at the same time as Bob Duffy (blog|twitter), Gianluca Hotz (profile|twitter) and André Kamman (blog|twitter), all MVPs, I doubt many will attend my session. I won’t hold it against them in such competition. :)

Personal stuff aside, you should really consider attending this event. There are some really great sessions lined up, with some of the best speakers on the face of the planet. Be there, or be ◊ (or I will endorse you for JavaScript on LinkedIn)

Posted in Programming | Tagged , , | Leave a comment

SQL Server Quick Tip 16-20

Posted in Programming | Tagged , , | Leave a comment

Run out of disk you say, eh?

In the rare occasion, that when you are executing a project from the Information Services Catalogs, and the SysAdmin didn’t foresee some, unforeseeable event causing the disk to run out of space. And the execution doesn’t fail, just waits for more disk to become available, you will maybe be tempted to stop the operation through the ‘Active Operations’ pane in SSISDB.

This cannot be done, simply because, catalog.stop_operation which is the stored procedure called, also needs to write to disk. As the following screen shots will verify, you need to restart the instance.

Active OperationsIn SQL Server Management Studio (SSMS), select the Integration Services Catalogs, and right click the SSISDB. Click Active Operations.

Active OperationsWhen you select the operation, the option to Stop the operation becomes available.

Active OperationsYou will the be prompted, if you really want to Stop the operation.

And if you select Yes, you will be met by the following error.

Active OperationsSo, in order to get the operation, which is running, to stop, you need to restart the whole instance.

Posted in Programming | Tagged , , | Leave a comment

SUN, Oracle, whatever… How do you sleep at night?

Over the past months I have been hearing more and more complaints, about the frequency of Java updates being too often, hence beginning to annoy more and more people. I wasn’t quite there yet, but given time I got annoyed too. So I decided to disable the automatic update feature that comes with Java. Soon after I was presented with another popup box, telling me that Java needed to update (again). I thought maybe I didn’t uncheck the box, and was met by a checked checkbox, when I opened the property page. I unchecked it, and was asked if that was what I really really wanted, and clicked yea to that. So, back to work… At least for a little while. The same popup was once again presented, and this time I was certain I had unchecked. When I opened up the property page, I was once again met by a checked checkbox. WTH!

The screendumps below show how I click the property pages, on the icon in the tray.
Update Available

I then get the property page, where I’m met by the checked checkbox.
Screen1

No biggy, I will just have to uncheck and hit ‘Apply’…
Screen2

I then select the ‘Do not check’ in the warning popup
Warning

And then some magic happens. Because when I open up the property page once again (w/o doing anything else on the system) I am met by a checked checkbox.
Screen3

How do you sleep at night you “&%¤§#”&%/ crappy programmer!

Posted in Mixed | Tagged , , | 5 Comments