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.
Free Webinar: Turn Your Backups Into Live Databases with SQL Virtual Restore
Free Stuff,News | September 9, 2010 | 9:43 amSteve Jones, SQL Server MVP and editor of SQLServerCentral.com, will be hosting a free webinar with Jeff Aven, the head of the SQL Virtual Restore development team, on Thursday, September 23, 2010.
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
Please don’t Tweet this, but…
DBA Career,Opinion | September 7, 2010 | 9:49 amThis is reprinted from my editorial in Database Weekly. During some recent conversations, I’ve noticed an increasing tendency for people to precede a disclosure or opinion with a proviso such as “Please don’t tweet/blog about this, but…” It’s an interesting indication that, with the advent and growth of social media, has come an increasing concern ...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
As a PASS Member, Don’t Forget to Vote in the 2010 PASS Board Elections
Opinion,PASS | September 1, 2010 | 9:07 amI just received my e-mail from PASS, which says, “As a PASS Member in Good Standing, you are entitled to vote in the 2010 PASS Board Elections.” I am not sure exactly what a “PASS Member in Good Standing” means, but I guess I qualify as the e-mail provided me with a link to vote. ...read more
RSS
Twitter
Linked In