Most RecentMost ViewedMost LikesSplit a file group into multiple data files First published on MSDN on Mar 03, 2017 Periodically we are asked how to split an existing filegroup into multiple data files. APS Blocked Partition Switch First published on MSDN on Jan 30, 2017 In SQL Server, when you perform a partition switch, a schema lock is acquired briefly to do the operation. SQL Server Workgroup Cluster FCM Errors First published on MSDN on Jun 28, 2017 BackgroundOne of the new features of SQL Server 2016 is the ability to use SQL Server with Failover Cluster in a workgroup rather than joined to Active Directory. Migrating Symmetric Keys Between SQL 2016 and SQL 2017/Azure First published on MSDN on Jun 08, 2018 There has been a recent discussion about migrating symmetric keys between instances and version of SQL Server. Troubleshooting CDC enabling failure - Part 2 First published on MSDN on May 30, 2017 In previous blog, I discussed the CDC failure due to guest user disabled in MSDB. Troubleshooting CDC enabling failure - Part 1 First published on MSDN on May 17, 2017 My customer had recently experienced 2 interesting CDC issues and I would like to share the troubleshooting process and root cause for these issues today. Incremental Statistics - My New Favorite Thing First published on MSDN on Jan 17, 2017 So many new features get added with each release of SQL it is hard to use them all. APS 2016 External Object Changes First published on MSDN on Jan 11, 2017 APS customers who use Polybase and will be soon upgrading to APS 2016 from AU5 or prior should consider this change and take action prior to upgrading. Recover database without LDF file First published on MSDN on Jan 12, 2016 I recently came across a missing LDF file case that I would like to share some interesting findings. Troubleshooting intermittent connection timeout First published on MSDN on Nov 08, 2016 In this blog, we are going to take a deep dive into a connectivity issue my customer encountered a while ago.
