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.

Browsing "syndicated"

3

T-SQL Tuesday #59: My Hero

This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show). Ada Lovelace has been an inspiration to many. In keeping with my blog theme, let’s call her a hero. We all have our heroes, those people who we admire, who inspire us, who we […]

Read More...
5

Beware the defaults! (in windowing functions)

Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the last date an event had occurred for each type of event. Let’s illustrate with an example: CREATE TABLE dbo.TestOver (ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL ,[Group] CHAR(1) NOT NULL ,Value INT NOT NULL); INSERT […]

Read More...
9

The Magic Alt Button

Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What do I mean with this? While holding the Alt-button on your keyboard, you can select a block of text instead of lines of text. Note that this is not an exclusive feature, you can do […]

Read More...
1

Stupid me #4 – The login is from an untrusted domain

After quite a while it has finally returned: another Stupid Me™®©! A reminder: Every time I do something “stupid”, which happens from time to time, I’ll do a little blog post on what happened and how I solved it. The reason for this is twofold: I’ll have a solution online I can consult if it […]

Read More...
2

Tableau Data Visualization Cookbook – Review

After my review of Tableau Dashboard Cookbook, I read another book about Tableau, namely Tableau Data Visualization Cookbook by Ashutosh Nandeshwar. The book is published by Packt but I am relieved to say this time there were no significant editing issues. In fact it is quite well written and as far as I could tell […]

Read More...
0

Modeling the Agile Data Warehouse with Data Vault – Review

A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a local training provider. As part of the training, I received the book Modeling the Agile Data Warehouse with Data Vault written by Hans Hultgren who also is an instructor for the official data vault certification. […]

Read More...
0

Creating a Matrix Infographic in SSRS

With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to display forecasts of World cup matches. An example: I was wondering if something similar could be built using SSRS. And yes, it is possible and it isn’t that hard. My starting point is a […]

Read More...
1

Tableau Dashboard Cookbook by Jen Stirrup

DISCLAIMER I received this book through the O’Reilly blogger review program, which I already mentioned in the review of Thinking With Data. The actual publisher of the book is Packt Publishing, not O’Reilly itself. TABLEAU DASHBOARD COOKBOOK I guess most people who have been in contact with the SQL Server community have at least heard […]

Read More...
1

Speaking at SQL Server Days 2014

I am absolutely delighted to share the great news that I have been selected as one of the speakers for the 2014 edition of the SQL Server Days in Belgium. It is one of the biggest SQL Server events in Europe and this will be the 4th time I am presenting there. A lot of […]

Read More...
4

SSRS Nugget: displaying placeholders when no rows are returned

A few days ago there was an interesting question on the forum: How can I get None in each cell of a table in the report if no rows are returned? If I use “No rows message” property, header is not displaying on the report but I would like to get headers along with “NONE” […]

Read More...
Next Page »