iLearnSQL

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

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:

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2020-06-16

1,200 reads

Blogs

Installing and Configuring containerd as a Kubernetes Container Runtime

By

This post shows you how to install containerd as the container runtime for Kubernetes...

It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11

By

In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...

Car Update October 2026

By

This month I want to look at a few of the things I’ve seen...

Read the latest Blogs

Forums

BCA KCU MESJID LAMA Telp/Wa 08218557456

By Layanan BCA_24jam

Jl. Mesjid Lama No.27-31, 17 Ilir, Kec. Ilir Tim. I, Kota Palembang, Sumatera Selatan...

SQL Server Vector Support II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Vector Support II

Great Things

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Great Things

Visit the forum

Question of the Day

SQL Server Vector Support II

With regard to SQL Server 2025's Vector support, what is an embedding?

See possible answers