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

Archives: June 2008

Notes from the June 2008 oPASS Meeting

Our main presentation was on 'Unlocking the Power of SQL Compact' by Steve Lasker & Ginny Caughey. Went better than I expected (not that I doubted their presentation skills) because for most DBA's it's a little looked at/noticed area of the database world. They delivered a lot of detail and received quite a… Read more

0 comments, 183 reads

Posted in SQLAndy on 4 June 2008

Data Loss Mailing List and Database

The folks at have been stalwarts in providing information to the security community for ages, it seems. I first discovered them via their defacement mirror, which they ceased maintaining long ago because site defacements became so common there was no point. About three years ago they began actively tracking… Read more

A New Logo

For SQL Server, it's coming soon. Surprisingly, when I was up in Redmond, quite a few people were asking about this, and wanted to have a new logo. I somewhat agree that the old logo was a little tired and it would be good to see something new.

I saw… Read more

0 comments, 375 reads

Posted in The Voice of the DBA on 4 June 2008

Security by Obscurity?

Andy Warren points to a TechNet article about Security by Obscurity and wanted me to post some notes. Let's start with the example they used.

Rename the Administrator account:

I agree with Roger's take. We intentionally rename the administrator account because it does stop the malware and scripts. We intentionally… Read more

Managing Money

First, the usual disclaimer: I'm not a financial professional, so take all of the following with a grain of salt and back it up with some good reading and/or professional advice.

I'm often surprised at the many different ways people look at money. Not my place to say that any… Read more

0 comments, 399 reads

Posted in SQLAndy on 3 June 2008

Replication Error "field size too large"

Yesterday, I was fighting with an error I have never seen in the replication and not much info can be obtained via google either.

My replication environment is pretty much complex, with multiple pulishers to one single subscriber, and also one publisher to multiple subscribers. But they are all transactional replications (some with updatable subscriptions)

Read more

6 comments, 6,719 reads

Posted in DBA Philosophy on 3 June 2008

World Wild Telescope & Misc Microsoft Stuff

Just took a look at the World Wild Telescope and it looks interesting, perhaps just as importantly looks cool! Don't know enough to know if there are practical applications (I suspect there will be), but I think it's going to prove to be a great educational tool. Microsoft Research seems… Read more

0 comments, 209 reads

Posted in SQLAndy on 3 June 2008


Last month the LCD screen on our treadmill went out. We bought it last Christmas (06) as a present for my wife and I and with all the snow in 07, it was a nice addition to the household, letting us work out with bad weather outside. However the LCD… Read more

0 comments, 396 reads

Posted in The Voice of the DBA on 2 June 2008

Reminder - SQLSaturday #4 in Orlando June 7-8, 2008

Last call! We've got a 2 day event running this time. Saturday is the more traditional (it's only #4 after all) day with 3 tracks, Sunday is a 'university' day with 2 three hour classes. Visit for more information and to register - it's free. Read more

0 comments, 134 reads

Posted in SQLAndy on 2 June 2008

Security by Obscurity?

If you're not familiar with the term it means to make something safe/secure by using a trick to hide the vulnerability rather than fixing it, or perhaps when "fixing" it is just isn't possible. Over the years I've seen the value of running SQL on a non-standard port, threats drop… Read more

1 comments, 155 reads

Posted in SQLAndy on 1 June 2008

Newer posts