ilearnsql (data knows everything ...)

Post SQL Server Installation steps with PowerShell

I bet, each DBA would change some settings after the SQL Server installation as per their company standard . I wrote this PowerShell script for one of my client who has below standards: Port should be 1433, static Disable SQL telemetry* & SQLWriter services Change recovery model to FUll for all databases except tempdb andContinue reading “Post SQL Server Installation steps with PowerShell”

Microsoft SQL Server roadmap

Here is the roadmap of Microsoft SQL Server:

Database deadlock issue, sometime an easy solution

Performance Tuning of database is always a challenge and becomes tricky sometime. Here is today’s topic deadlock which is a very common problem if you are dealing with databases Question: Sometime users complain they get an error message “their process was deadlocked with another process and was chosen as the victim.” After retry the entry, it worksContinue reading “Database deadlock issue, sometime an easy solution”

SQL Service account status with powershell

One of my client has the requirement to have SQL Service account running with domain account and should not be with local account. You may receive SSPI error after changing it to domain account. In order to fix that issue check my previous blog “How to register SPN for SQL service account“ Output:

Monitor basic Database parameters like Recovery Model, Page Verify, Auto Close, Auto Shrink, DB Owner, Auto Create Statistics Enabled, DB Create Date etc with PowerShell command.

iLearnSQL, 2020-06-16 Monitor basic Database parameters like Recovery Model, Page Verify, Auto Close, Auto Shrink, DB Owner, Auto Create Statistics Enabled, DB Create Date etc. with below script: Output:

How to register SPN or SSPI error:

To fix above error you need to register SPN. Verify if the SPN are already registered by command: setspn -l domain\xxxx; To register SPN, run below commands: setspn -A MSSQLSvc/abc.xx.companyname.com:1433 domain\xxxxx setspn -A MSSQLSvc/abc.xx.companyname.com domain\xxxxx setspn -A MSSQLSvc/abc:1433 domain\xxxxx setspn -A MSSQLSvc/ abc domain\xxxxx Make sure above SPN’s are registered, run below command: setspn -lContinue reading “How to register SPN or SSPI error:”