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.

0

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

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

Demystifying Power BI – slidedeck

ITPROceed has come to an end and what a great event it was. Kudos to the organizers and all the other speakers! My session went pretty well, at least from my point of view, although I had to rush my demos a bit since there was only a 50 minute time slot. I prepared for […]

Read More...
1

Level Up Your SQL Server Index Knowledge

I presented “Level Up Your SQL Server Index Knowledge” on Wednesday, June 10 for NEWDUG. I had a great audience that asked lot of questions and shared war stories. Presentations with lots of questions and discussion are my favorite! For those of you interested, the slides and demos can be downloaded here.

Read More...
1

T-SQL Tuesday #67 – What Extended Events is Missing

It’s my T-SQL Tuesday! I’ve spent the last year learning and teaching Extended Events – because if you really want to learn something, teach. XE can be used for everything from very simple tasks, such as counting the number of query executions, to very complicated tasks, such as anything Jonathan Kehayias writes about! I’m encouraging […]

Read More...
11

You’re Invited to T-SQL Tuesday #67: Extended Events

We meet again for another edition of T-SQL Tuesday! On Tuesday, June 9, 2015, you’re invited to blog about a chosen topic. Link back to this blog post, read what others have written, and post about it on Twitter. We share knowledge and get to know other bloggers! The June 2015 topic is Extended Events. […]

Read More...
Next Page »