iLearnSQL

MCSA 2012, MCDBA, MCITP, MCP, MCTS(SQL Server 2005), MCTS (Database Development, 2008), ITIL v3
  • Tagline: 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 and […]

5 (2)

2020-07-02 (first published: )

1,571 reads

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: )

2,201 reads

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 (1)

2020-06-16

616 reads

Blogs

Book Review: Lights Out

By

I have always been interested in GE since I was a kid. My best...

A Successful Blogger on Making the Switch

By

For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...

Login Timeouts

By

I was recently approached at work about a company that was seeing tons of...

Read the latest Blogs

Forums

would like to know SQL server 2017 Reporting Services Log File Location

By mandavli

would like to know SQL server 2017 Reporting Services Log File Location. I really...

Most recent and previous row

By Chrissy321

Hello, Thanks if you can help. DDL below. This is similar to problems usually...

Using Multi-Value Parameter not working after multiple edits

By Luv SQL

I've now read 15 different articles and it either doesn't work or get various...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers