Reblog: Unexpected result with the File System Task

SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default...

The new SQL Server Management Studio 2016

The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014....

The new SQL Server Management Studio 2016

The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014....

Database Restore Fails with Msg 3154

Have you ever tried to restore over an existing database only to receive the following error message?

Msg 3154, Level 16,...

The new SQL Server Management Studio 2016

The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation...

Live execution plans

SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query...

Live execution plans

SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query...

Live execution plans

SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the...

SQL Server 2016 NYC Launch Event - Tickets Running Out!

In a previous blog, I spoke about the upcoming RTM Launch of SQL Server 2016 - Get Ready! Microsoft is ready...

SQL Server – Conditions when value of @@error changes

Hi friends, when we do error handling in our SQL code we use different methods like TRY/CATCH, RAISERROR etc. to...