Ashish Kumar Mehta

Author
Recent Posts

Ashish Kumar Mehta is a database manager, trainer and technical author. He has more than a decade of IT experience in database administration, performance tuning, database development and technical training on Microsoft SQL Server from SQL Server 2000 to SQL Server 2016.

Ashish has authored more than 325 technical articles on SQL Server across leading SQL Server technology portals. Over the last few years, he has also developed and delivered many successful projects in database infrastructure; data warehouse and business intelligence; database migration; and upgrade projects for companies such as Hewlett-Packard, Microsoft and Cognizant.

He holds an engineering degree in computer science and industry standard certifications from Microsoft including MCITP Database Administrator 2005/2008, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

View all posts by Ashish Kumar Mehta

Latest posts by Ashish Kumar Mehta (see all)

Best practices to configure the index create memory setting in SQL Server - June 15, 2016
How to migrate users to a partially contained database in SQL Server - June 13, 2016

Best practices to configure the index create memory setting in SQL Server

June 15, 2016 by Ashish Kumar Mehta

Introduction

The Index Create Memory setting is an advanced SQL Server configuration setting which the SQL Server database engine uses to control the amount of maximum memory which can be allocated towards the creation of an index. In this article, we will take a look at the steps to resolve the below mentioned error message.

How to migrate users to a partially contained database in SQL Server

June 13, 2016 by Ashish Kumar Mehta

Introduction

Microsoft introduced the Contained Database feature in SQL Server 2012. In this article we will take a look at how to migrate SQL Server Logins to a partially contained database in SQL Server to remove dependencies from the Instance of SQL Server where Contained Database resides.