LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.

Servicestack CredentialsAuthentication and easyhtpp of course: Part 3

Introduction In the first part I showed you how to configure ServiceStack and in the second part I showed you how to read from the ServiceStack service with Easyhttp. And now it is time to give Santa the opportunity to add some children. ServiceStack I want to use the same request for my Post as I did for my Get. This means I will need to add LastName to the request.

Read More...

Getting remote disk information with Windows PowerShell

A couple of weeks ago someone asked me why they should upgrade to MS SQL Server 2012. I named a bunch of reasons and only remembered afterwards that the possibility to use Windows Server Core could also be a surplus. Just 2 days later this Case for Core post from Jeremiah Peschka (blog | twitter) made me realize there was a lot of work for me before I could say that running MS SQL Server 2012 on Windows Server Core.

Read More...

Servicestack CredentialsAuthentication and easyhtpp of course: Part 2

Introduction So this week I wanted to setup a webservice that also included authentication. As one usually does this time of the year, Santa needs his data to be protected so that the children can’t see which gifts they will receive. I decided to help Santa by using ServiceStack and Easyhttp. And I described the servicestack in the first part of this post. Easyhttp First of all we need an httpclient.

Read More...

Servicestack CredentialsAuthentication and easyhtpp of course: Part 1

Introduction So this week I wanted to setup a webservice that also included authentication. As one usually does this time of the year, Santa needs his data to be protected so that the children can’t see which gifts they will receive. I decided to help Santa by using ServiceStack and Easyhttp. ServiceStack Lets start by creating our server first. For this I make a new Empty ASP.Net project. And I change the web.

Read More...

SQL Saturday #160 — To each end, a beginning

It's over. I still can't believe it. Something that I've worked on so hard and cared for 6 months is over. So many great things happened during the day, and so many great people were involved. I'm going to use this space to try to thank everyone, and give a respectful remembrance to the day of my life: Sept 22, 2012 – SQL Saturday #160 day. So many people to thank….

Read More...

SQL Saturday #149

There are many great things to say about this past weekend’s SQL Saturday in Minnesota. First, the organizers and volunteers put together a perfectly executed event. Being an organizer of many SQL Saturday events, I know the pain and stress that goes into the actual day of the event due to things simply not going right. Well, if there was something that didn’t go right, stress compounded or any pain inflicted, I can tell the organizers, from my side of things, the event was put together and executed perfectly.

Read More...

Making automated tests for my resharper plugin

Sometime in the past I made a blogpost on how I made a resharper plugin. First warning. Running your tests will be slow at best. This is because the sdk creates the whole visual studio solution in memory when you run your tests. You can find all the code on github. The resharper SDK makes it “easy” for you to test. They have automated a lot and you just have to do some simple things and all the magic will be done for you.

Read More...

T-SQL Window Functions – Part 4: Analytic Functions

In the final installment of my series on SQL window functions, we will explore using analytic functions. Analytic functions were introduced in SQL Server 2012 with the expansion of the OVER clause capabilities. Analytic functions fall in to two primary categories: values at a position and percentiles. Four of the functions, LAG, LEAD, FIRST_VALUE and LAST_VALUE find a row in the partition and returns the desired value from that row.

Read More...

My wish for the next update of VS2012: more options for the preview tab

Dear people on the VS team, So in VS2012 they added the preview tab. So when you singleclick a file in the solution explorer will open the file in preview mode. There is only one of these tabs so when you single click another file it will just “close” the previous one and show the new one. This way you don’t have have hundreds of files open that you never wanted open in the first place.

Read More...

Create HTML from output of Perl::Critic

Perl::Critic is great. If you haven’t tried it, you should. It can help you improve the quality of your code no end. I wrote this script to make it easier to view the feedback in the context of the code itself. When run in a directory containing Perl code it’ll create a critic_html directory containing index.html summarizing the results: ![critic_html/index.html][2] Clicking through to any of the files will give you all the violations found by Perl::Critic, inline with the code:

Read More...