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"

1

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

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

Solving a slow running query issue with UNION

That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on! I recently encountered a curious issue with a query. The query itself wasn’t exactly rocket science: it read data from a few tables and calculated the start and the end dates of a contract in the SELECT […]

Read More...
0

T-SQL Tuesday #63: How do you manage security

This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and its subject is about security. Security is one of those subjects that most DBAs have to deal with regardless of specialty. So as something we all have to work with at some point or another what are some tips you’d like to […]

Read More...
2

Author of the Year at MSSQLTips.com

I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at the MSSQLTips.com website! I am humbled by the recognition of my fellow peers in the SQL Server community and I’d like to thank all of you, the #sqlfamily, for voting. Special shout-out to Jeffery Yao, […]

Read More...
2

The mysterious permission issue

As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty permission issue I encountered with SSIS. At a new project, someone mentioned me that a scheduled job has been failing for quite some time now (actually since they created the job, yay for testing!). So […]

Read More...
0

Overview of Published Articles – 2014Q4

Here is an overview of the articles I published in the last quarter of 2014. INTENSE SCHOOL MCSE Prep: Overview of T-SQL Windowing Functions Part 1 MCSE Prep: Overview of T-SQL Windowing Functions Part 2 The third and final part of this series will probably be published this month, so keep an eye on the site […]

Read More...
0

Formatting Durations in SSAS: Caveat

I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read it I’ll summarize it quickly: it explains how to create an MDX formula that formats durations into an [hh]:mm:ss format, where [hh] can go over 24 hours. For more detailed information, please check out the […]

Read More...
0

Nominated for the 2014 Tribal Awards

Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words: The Tribal Awards, co-hosted by Simple-Talk and SQLServerCentral, seek to recognize outstanding members of the SQL community. We want to highlight people who are currently leaders due to their writing, speaking, or general community presence. In the previous edition, I was […]

Read More...
4

Beware the defaults! (in windowing functions) – The Movie!

I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their SQL Server classes, they are doing a free series called SQL Server Solutions from the Web where they show different SQL Server solutions found in blog posts around the web. Essentially, they are turning blog posts […]

Read More...
Next Page »