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

Archives: July 2009

Things You Need To Know If You Use DFS Replication

In addition to being a SQL DBA I'm also a network administrator, or at least I pretend to be. This is a bit off-topic from my usual SQL Server fare, but I figured my pain is your gain. Today, July 31, is System Administrator Appreciation Day. If you use… Read more

0 comments, 2,218 reads

Posted in Kendal Van Dyke on 31 July 2009

SQL Logins For Windows Domain Accounts Limited To Pre-Windows 2000 Format

You may have noticed that when you create a login on a SQL server that's mapped to a Windows domain account you have to use the pre-Windows 2000 format [domain\login]. Did you also notice that there's a limitation of 20 characters on the login portion of this format?

Let's pretend… Read more

0 comments, 641 reads

Posted in Kendal Van Dyke on 28 July 2009

Interested In *Free* SQL Training? Attend A SQL Saturday Near You!

Can't make the PASS summit? Or maybe you're going but looking for something whet your appetite between now and November. How about attending one of these SQL Saturday events happening soon?

Read more

0 comments, 740 reads

Posted in Kendal Van Dyke on 27 July 2009

So You Want To Meet People At PASS…But What Do You Say?

Going to the PASS Summit this November? Let's fast forward and pretend it's November 2. You've made it to Seattle and are at the convention center for the welcome reception. While there you spot so-and-so whose blog you read or so-and-so who you follow on Twitter. You'd like to  say… Read more

0 comments, 506 reads

Posted in Kendal Van Dyke on 23 July 2009

Replication Snapshot Errors Caused By Compatibility Level Setting

I ran across an interesting replication error recently that's worth sharing. It happened while using a distributor running SQL 2008, a publisher running SQL 2005, and the published database set to 2000 (80) compatibility. When adding a new subscription (version and compatibility of subscriber are irrelevant) the snapshot agent failed… Read more

0 comments, 430 reads

Posted in Kendal Van Dyke on 22 July 2009

SQL Quiz #4 - Leadership

Chris Shaw posts SQL quiz #4, I make an observation on Twitter about who gets tagged, Brent Ozar tags me for complaining being a squeaky wheel, and then I wait 3 months a really long time before posting a reply. Well, better late than never so here goes…

Question: Read more

0 comments, 700 reads

Posted in Kendal Van Dyke on 14 July 2009

The Best Thing I Learned At PASS

Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win it's worth a free registration or hotel stay for the 2009 Summit, and I like free!

Let me start by making a small confession: I've never actually been… Read more

0 comments, 743 reads

Posted in Kendal Van Dyke on 1 July 2009