Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2010

Most SQL Server DBAs Still Don’t Know About Instant File Initialization

In 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… Read more

4 comments, 437 reads

Posted in SQL Aloha on 20 September 2010

Are Your Backups Really Safe?

This 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… Read more

1 comments, 236 reads

Posted in SQL Aloha on 18 September 2010

SQL Server Security Checklist

In 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… Read more

2 comments, 605 reads

Posted in SQL Aloha on 14 September 2010

Free Webinar: Turn Your Backups Into Live Databases with SQL Virtual Restore

Steve 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.

Topics covered in the webinar include:

  • Learn how SQL Virtual Restore works under the hood
  • Retrieve data:…

Read more

0 comments, 276 reads

Posted in SQL Aloha on 9 September 2010

Interview with SQL Server MVP Allen White

This 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… Read more

0 comments, 298 reads

Posted in SQL Aloha on 8 September 2010

Please don’t Tweet this, but…

This 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… Read more

0 comments, 264 reads

Posted in SQL Aloha on 7 September 2010

Interview with the Intrepid Buck Woody

This 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… Read more

1 comments, 399 reads

Posted in SQL Aloha on 2 September 2010

As a PASS Member, Don’t Forget to Vote in the 2010 PASS Board Elections

I 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… Read more

3 comments, 224 reads

Posted in SQL Aloha on 1 September 2010

September Question: What feature is missing from SQL Server that you would most like to see included in the next release?

Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). And don’t forget to enter your e-mail address when you post your response, so I can contact you if you win.

This… Read more

0 comments, 204 reads

Posted in SQL Aloha on 1 September 2010