Database Administration - Category Archive
The following is a list of all entries from the Database Administration category.
How Often Do You Backup Your Transaction Logs?
Database Administration,Database Maintenance | November 15, 2010 | 4:14 pmWhenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least once an hour. As is with most things DBA-related, there is no exact answer that will meet every SQL Server environment’s needs. The interval between transaction log backups depend on many factors, including, but not ...read more
How Often Do You Run CHECKDB Against Your Databases?
Database Administration,Database Maintenance | October 20, 2010 | 5:24 pmI recently ran a poll, asking DBAs how often they ran DBCC CHECKDB against their databases. Compared to some of the polls I have run recently, I was somewhat pleasantly surprised by the results. My first pleasant surprise was that at least 90% of those polled knew what DBCC CHECKDB was. This is a good ...read more
SQL Server Database Maintenance Checklist
Database Administration,Database Maintenance | October 4, 2010 | 7:01 amIn this blog post, I continue my series of SQL Server Health Checklists that I am developing for a new book I am writing. The focus of this checklist is database maintenance. Database maintenance includes a defined set of proactive tasks that a DBA needs to perform on a periodic basis to help ensure that ...read more
Most SQL Server DBAs Still Don’t Know About Instant File Initialization
Database Administration,Database Maintenance,Performance Tuning | September 20, 2010 | 8:53 amIn my most recent poll, I asked DBAs if they have turned on instant file initialization on their SQL Servers. I was a little surprised by the results. Just over half of the DBAs who responded to the poll said that they don’t know what instant file initialization is, and another 13% said that they ...read more
Are Your Backups Really Safe?
Database Administration,Opinion | September 18, 2010 | 1:00 amThis editorial was originally published in the Simple-Talk newsletter. Imagine for a moment if you will. As a DBA, and as the protector of your organization’s data, you have implemented many safeguards to protect your data. You have set up periodic jobs to back up your databases; you check daily to ensure that the backups ...read more
SQL Server Security Checklist
Database Administration | September 14, 2010 | 11:13 amIn this post, I continue my checklist series that will eventually become a new book. The focus of this checklist is SQL Server security, a very important topic that is often neglected because many DBAs are spending most of their time striving just to keep their SQL Server instances up and running.
Interview with SQL Server MVP Allen White
Database Administration,DBA Career,SQL Server Connections | September 8, 2010 | 8:49 amThis is the third and last in a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections in November 2010. This interview is with SQL Server MVP Allen White (blog | Twitter). Tell us about yourself Allen. After starting out as a theatre major, I got an Associate’s Degree in ...read more
Interview with the Intrepid Buck Woody
Database Administration,DBA Career,SQL Server Connections | September 2, 2010 | 1:00 amThis is the second in a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections in November 2010. This interview is with Buck Woody, a SQL Server Senior Technical Specialist for Microsoft (blog | Twitter). Tell us about yourself Buck. Wow – I’m kind of old, so that would take ...read more
Twitter
Linked In