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.

2

SQL 2016 Preview has been released!

For those who haven’t noticed already: SQL Server 2016 CTP2 (or Preview as some call it) has just been released! This means it is play time! You can either download a copy if you’re old school like me, or you can spin up a VM in Azure like all the cool kids. SQL Server 2016 […]

Read More...
0

Using CodeDOM to Automate Technical Screening Evaluation

CodeDOM provides dynamic compilation of .Net code and is commonly used in places like template generation or compilation of emitted code. I recently needed a way to evaluate code submissions against a known set of test cases, so this post will walk through building a small program to do take source code as files, compile […]

Read More...
0

Speaking at ITPROceed 2015

This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT professional. The conference takes place the 11th of June at Utopolis Mechelen. My session is situated in the Data Platform & Internet of Things track and is titled Demystifying Power BI. Basically it introduces the full Power […]

Read More...
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...
3

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...
1

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...
Next Page »