Tag Archives: sql server

Password Help

Posted on October 17, 2011 by way0utwest

Today we have an editorial that was originally published on Oct 9, 2006.  Yesterday I wrote about compliance tips and one of the things I mentioned was using encryption and passwords for your backups. It’s a good idea that you should use … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

PASS Summit – Day 1 Keynote

Posted on October 12, 2011 by way0utwest

How can you miss the audience so badly? I can completely understand me making a mistake. It’s just me, I  am distracted by other work, I get little feedback from people whose opinions I ask, and I’m just one person. … Continue reading →

Posted in Blog | Tagged | Comments Off on PASS Summit – Day 1 Keynote

How do you learn the advanced stuff?

Posted on October 4, 2011 by way0utwest

I was talking with someone recently about features in SQL Server and they mentioned that partitioning was something DBAs should know. It’s only available in the Enterprise and Data Center editions for production use, but my friend noted that it … Continue reading →

Posted in Editorial | Tagged , | Comments Off on How do you learn the advanced stuff?

SQL Authentication – Forcing Password Changes

Posted on October 3, 2011 by way0utwest

When you create a SQL Server login (with SQL authentication), you have the option of enforcing password policies from Windows (in SQL Server 2005 and above). The recommendation is that you check all three and force strong passwords. You also … Continue reading →

Posted in Blog | Tagged , , | Comments Off on SQL Authentication – Forcing Password Changes