Category Archives: Programming

#SqlSatDublin (#SqlSat501) – ReCap

Friday

Last week I left home, bound for Dublin, to attend and speak at the SQLSaturday event organized by Bob Duffy (b|l|t), Carmel Gunn (b|l|t), Ben Watt (l|t), Dan Galavan (b|l|t) and many others.

I arrived in Dublin on Friday, getting settled in at the hotel, then took a quick peek at the venue, which was right on the back of the Hotel.

National College of Ireland
National College of Ireland

Friday night, all speakers were invited to attend a dinner on Quay 16, which turned out to be a smashing meal and really awesome company. If you ever get the chance of sitting at the same table as Buck Woody (b|l|t), you’re in for a treat.

Saturday

Rise n’  Shine, up early, to attend the first session of the Day, by Matt Masson (b|l|t). Except, Matt hat lost his voice halfway through his pre-con on Friday, needless to say, his sessions were cancelled. So I began the Day with a tour of the exhibitors and got a chance to talk to some of them. Next I went to attend the key note by Mark Souza (l|t) – What an amazing story-teller! After that, it feels like: It’s Just Faster… It just is…

During the next session, I went to the speakers room, to prepare for my own presentation. I had been selected to deliver a Lightning Talk on Custom Assemblies in Analysis Services. A topic I have written a couple of blog posts on, here and here. My presentation went well, even though only a few hands came up to the question on who was working with BI and SSAS. I was sharing session with Ben Watt (l|t), Andre Melancia (b|l|t) and Andrew Pruski (b|l|t), who all delivered excellent talks on Power BI, Certifications and Partitioning (T-SQL).

When the session was over, I had plenty of time since lunch was up next, followed by sponsor sessions – I skipped those, to take a break and talk with lots of people who wanted to chat about SQL Server 2016.

Next up, for me, was Rob Sewell (b|l|t) – I hadn’t had a chance before to see his PowerShell expertise unfold, so I grabbed the chance while it presented itself. Rob shared a lot of best practice and good advise. If you get the chance, attend his session – PowerShell is here to stay!


Final session of the Day, I selected to get an introduction to R in SQL Server 2016 by Marcin Szeliga (b|l|t). This session was also live streamed on Channel9, where you can still see it, for free, along with a selection of session from #SqlSat501.

Raffle time!

SqlSat501 Raffle Time
SqlSat501 Raffle Time

After finding the lucky winners, we all headed out in a court yard for some BBQ and beverages. A Perfect ending to a long day.

Sunday

Sunday was my day off, and I decided, based on numerous recommendations, to head out for the Guinness Storehouse. It was a good walk from the Hotel to the factory, and I didn’t mind the light rain on the way, but the view from the top floor was maybe not the one that goes into commercials. Still I think it was a nice trip and some great information about the beer, craftsmanship and history.

Dublins Finest #storehousestory #guinness #beer

Et billede slået op af Jens Vestergaard (@jens_vestergaard) den

Dublin is full of all kinds of wonderful sculptures, old as new and I was fortunate enough to pass by a lot of it on my tour through the city. City centre was currently undergoing heavy rebuild, as I understood the tram was to be rediscovered – I wish that would happen in Copenhagen as well.

The Linesman
The Linesman

Leaving from Quay 16 this stunning view was presented.

Samuel Beckett Bridge
Samuel Beckett Bridge by Night

In the afternoon, I was bound for home, wife and kids. I did get to shop some gifts for them, a genuine rugby, a rugby shirt and some other Irish treats.

I really enjoyed my stay in Dublin, and cannot thank Bob, Carmen, Ben, Dan and the rest of the team enough for giving me the opportunity to speak at their event. I hope to be back!

SQL Server 2016 RTM available as Azure VM

As of today, the latest release of SQL Server is available as a Virtual Machine on Microsofts Azure Platform.
In a matter of minutes you’ll be able to try out all the new features that was added.

SQL2016 in Azure

I am, among other things, looking forward to play with DBCC for Analysis Services and see what optimizations are in the box (and not featured in the news bullets)

Try it out at http://portal.azure.com

How to Query SSASMD using #DAX

This is my seventh post in a series of entry-level posts, as suggested by Tim Ford (b|l|t) in this challenge.
I have not set any scope for the topics of my, at least, twelve (12) posts in this blog category of mine, but I can assure, it’ll be focused on SQL Server stuff. This time, it’s a little trick on how to execute DAX via a SQL Server Management Studio [SSMS] MDX Query.

In our current setup, we have both Reporting Services [SSRS] and PowerView Dashboards connecting to our underlying SQL Server Analysis Services [SSAS] cubes. And as we are constantly monitoring the servers, logging which queries are executed, we can tell which ones candidate for optimization. Now, with PowerView Dashboards we do not have the ability to change the actual DAX that gets send to the server. But we can execute the DAX, and trace whether aggregates are missing or if partitioning would be applicable.

Since we have the individual query, it would be nice to be able to execute these manually through SSMS with a SQL Trace running. Admitted, I am a Trace fan 🙂
This is actually possible, with only a little tweak.

In order to execute DAX on a SSAS Multidimensional cube, the Cube property of the connection string needs to be assigned. Here is how to do that.

Open a new MDX Query

New MDX QueryYou will be prompted for server, but before you assign any of that, hit the ‘Options’ button:

Select Options

One of the properties available in the connection string is Cube. See full reference of connection string properties here. Select the third tab; Additional Connection Parameters, and assign the cube you want to query.

Assign Cube Attribute

Write your DAX query, in the MDX query window

MDX Query

and execute it to see the results.

ResultAt the time of writing, not all of the queries we are logging are directly executable via this tweak, but we manage to get the long running ones going – which gives us enough insights to potentially fix or at least improve the query execution times.

Hope you enjoyed this little tip.

How to Quickly Remove Snippet Line Numbers in Visual Studio

This is my sixth post in a series of entry-level posts, as suggested by Tim Ford (b|l|t) in this challenge.
I have not set any scope for the topics of my, at least, twelve (12) posts in this blog category of mine, but I can assure, it’ll be focused on SQL Server stuff. This time, it’s a neat little trick that has saved me a lot of that repetitive delete, down, home, repeat kind of work.

Only too often I find myself searching the web for pieces of code, that I need for some odd solution. And almost every time, I come across a web page, where the code sample is displayed with line numbers. It’s always annoying to have to sit and delete those manually. No longer I say! Yes, you heard me right. Actually Visual Studio has a neat trick to help you get this done in a jiff.

An example of a code snippet, could be the following:

Snippet

Even though the numbers are not highlighted, when we copy from the source, they are still pasted into the destination. To easily get rid of the line numbers, just paste your code sample into a text document in Visual Studio; Pres [ctrl] + [n] and select a text file:

Text FileOnce the file is open, paste in your code snippet:

Paste

Now for the juicy part.
Place your carrot/marker in the first line and first column, on index (0,0) so to speak – See green arrow:

Paste

Now, at the same time, Press [Shift]+[Alt] and mark just behind the last dot (.) behind the “7th” line, as in below screen dump.

Mark

Pres Delete:

Result