Jay's Blog

[coding, debugging, and troubleshooting with Microsoft Technologies]

Browse by Tags

Tagged Content List
  • Blog Post: Why is using “Instant File Initialization” on my SQL Server a potential security issue?

    Starting in SQL Server 2005 and onward, data files can be “instantly” initialized.  This helps to drastically reduce the amount of time required for creating large databases, adding files to an existing database, increasing the size of an existing data file (i.e. an auto-grow operation), or restoring...
  • Blog Post: Catching who dropped SQL Server logins

    I recently had a situation where SQL server logins were getting deleted from the system and nobody could figure out why or by whom.   So in this post, we present a few ways to catch this. First, if you are using SQL Server 2008, the easiest method is to capture this via the new Auditing features...
Page 1 of 1 (2 items)