Author Archives: ilearnsql (data knows everything ...)

How to handle duplicate records in SQL Server

While working with one of my Risk Advisory clients, I came upon an issue of duplicate records reported from an application user. This user noticed the problem on one of the critical reports that is sent out to the higher management group on weekly basis. Finding a duplicity of data questions the whole application andContinue reading “How to handle duplicate records in SQL Server”

SQL Server 2017 Installation Error with KB2919355

Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355. I downloaded the KB2919355 as mentioned inContinue reading “SQL Server 2017 Installation Error with KB2919355”

Application down after SQL Service logon account change

I was working on one of my clients server maintenance schedule. It was a normal maintenance monthly activity to reboot database server every first weekend.  I rebooted the machine and as per the defined steps I checked the SQL services whether its running after the reboot. I verified, all SQL Services & browser service wereContinue reading “Application down after SQL Service logon account change”

SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos because the Service Principal Name (SPN) is missing, misplaced, or duplicated.

One evening I started receiving flood of alerts from almost every single Database server for one of my clients on SCOM console. The error message appeared as follow: “MSSQL 2016: SQL Server cannot authenticate using Kerberos because the Service Principal Name (SPN) is missing, misplaced, or duplicated.” Before I started technical investigation, first I wentContinue reading “SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos because the Service Principal Name (SPN) is missing, misplaced, or duplicated.”

SQL Server 2019 introduces recommendations for MAXDOP and Max memory during installation process.

Finally, two important SQL Server recommended settings have been introduced at the installation setup page. These are the settings that every DBA changes after every single installation. The settings are MaxDOP and Max Memory. MaxDOP: When an instance of SQL Server runs on a computer that has more than one CPU logical core, it detectsContinue reading “SQL Server 2019 introduces recommendations for MAXDOP and Max memory during installation process.”

SQL Server 2012 does not come up after service pack upgrade SP4

I have done countless SQL Server upgrades but rare get issue after the Service Pack upgrade in terms of SQL Server / Database online. Here is one example where I ran into issue and that too the serious one with the master database after SP4 upgrade on SQL 2012. It was one of the productionContinue reading “SQL Server 2012 does not come up after service pack upgrade SP4”

Unable to connect SSIS remotely:

Problem:  I was working with one of my client queries and they were having issue while connecting SSIS on DB Server SQL1 from application server APP1. They were getting below error message: Looking at the error message it’s saying something not registered or related to some missing dll’s, it’s not something related with permission orContinue reading “Unable to connect SSIS remotely:”

SQL Server Bulk Insert failed (Access is Denied) on remote server, it’s delegation issue

Environment: Application server – where tableau/SharePoint application running, can’t give the ‘sa’ permission to the application domain\appuser. This domain\appuser is DBOwner of their DB Database Server – SQL Server 2016 Always on, services are running with domain\dbuser and has ‘sa’ permissions in SQL server File Share – A common share where the data is beingContinue reading “SQL Server Bulk Insert failed (Access is Denied) on remote server, it’s delegation issue”

Change collation at Instance level through rebuild databases in SQL Server 2017

Question: After SQL Server installation I realize that this SQL instance does not has the requirement of default collation. So how would I change it now either uninstall everything and install it again (of course not a smart move!) or rebuild system databases and change collation at Instance level? Answer: Easy and faster way toContinue reading “Change collation at Instance level through rebuild databases in SQL Server 2017”

Design a site like this with WordPress.com
Get started