The SSDT Evolution
When you are developing for the Microsoft Business Intelligence stack, you always needed Visual Studio for your business intelligence (SSIS,...
2015-09-10
1,122 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Report Builder Changes in SQL Server 2016
As a lot of features, Report Builder will improve as well in SQL Server 2016. At the moment of writing CTP 2.3...
2015-09-07
5,060 reads
SSIS – Unexpected Termination
I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages...
2015-09-03
5,472 reads
Nominated for Author of the Year 2015
I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award...
2015-09-02
407 reads
SQL 2016 CTP 2.3 has been released
A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.
You can find the download here (the...
2015-09-01
844 reads
Reblog: Force installation of 64-bit ACE OLE DB provider
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2015-08-27
756 reads
Nesting Aggregates with Window Functions
Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon)....
2015-08-26 (first published: 2015-08-18)
2,521 reads
Reblog: How I prepared myself for the MCSE certification
SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL...
2015-08-20
1,063 reads
Reblog: Slow source? Make your data flow buffers smaller!
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If...
2015-08-13
799 reads
SSIS Catalog – Path to backup file could not be determined
I was creating an SSIS catalog at a new project, but I was greeted with the following error message when...
2015-08-13 (first published: 2015-08-10)
4,845 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers