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 "Data Modelling and Design"

3

Star Schema The Complete Reference – Review

I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit, a senior colleague of mine recommended the book Star Schema The Complete Reference by Christopher Adamson. To be honest, I had never heard about it. But was I wrong: this book […]

Read More...
3

Elasticsearch and .Net

Elasticsearch and .Net using NEST.

Read More...
1

Elastic HQ

A GUI for Elasticsearch called ElasticHQ.

Read More...
0

Elasticsearch

Getting up and going with ElasticSearch and Mint.

Read More...
6

Document Your SQL Server Databases with Extended Properties

How important is database documentation to you? I know you have a hundred “more important” things to do. But consider this: how much time is it going to take you to document the purpose of a constraint right now? How much time will you spend trying to r…

Read More...
0

Nice Collection Of Free SQL Server, Visual Studio, Azure ebooks

Eric Ligman has posted a nice collection of ebooks available in pdf, epub and mobi formats. The books cover Office, Office 365, SharePoint, SQL Server, System Center, Visual Studio, Web Development, Windows, Windows Azure, and Windows Server

Here is…

Read More...
0

Define Microsoft Business Intelligence for me?

What is Microsoft Business Intelligence? I’m not asked this question very often because it’s typically an assumption. As we know, assumptions can lead to misguidance or misrepresentation of a topic. This topic has been defined in so many different way…

Read More...
2

Driving Predictive Analytics

Remember this article, “Comparing the Chicago Highway System to your Disaster/Recovery”?

Well, today, as with most days that I drive to the office or a client, the drive was lengthy and I started to compare the complete system of driving to a topic. …

Read More...
4

Database Designing With Performance In Mind

Database design is the foundation on which we can build a successful initiative for maintenance and scalability.  Administrators have the ability to maintain indexing, statistics, integrity checks and so on, but if a database is designed extremely poorl…

Read More...
1

Displaying missing dates by utilizing a calendar table

We got a question today from a user who wanted to display counts of zero where dates were missing. For example if you had the following data

OrderDate SomeCount
2013-01-01 2
2013-01-02 2
2013-01-03 1
2013-01-05 2
2013-01-07 1
2013-01-08 1
2013…

Read More...
Next Page »