Checkpoints operation flush dirty data pages from the buffer cache of the current database to disk. This minimizes the active portion of the log that must be processed during a full recovery of a database. 382 more words
Tags » Database Administrator
I think, for SQL Server Security, the Defense-in-Depth is the best strategy. Defense-in-Depth is an information assurance (IA) concept in which multiple layers of security controls /defense are placed throughout an information technology system. 938 more words
Here, I am writing some indexing related the best practices during index creation with SQL Server DB’s tables.
- Periodically, run the Index Wizard or Database Engine Tuning Advisor against current Profiler traces to identify potentially missing indexes. 561 more words
The Database Administrator or DBA is the professional-in-charge of all activities involved in database design, development, installation, security, backup, and retrieval. The DBA uses the database management systems software to manage their works.
Title: Executive Director of Strategic Programs
Company: MGM Resorts International
Location: Las Vegas, NV United States
An information technology professional with more than three decades of experience, Karla Tucker specializes in database operations and architecture, data warehousing and security, and compliance. 223 more words