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.

Angularjs and ng-grid

Introduction Today I tried out Angularjs and posted about it. After that it was time to add a grid to make my data look better. And I picked ng-grid. Installation These are the packages I am using. angularjs 1.0.4 jQuery 1.9.0 Moment.js 1.7.2 ng-grid 1.6.0 But the ng-grid package does not contain the scripts. So I had to get those manually. I took the ones on github. The ng-grid.

Read More...

Developer, can do new tricks, require good home

The world of development is an interesting one where creativity comes alive through code to produce wonderful programs that do lots of cool stuff. Okay that's the Wizard of Oz intro over, is it really that rosy? It seems the world of development has changed a great deal and gone are the days when you could just be a code cutter (though such roles do exist and are required), it seems a developer has to now master a wide array of skills and do battle with various foes like the Windows Operating System (level 72 elite boss for those that are keeping track.

Read More...

A couple of ways to convert an integer to an coordinate with SQL Server

I answered this question from a person who had to convert coordinates stored as an integer to a float I’m receiving data on coordinates as 115949833 and I need it to output as 115.949833 because I need to be able to calculate the mileage between the latitude and longitude coordinates. Both the longitude and latitude values are saved as integers with no decimal places There are several things you can do to accomplish this:

Read More...

Trying out Angularjs

Introduction It’s superbowl Sunday and between the snacks it is time to learn something new. Today my eye fell on Angularjs. Angularjs is an MVC framework for javascript. It kinda puts the controllers and model on the clientside and not on the serverside like ASP.Net MVC does. I will use Nancy as our service to provide us with json data. Server Our server is pretty simple. Just make an empty asp.

Read More...

MongoDB: Exporting data into files

In this post we are going to take a look at how to export data into files. We are going to export data in json format as well as in csv format. To get started first connect to mongodb and create a new database named ExportDB You can just execute the following to create this database use ExportDB You should get a message like the following switched to db ExportDb Insert these 5 items

Read More...

Nancy and jquery datatables; formatting data

Introduction Yesterday I started using jquery datatables and today I will play some more. I did this blogpost using jtable before. And now I’m gonna try the same thing and maybe a little more using datatables. This should be the result if everything goes well, which it never does from the first time, because Murphy is pairing with us. Isn’t it purdy? Ok it isn’t but it works.

Read More...

Nancy and jquery datatables

Introduction Another weekend, another bit of testing to do. Lately I have been doing a lot of webdev so I am looking to improve my skills and test things during the weekend. Last weekend I tested jtable and even have it in production. But we are always on the lookout for better and it was suggested to me to try datatables. Which I did. Installation Documentation for datatables is kind of lacking in that it leaves out important information to get all the bits working.

Read More...

SSRS Properties – Description

This blog is part of my series Making Data Tell a Story With SSRS Properties. Property: Description The purpose of this property is to provide a description that can appear on the report, and appears in Report Manager when the report is published. To access this property go to the Report properties. Choose Description. Example: I have a report that shows sales per year by product category. I’ve given my report the description, “Sales by category, summed by year and month.

Read More...

MongoDB: How to backup all the databases with one command

We looked at how to backup and restore databases in the post MongoDB: How to backup and restore databases. We also looked at how to restore collection in the post MongoDB: How to restore collections. Today we are going to look at how to backup all the databases in one shot with one simple command. Before we get started connect to your MongoDB server, we are going to create a couple of databases

Read More...

Umm....No...that is not how you export a table into a file with SQL Server

Sometimes the creativity of the human species is truly amazing. Someone needed to export a table into a file from within SQL Server. Now there are several ways to do this like bcp, export wizard, Query..Results To File, SSIS etc etc. Today I noticed someone found yet another way…. This person decided to use a SQL Agent job to create the file. That is still not strange but here comes the interesting part…

Read More...