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 and…
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 in…
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 were…
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 went…
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 detects…
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 production…
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 or…
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 being…
Download the latest CU20 for SQL Server 2017
Download Service Packs are no more available from SQL Server 2017 and higher version. Only CUs and GDR are available which you may download.
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 to…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
iLearnSQL 