SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2009

Making Forums Work

I saw this post about Why I Dislike Newsgroups from Tom Larock and he did a pretty good job of summarizing the negatives, and then went to to discuss how the MVP forums are the exception. One of the comments was about the forums here on SQLServerCentral are also generally… Read more

7 comments, 985 reads

Posted in SQLAndy on 27 April 2009

When a Community Rallies!

I have been a bit lax these past few days, but I have been having a bit of a writers block not knowing what to write about.  Well, I realized this evening there is something worth writing about, and it is happening right now on SQLServerCentral.com.  An amazing thing is… Read more

5 comments, 1,384 reads

Posted in SQL Musings from the Desert on 27 April 2009

Notes on SQLSaturday #13

I drove up on Friday with my friend Kendal Van Dyke. Long drive from Orlando, just over 8 hours. Arrived just in time to find the hotel and then meet up with some of the other speakers for dinner. Joe Celko was there, same suit as always! Robert Cain, Louis… Read more

1 comments, 619 reads

Posted in SQLAndy on 27 April 2009

Asymmetric Keys in SQL Server

I've been tech editing an encryption book for SQL Server. It's long overdue, and I think it will be a nice addition to any DBA's library. It also addresses a complicated subject that Books Online has inadequately covered. In fact, they've done an incredibly poor job with just documenting encryption,… Read more

0 comments, 2,514 reads

Posted in The Voice of the DBA on 27 April 2009

SQL Quiz 4: Leadership

I'm finally getting around to answering this one originated by Chris Shaw (@SQLShaw), as I was tagged by Jack Corbett (@unclebiguns) earlier. In addition, Chuck Boyce (@chuckboycejr) tagged me on Friday, so I figured I had better offer some response or fall off the "SQL hotness" chart, as… Read more

Visiting West Palm Beach SQL Group on April 29, 2009

I'm going to West Palm Beach on Apr 29th to visit Scott Klein and his group. I'll be doing a presentation on statistics in SQL Server and also a discussion of PASS. If you're in the area hope you'll attend for the session and some networking. The meeting is held… Read more

0 comments, 588 reads

Posted in SQLAndy on 26 April 2009

Patterns & Practices SIG starting up in Columbia, SC

C# MVP Chris Eargle (@kodefuguru on Twitter), who is also an INETA community champion and president of the Columbia Enterprise Developer's Guild, is starting up a patterns and practices special interest group (SIG) here in Columbia, SC. As with our Midlands PASS Chapter meetings, this group will meet… Read more

Moving Forward with Nuclear

We use a lot of power in our computing infrastructure. And while I’m mindful of the concerns over safety, environment, etc., I think nuclear power should be part of the solution moving forward in the US. I can’t speak for other countries, but having worked in a plant here in… Read more

5 comments, 833 reads

Posted in The Voice of the DBA on 24 April 2009

SQL Server Security Basics: Why Would I Use SQL Server Authentication?

The standard best practice answer when it comes to connecting to SQL Server is to use Windows authentication. However, SQL Server-based authentication exists, and there are some times when it's a best practice (or only practice) to use it. Wait a second... what do you mean by having two best… Read more

PASS Summit Sessions Submitted

It's official – I've submitted my abstracts for the 2009 PASS Summit and received my confirmation. Now I wait to see if the abstract selection committee decides if I am worthy. As I promised in my interview with Brent Ozar, I'm publishing my submissions for all to see. If… Read more

0 comments, 610 reads

Posted in Kendal Van Dyke on 24 April 2009

Book Review: The Speed of Trust

I finally finished up reading the Speed of Trust and have to say I struggled with it. I'm a big believer in trust, it's an incredibly powerful tool (much like The Force!) that takes a lot of effort to earn, and interestingly, very little effort to lose. The book does… Read more

1 comments, 739 reads

Posted in SQLAndy on 23 April 2009

Building Something Fun

A little further off topic than usual today, something not about technology and work for a change. Woodworking is one of my hobbies, and I find all too little time to work at it as I try to move from amateur to craftsman. But here and there I do find… Read more

0 comments, 1,363 reads

Posted in SQLAndy on 23 April 2009

Spring Still Not Really Hitting Montreal Yet, thus More Time to Hunt Down Useless Indexes


Hopefully, by the time we have our annual family vacation in May, the Cherry Blossoms will be out – until then I’ll just dig into some very, very heavily updated Indexes that are causing Quest’s Spotlight, at my latest contract with Transcontinental, to flash warnings for excessive disk… Read more

3 comments, 700 reads

Posted in The Database Hive for SQL Server DBAs on 23 April 2009

Simple Maintenance Tasks for Non-Production Databases

Log File Sizes:

It's not unusual to see cases where database backups are taken from production and restored to a development or QA environment. Often times the database in production requires point-in-time recovery, meaning we set it up to use full recovery mode. However, when it goes to non-production, there is no need for that… Read more

Want a SQLSaturday Polo or Tshirt?

I've had a few requests for these, so I'll take orders through May 8, 2009. The polo is a very good quality white shirt with embroidered SQLSaturday logo, the t-shirt is while with the SQLSaturday logo embroidered. I can only ship to US addresses and please allow 4 weeks for… Read more

2 comments, 784 reads

Posted in SQLAndy on 23 April 2009

The Twitter Ripples

I saw this post on The Business of Software Blog about a use of Twitter to spread the word for a marketing guy. As an aside, I attended the 2008 Business of Software conference and it was outstanding. I’d recommend it to anyone in the software business.

It’s an interview… Read more

0 comments, 588 reads

Posted in The Voice of the DBA on 23 April 2009

The Google Containers

After my editorial on portable data centers, I had a number of people knock down the idea, saying it doesn’t make sense for them. I concede that not everyone can take advantage of data centers at a container level, but I’d also note that I think not everyone should be… Read more

0 comments, 761 reads

Posted in The Voice of the DBA on 23 April 2009

Internal Outsourcing

We'll all heard about or lived with outsourcing, and hopefully we know it's good and bad. Outsourcing the janitorial services is a good idea, outsourcing the help desk...maybe not such a good idea. We outsource for a variety of reasons, but usually it's to save money or to leverage skill… Read more

3 comments, 935 reads

Posted in SQLAndy on 22 April 2009

Day of DotNutNuke in Tampa on June 13, 2009

My friend Will Strohl is managing the Day of DNN on June 13, 2009 at the Microsoft office in Tampa. This is sorta the 2nd iteration of it, but the first time really run as an independent community event. Will was one of the key volunteers at our last SQLSaturday Read more

1 comments, 672 reads

Posted in SQLAndy on 22 April 2009

Behind Every Great Restore is a Great Backup

Behind Every Great Restore is a Great Backup

I showed you how to do a database backup with powershell a few days ago. Today I'll show you how to do the restore. Restores can sometimes be quite a bit more complicated than a backup. You have to account for the… Read more

Newer posts

Older posts