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.

Making your own Local root CA and using it as an SSL certificate for intranet websites.

Introduction I had my intranet site selfsigned before. But the problem with self signing is that the user gets a warning. And of course we all click continue and then you get this. Which makes the addressbar totally useless because gray on pink is not very readable. So I set out to fix it. And here is my story. Installation You should install the Active directory certificate services.

Read More...

SSRS Properties – Tablix Sorting

This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: Tablix Sorting The purpose of this property is to sort the results of a tablix in the order you determine. To access the property for a tablix, right-click a row or column and select Tablix Properties. Select Sorting. Click Add. To select it for a row or column group, go to the group pane, click the down arrow to the right of the group name, and select Group Properties.

Read More...

MongoDB: Creating capped collections

Let’s say you have a collection and you are only interested in storing the last 50 items or so. Everytime you add a new item, you want the oldest item to disappear. What you can do is create a capped collection. Here are some behaviors that capped collections have Capped collections guarantee preservation of the insertion order. As a result, queries do not need an index to return documents in insertion order.

Read More...

SSRS Properties – Tablix Filters

This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: Tablix Filters The purpose of this property is to allow you to filter the results of a dataset shown in a tablix. To access the property, right-click a row or column group in the tablix and select Tablix Properties. Select Filters. The options are Expression, Operator, and Value. Expression – a field from the data set.

Read More...

Nancy and custom error pages.

Introduction I wanted to show my users some prettier errorpages then the default you get from IIS or Nancy. This being the default for Nancy. Because I know you guys like pictures. Of course this was the first time ever in any webapp that I did that, So I had to look certain things up. And I thought this was pretty cool. But of course that’s not how Nancy works.

Read More...

MongoDB: How to drop databases and collections

In this post we are going to look at how to drop database and collections. We already covered backup and restores, now that you know how to do that, it is safe to cover dropping collections and databases Execute the following command, it will create the MultiCollection database if it doesn’t exist already use MultiCollection Now create these two collections db.Blog.insert( { name : "Denis", age : 20 } ) db.

Read More...

Leveraging MSBUILD to automate SSRS deployments – session material

A week ago I gave a session for the Belgian SQL Server user group, SQLUG.be, about how MSBUILD can be used to automate SSRS deployments. Thanks to a lovely strike of the taxi drivers in Brussels it took me only 2 hours to get at the location, but hey, the turnout was great, there was beer and pizza and the demo's didn't crash. You can find the demo material from my session here and you can download the slides from SlideShare.

Read More...

SSRS Properties – Hidden & ToggleItem

This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: Hidden and ToggleItem The purpose of this property is to have rows or columns automatically expanded or collapsed, with the ability to expand or collapse at any time, with a toggle item. This is also called drilldown. To access the properties, select a row or column group in the grouping pane. The options for Hidden are True or False.

Read More...

Quality, Quality Assurance, and How Not To Do It

The technical sphere seems to have very mixed definitions for the terms “Quality” and “Quality Assurance”. The other day I was reading a post by Devlin Liles (blog|twitter) in response to a presentation he had attended (Quality Assurance–The Team Approach). While I agreed with a lot of his opinions, as I started to leave a comment I found myself sidetracked into examining the different (and in many cases, wrong) definitions we use for Quality and Quality Assurance.

Read More...

Nancy and adding the windows authenticated user to your page.

So I have been using Nancy and my IIS is configured to use windows authentication. Now how do I get the current authenticated user onto my webpage. But first of all how do I get the name of the current authenticated user. Well that was the simple part. vbnet HttpContext.Current.User.Identity.Name And there you have it. Now we all know that we can do this in Nancy with Razor to get the current logged in user when using formsauthentication or basic authentication.

Read More...