This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Bronze oarlock supporting an oar beside a loose metal ring

NT SERVICE Accounts in sysadmin: What They Are For

June 1, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Agent, SQL Server Security, SQL Server Services

A security scan wants those service logins gone. Here is how to see what each one is for before you click Delete.

Read More
PowerShell 'Shutdown' button.

SQL SERVER – Start Services or Stop Services with PowerShell – Answer to Question

January 6, 2014
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Server Services

You can check out the original post here: SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?.

Read More
Gloved hands lifting a honeycomb frame from a stacked wooden beehive in a meadow, smoke drifting nearby

What Is Installed? Finding Every SQL Server Component

November 28, 2009
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Server, SQL Server Installation, SQL Server Services

Finding every SQL Server component starts with the Setup discovery report, then checks services, engine versions, and separate client tools.

Read More
A cold hearth, retained charcoal pieces in a terracotta bowl, a brass shovel and a brush.

Restart History: Preserve Startup Evidence Before Logs Cycle

May 19, 2009
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Error Messages, SQL Monitoring, SQL Server Services

Restart history records startup evidence before retained logs disappear. Keep each source and timestamp separate, and test repeat collection with synthetic archives.

Read More
A sledgehammer below a small picture hook, a small red tack hammer on the shelf beside it

Checking Which Accounts the SQL Server Services Run As

July 17, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Server Configuration, SQL Server Security, SQL Server Services

Inventory SQL Server services and their accounts, compare virtual and managed identities, and verify permissions after a change.

Read More
Previous 1 … 3 4 5 6
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com