Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

0

Overview of Published Articles – 2015Q1

Here is an overview of the articles I published in the first quarter of 2015. INTENSE SCHOOL MCSE Prep: Overview of T-SQL Windowing Functions Part 3 This will probably be my last article for Intense School for a while. MSSQLTIPS But on the other hand, I’ve doubled my efforts for MSSQLTips.com: Calculate the Statistical Mode in […]

Read More...
0

Overview of the data visualization books by Stephen Few

I recently finished the book Now You See It: Simple Visualization Techniques for Quantitative Analysis by Stephen Few of Perceptual Edge. Stephen Few is a data visualization guru and his books about designed visualizations has changed my career in BI and how I develop reports and dashboards. Few currently has three books published (with a […]

Read More...
0

User Group Survey

PASS has been holding quarterly phone calls with chapter leaders, Carmen, Karla, and Grant. I’ve been attending them to see what PASS is working on for chapters, how they can help me, and how I can help other chapters. In today’s call, I mentioned that I had created a survey using Google Forms, emailed it […]

Read More...
0

Viewing Execution Plans in Visual Studio

SQL Server execution plans are invaluable for figuring out how a query was run – and how to make it run better. Most of the time that I spend with execution plans is in either SQL Server Management Studio or, more frequently, SQL Sentry’s Plan Explorer. However, many developers spend most of their time in […]

Read More...
0

Slides from Execution Plans: The Secret to Query Tuning Success at NEW Code Camp

The Northeast Wisconsin Developer User’s Group (NEWDUG) held their annual NEW Code Camp on Saturday, March 28 at FVTC in Appleton, WI. What a great event! FVTC is my alma mater, so I love coming back for training events, walking the halls I used to see every weeknight, sitting in the classrooms I learned to code […]

Read More...
0

The shaky bug in SSIS

You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012 has had a make-over. Nothing too drastic, but at least the undo button works. However, sometimes when you drag or move tasks/components on the canvas, they start to shake. A lot. And very annoyingly as […]

Read More...
1

Nancy and the mystery of the 405: method not allowed

Yesterday I got a 405: method not allowed on my Put request which I sent to my Nancy powered webservice. I made the request with Javascript. For reference this was my module, the routes only. [Get](“/search”) = Function(parameters) ‘something pretty End Function Put(“/search/{page}”) = Function(parameters) ‘something even more pretty End Function So after I got […]

Read More...
1

(Very) Poor Man’s Infinite Scroll using angular-inview

I’ve been working on an angular app that allows users to manipulate a very large dataset in memory, using various options to filter what is shown at any given time. For one particular “view” into the data there were still over 4000 items (each needing 2-way binding), which is well beyond the point that angular’s […]

Read More...
0

Nancy and localization: Testing

In my previous posts about this subject Nancy and localization: how I think it works, Nancy and localization: The cookie approach and Nancy and localization: The better cookie approach I explored how localization works in Nancy. I however forgot to write tests to see if my code actually works. So I continue on adding to […]

Read More...
0

Small presenter tip: changing display mode automatically after presenter view

This morning Adam Machanic (blog | twitter) asked the following question on Twitter: Anyone know if it's possible to configure PowerPoint 2013 to use speaker mode but then go back to duplicate displays on exit? — Adam Machanic (@AdamMachanic) March 4, 2015 A very interesting question, as I was wondering this myself at my last […]

Read More...
Next Page »