Author Archives: Sudeepta Ganguly

About Sudeepta Ganguly

A SQL Server User... Still Learning

SQL Server is consuming more than 17000 handles !!!


Well, these days, this is a topic of discussion most of the time & when this evening I encountered this again, I thought of writing this post for my future reference. While analysing a slow performance issue on a server, … Continue reading

Posted in How To, SQL Server | Tagged , | Leave a comment

CHECKDB Failed with 7926 error


During this weekend, I was working on a weekly maintenance job failure issue, where I came across the error 7926. This was the first time I encountered this error. The below error was reported in the job output file: Msg … Continue reading

Posted in DatabaseSnapshot, Jobs, Just Learned, SQL Server | Tagged , , , | Leave a comment

SPN Registration Failure Issue


While I was configuring my lab machine, I observed the SPN registration was failed on one of my server with the below error. The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/KRISHNA02.SKGLAB.LOCAL ] … Continue reading

Posted in Deployment, How To, Security in SQL Server, Setup LAB, SPN, SQL Server | Tagged , , , , | Leave a comment

Setup LAB: 03 Installation of SQL Server 2012


In this post, I will start with the SQL Server 2012 installation. Prior to that, I will create an OU named TestLAB in AD, which will contains all the service accounts, lab users, servers. Apart from that I will also … Continue reading

Posted in Automation in SQL Server, How To, PowerShell, Setup LAB, SQL Server, SQL2012, TestLab | Tagged , , , , , | Leave a comment

Setup LAB: 02 Install & Configure a Domain Controller


In the previous post, I had installed Windows Server 2012 evaluation on a virtual machine & added Dot Net Framework 3.5. In this post, let’s start with the domain controller installation from a copy of the pre-installed VHD. I had … Continue reading

Posted in How To, PowerShell, Setup LAB, SQL2012, TestLab | Tagged , , , | Leave a comment

Setup LAB: 01 Generalize the Operating System Installation


This was the topic of discussion during last week, while a colleague of mine said that he faced some challenges while setting of his lab. After few additional queries, I figured out that he didn’t configure the domain controller correctly … Continue reading

Posted in How To, Setup LAB, SQL Server, SQL2012, TestLab | Tagged , , , | 3 Comments

Checklist for Database File Movement


Below are the steps, which I usually follow as part of any database file movement activity. Check the last full database backup completed successfully. If your change windows allows, prefer to take a latest full backup of the database. If … Continue reading

Posted in How To, RoboCopy, SQL Server | Tagged , , | 2 Comments