Most RecentMost ViewedMost LikesSSIS version number is not valid error First published on MSDN on Sep 29, 2016 In a previous blog post, I showed you how you can set a target server version for an SSIS project in SSDT on VS2015 in order to deploy packages to multiple versions of SSIS catalogs. Lazy Log Truncation - Clearing of SQL transaction log VLF status deferred First published on MSDN on Jun 27, 2013 I came across an oddity in the transaction log when I was testing Availability Group backup scenarios which really had me confused. Back to Basics: SQL Parameter Sniffing due to Data Skews First published on MSDN on Aug 27, 2013 In Denzil’s recent post about correlating XE query_hash he alluded to a relatively common issue. How to: Restoring SQL File stream Data First published on MSDN on Jul 23, 2013 It is not uncommon to have multiple copies of the same database on a single instance or to restore copy of a database from one instance to another for testing. SQL Server 2012 Partially Contained Databases Part 2 - Collation First published on MSDN on Feb 26, 2013 In my last post, I went over partial database containment and contained users. SQL Server 2012 Partially Contained Databases Part 1 - Contained Logins First published on MSDN on Feb 26, 2013 The concept of database containment basically means that all instance level dependencies are severed from the database.
