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 "ssis"

6

SQL 2016 Preview has been released!

For those who haven’t noticed already: SQL Server 2016 CTP2 (or Preview as some call it) has just been released! This means it is play time! You can either download a copy if you’re old school like me, or you can spin up a VM in Azure like all the cool kids. SQL Server 2016 […]

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

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

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

PASS BI VC recording is available now

The recording of the webinar I did for the PASS BI virtual chapter is live! (Quick reminder: it was the same session as on the SQLServerDays: How to (not) torment your fellow SSIS developer?) I’m quite pleased with the recording, although I sound like a drunk German scientist sometimes. The slides can be downloaded here. Let […]

Read More...
1

Nominated for Author of the Year

I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post You can vote for me at the following URL: http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp Note that you can cast a vote […]

Read More...
6

PASS BI VC: How to (not) torment your fellow SSIS developer?

On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS developer? for the PASS BI virtual chapter. This is great news for the people who couldn’t attend my session at the SQL Server Days and who still want to see it (I hope those people […]

Read More...
1

Overview of Published Articles – 2014Q3

Here is an overview of the articles I published in the third quarter of 2014. INTENSE SCHOOL MCSE Prep (SQL) – Using Parameters in Reporting Services Reports (Part 2) Book Review: SQL Server 2012 Integration Services Design Patterns MSSQLTIPS Adding Custom Reports to SQL Server Management Studio More Text Analysis with the SSIS Term Lookup […]

Read More...
2

SQL Server Days 2014 – Slide deck

SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers! My session went pretty well, somewhere around 60 attendees I would guess and they didn’t seem too bored. I saw some other great sessions as well, such as Buck Woody (twitter) on Big Data (and […]

Read More...
Next Page »