Following are links to my blog post on SQLServerGeeks.com.
Hope you find them useful 
Does Parallel Plan for rebuild index impact the fragmentation of index?
Parikshit Savjani
Premier Field Engineer
Similar Posts
SQL Server Predeployment IO Stress Testing using sqlio
While there are some really good in-depth whitepapers and blogs (specifically by CSS Team and Brent Ozar & his team) to address this topic. However the information in these blogs,whitepapers is kind-off scattered and for a novice the information in some these whitepapers can be overwhelming.In this blog post I would like to explain you…
Fragmentation should not be the only factor which decides the Rebuild Index
Until now I was under the impression that fragmentation in the Index is the only factor which decides whether we should rebuild the index. As a rule of thumb we always recommend that when the avg_fragmentation_in_percent in the view sys.dm_db_index_physical_stats is between 5 and 30 We should reorganize the index and when the fragmentation is…
Considerations for Configuring Log Shipping for a cross-domain clustered instance of SQL Server over a Firewall
Last week, one of my customers had engaged me for consulting to configure Log Shipping on clustered instance of SQL Servers which are running in different domains. In other words, the primary and secondary servers are in different domains. While Log Shipping is pretty easy to configure but configuring log-shipping for a cross-domain clustered instance…
How to change the keys for the Encryption for an already encrypted database
Have you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use “Key Rotation”. Key rotation is the process of decrypting data with the old encryption key and encrypting the data with the new encryption key. But how to use the Key Rotation with SQL…
Boosting Update Statistics performance with SQL 2014 SP1/CU6
Cross post from https://blogs.msdn.microsoft.com/sql_server_team/boosting-update-statistics-performance-with-sql-2014-sp1cu6/ With SQL 2005 end of life, many customers are planning their upgrades to SQL 2014. One of the recommended post upgrade tasks is updating the statistics of all the tables and databases in latest compatibility level. The updated statistics ensures the new optimizer in the latest release has most up to…
How to query Active Directory to fetch more than 1000 rows using Sql Server–Part I
Recently there was a requirement from one of my customers to query Active Directory and load the data into a table in sql server. To be honest I am not developer so I started researching on the topics over the net and took help of some of the internal resources which I had access to….