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.

So you want a Windows 8 Phone?

I’ve been a Droid phone user for some time now and really, couldn’t have imagined using anything else. One of the things that is always important to me is, efficiency in work. That being said, Droid has always been quick to find what I need, actually makes calls and has the tools I need to get the job done. So why would I even consider going to a Windows 8 Phone?

Read More...

A Glance of Plan Explorer Pro's Deadlock Analysis

Analyzing deadlocks in SQL Server can be a frustrating and painful task. As frustrating as they are, often as a DBA, you’ll also have to explain what, why and how a deadlock(s) were causing performance or loss of transactions. With Plan Explorer Pro now having a deadlock graph analyzer, this task has been simplified a bit. Plan Explorer Pro has also given the DBA a way to portray deadlocks to other business or technical teams.

Read More...

ASP.NET MVC project with Modal dialogs and Flexigrid

In the last few months I started working on my first ASP.NET MVC project. I already had a Visual FoxPro application I wrote in a few days and I wanted to replicate it for the Web using ASP.NET MVC. This project is still in its infancy, but I want to share my experience and some success I have with it. I also first want to thank people who helped me to get where I am now with this project: Viv Phillips and Paul Mrozowski from UniversalThread, Darin Dimitrov from stackoverflow, Alex Ullrich and Sergey Kosik and also Jazzen Chen from MS.

Read More...

Nancy and jtable: paging and sorting

Introduction Yesterday I wrote about Nancy and jtable and how to get it working and showing some data. Today I want to add serverside paging and sorting to that. Paging This is where the Post is actually sending some data along, namely the paging data. Of course they could have used a Get and some urlparameters to make this work but they didn’t and I can live with that.

Read More...

Nancy and jtable

Introduction. From time to time you need to show data in a grid. And I picked jtable and Nancy to make that happen. Because reinventing the wheel is not something you want to do every week. Installation Everything you need can be found on Nuget. And this is what I needed. jQuery jQuery.UI.Combined jTable Nancy Nancy.Hosting.Aspnet Nancy.Viewengines.Razor I then copied all the scripts to the content folder, because that is the convention for Nancy.

Read More...

MongoDB: How to limit results and how to page through results

In this post we are going to take a look at how to limit results in MongoDB as well how to page through results. MongoDB use limit to limit the number of results return, MongoDB use skip to skip a number of records from the results set. Using limit in conjunction with skip enables you to do paging in MongoDB. Let’s take a look at how this works To get started insert the following into your MongoDB database

Read More...

How do you manage SQL Agent Jobs when using mirroring?

I have a bunch of SQL Agent jobs that execute T-SQL against databases. A bunch of these databases are mirrored. Of course if the database is the principal then these jobs will work without a problem. But what happens if you failover? Now these jobs will start failing. You can either have the same jobs on both servers and have them enabled or disabled depending where the mirror or principal is.

Read More...

MongoDB: How to include and exclude the fields you want in results

In this MongoDB post we are going to look at how to return only the fields you want. We already looked at how to sort the results in the MongoDB, how to sort results post but we didn’t show you how to return just the fields you want. To get started insert the following into your MongoDB database db.Blog.insert( { name : "Denis", age : 20, city : "Princeton" } ) db.

Read More...

WHERE not to use FUNCTIONS

Functions can be very powerful, but used in the wrong place in a query they can show some unexpected behavior. In this post I will be using the AdventureWorks2008R2 database and I will query the Sales.SalesOrderHeader to get all the 2006 OrderDates. A query that doesn’t make much sense but will return some interesting results. Take the following query: USE AdventureWorks2008R2; GO SELECT OrderDate FROM Sales.SalesOrderHeader WHERE OrderDate BETWEEN '20060101' AND '20061231'; GO If we take a look at the execution plan:

Read More...

Join Me At SQL Saturday #175 Fargo, ND

It’s time for a new adventure! While there have been over 200 SQL Saturdays held all over the world, this will be the first one held in North Dakota. I’m thrilled to be part of the team bringing this great event to a new location and a new group of SQL Server professionals! SQL Saturday #175 Fargo will be held on Saturday, April 27, 2013. What’s a SQL Saturday? It’s a free, one-day training event all about SQL Server.

Read More...