iLearnSQL

MCSA 2012, MCDBA, MCITP, MCP, MCTS(SQL Server 2005), MCTS (Database Development, 2008), ITIL v3
  • Tagline: Data knows everything ...

Technical Article

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 and […]

5 (2)

2020-07-02 (first published: )

2,043 reads

Technical Article

How to register SPN for SQL service account

Check if the SPN is already registered: setspn -l domain\xxxxx If not, 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   Verify again, setspn -l domain\xxxxx

5 (1)

2020-06-17 (first published: )

3,919 reads

Technical Article

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.

I have created this script for one of our client, the requirement was all the databases should be in full recovery model and should be monitored. Also, I added other important parameters like AutoShrink, AutoClose etc. Output:

5 (2)

2020-06-16

844 reads

Blogs

Daily Coping 29 Nov 2022

By

Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

My adventures with speaking and what changed

By

I am writing this blog post as contribution to #NewStarNovember and what got me...

Automatically Take Missed Backups with Ola Hallengren’s Scripts

By

I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...

Read the latest Blogs

Forums

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Assigning a Server Role

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Assigning a Server Role

Cloud First Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud First Software

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers