Category Archives: Uncategorized

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”

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”

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”

Download Service Packs are no more available from SQL Server 2017 and higher version. Only CUs and GDR are available which you may download.