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.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Discuss Share Learn

Top Forum Users

The top ranked users for the past 30 days:

Google Ads

0

5 Questions with Russ Thomas

My 5 Questions series continues with Russ Thomas (blog | twitter | linkedin). At SQL Saturday Portland 2013, Russ asked me and Grant Fritchey to sit in on his presentation, “Verbal Judo for the DBA”. Grant and I had fun taking on roles with other members of the audience, talking through situations, learning how to […]

Read More...
2

5 Questions with Mala Mahadevan

My 5 Questions series continues with one of my favorite people, Mala (blog | twitter | linkedin). She and I met at PASS Summit a few years ago, but it was on SQL Cruise Alaska 2012 that we really got to know each other. Mala is a little firecracker. She’s a great DBA, a long-time PASS […]

Read More...
2

100th post

This is my 100th blog post here at LessthanDot! (I’m not lying, check for yourself) I started blogging at the end of 2012, almost 3 years ago and it has been an amazing ride so far. I’ve apparently gathered almost 1.5 million views (I don’t really trust that figure :)) and 260 comments.  My most popular […]

Read More...
0

Overview of Published Articles – 2015Q2

Here is an overview of the articles I published in the secondt quarter of 2015. INTENSE SCHOOL Book Review: Query Tuning & Optimization by Benjamin Nevarez MSSQLTIPS I’ve been busy writing tips! Purging Entity Members in SQL Server Master Data Services Using the Transaction History in SQL Server Master Data Services Introduction to Power Query for […]

Read More...
2

How to drop a Temporal Table

No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or in other words, system-versioned tables. We’ll see what catches on. In a gist, such a table keeps track of the history of its rows by the use of some audit columns (start and end date) […]

Read More...
2

Doing a Full Outer Join in Power Query

A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities of  the Microsoft BI platform is demonstrated alongside client testimonials. I gave a session called “Drilling across Analysis Services cubes using Power Query”, which talked about how you can use Power Query to do a […]

Read More...
0

5 Questions with Josh Fennessy

In my career, I’ve been fortunate enough to meet many smart, talented, caring, and wonderful people. In a blogging slump, I casually tweeted that perhaps I could start interviewing some of those people, and Josh Fennessy replied that he’d had the same thought recently. We hatched a plan to interview each other and blog it! […]

Read More...
0

SQL Server 2016 CTP 2.1 has been released

Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been added. Now SQL Server appears to get the same treatment: SQL Server 2016 CTP 2.1 has just been released. There is nothing groundbreaking in this release – which can be considered as an […]

Read More...
0

My first SQL 2016 bug

A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent hours creating a VM because there were hundreds of Windows updates). It seems I have already found a very small bug while creating a new database: Apparently they forgot to rename the compatibility level

Read More...
2

T-SQL Tuesday #67 Extended Events Wrap-up

Last week was a successful sixty-seventh T-SQL Tuesday! I asked bloggers to tell me why they loved Extended Events, why they hated it, what their favorite tricks were, or what they had recently learned. I learned several new tips and tricks! Here’s a recap of the blogs. Huge thanks to all the bloggers who took […]

Read More...
Next Page »