SQL Server Science
Technical Articles for the DBA / Developer
Home » xp_cmdshell

Drives, with Capacity and Free Space

2019-07-18 · by Hannah Vernon · in tools

A typical part of the day for many DBAs includes managing available database capacity. Widely accepted best practices include setting a reasonable limit on maximum file sizes, for both data and log files. When a…

Obtaining machine names for failed logins

2016-06-10 · by Hannah Vernon · in basics, security, tools

The SQL Server error log contains invaluable details about failed logins, but only if you enable login auditing. Once enabled, the error log will provide the details of logins that failed including the name of…

subscribe now for updates
Stay up-to-date with the latest posts as they happen!
* = required field
unsubscribe from list

Search

Categories

  • announcements
    • events
  • basics
    • localization
  • configuration
  • DMVs
  • documentation
  • extended-events
  • Internals
  • maintenance
    • patching
  • performance
  • recovery
  • reporting
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Cart
  • Checkout
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • My account
  • Privacy Policy
  • Shop

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2023 SQL Server Science