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

Archives: August 2008

SQL Server 2008 RTM - Community Thoughts & Resources

As has widely been announced in the SQL Server community, SQL Server 2008 has RTM'ed. It's now available for download from MSDN and TechNet. Here are some readings from around the community:

Read more

Check Authentication Scheme (Kerberos) on SQL Server 2005

I had to redo SPNs today because we swapped out service accounts on some of our non-production SQL Servers. I wanted to verify that connections in bound were being made with Kerberos. If you've ever dealt with this, if the SPNs are wrong you usually get an SSPI error, but… Read more

Negotiating - It's Not All About Winning

More and more I see business people adopt the mindset that any negotiation is raw combat with the goal of not just winning, but winning by as much margin as possible. I'm not opposed to winning, it's a basic human drive to want to win and of course we live… Read more

0 comments, 484 reads

Posted in SQLAndy on 5 August 2008

Tool Review: Snarfer

I'm probably in the minority, but I use an offline reader for consuming feeds. Nothing wrong with browser based readers other than that require you to be online, not always possible - airline flights for example. I looked at a few and finally settled on Snarfer. Easy enough to add feeds (RSS or ATOM)… Read more

0 comments, 209 reads

Posted in SQLAndy on 4 August 2008

Free SQL Sticker from Paul Nielsen

A little while ago Paul Nielsen tweeted about having free Euro-style SQL stickers. All one had to do was email him with your snail mail address and he'd send him your way. He's still offering to send out free stickers. If you are interested, you can see what one looks… Read more

Kindle Update - August

 Apparently the Kindle is a great success, financially, for Amazon. That's good to hear, though I haven't made the decision yet. I've been looking for places/times when it would help me, but I haven't found a ton. 

And I think I might suffer from the same issues that my… Read more

0 comments, 679 reads

Posted in The Voice of the DBA on 4 August 2008

Great Read on the Difficulty of Computer Security

The SANS Internet Storm Center has a great handler post about working at the Abuse department for an ISP:

Securing a Network - Lessons Learned

The handler, Deborah Hale goes into detail about some of the issues faced. Things like end users not having up-to-date antivirus, mail servers getting blacklisted and… Read more

Moving TempDB Posted on SQLServerCentral.com

Moving Tempdb isn't a common operation, and mercifully a simple one if it comes to that. As in much of the stuff I write about I wanted to put down a nice detailed answer to a pretty simple question. Think you know how it works? What happens to the original… Read more

0 comments, 285 reads

Posted in SQLAndy on 4 August 2008

oPASS Meeting Tomorrow Night (Aug 5, 2008)

We've got two technical sessions scheduled for tomorrow night. The first is by long time oPASS member Dolores Tofel discussing using Access with SQL Server. This is a 15 minute presentation that is part of our effort to build more local speakers and get them to share their experiences from… Read more

0 comments, 307 reads

Posted in SQLAndy on 3 August 2008

Cold backup and remote control of sql server services

I recently got a request to do a "cold" backup of a small yet complex db environment, I say "small" because the sum of six db sizes is less than 60 GB, yet "complex" means the six dbs are on five physical servers. three of the which are clustered servers, the six dbs… Read more

2 comments, 670 reads

Posted in DBA Philosophy on 2 August 2008

You Hired Good People, Right?

In the current issue of Redmond magazine there's an interesting story in the Never Again column. It's titled:

Listen to the People You Hire

The situation is one that's familiar to a lot of IT folks, there's a problem, they've got a reasonable solution, but management feels that an outside… Read more

Filestream and Full-Text Issues

I'm tech editing a book on Full-Text Search for SQL Server 2008 and the last few weeks have been quite a bit of hassling with setup. I haven't done a lot of work with Full-Text since 2000, when we tried to implement it at SQLServerCentral.com. We dug through quite a… Read more

0 comments, 1,184 reads

Posted in The Voice of the DBA on 1 August 2008

Nmap 4.68 Available

The network scanner Nmap has a new version out, 4.68. The GUI interface (Zenmap) which comes with the Windows installer version is pretty sharp. A lot of changes in this version.

 I just did a test run and it correctly identified OS and services on the boxes I just hit against.… Read more

SQLSaturday Update (Aug 1, 2008)

SQLSaturday #5 in Olympia is progressing nicely. 85 registered, venue locked in, and work under way for fund raising via sponsors. Speakers still needed! If you know someone in that area that might be interested, please forward the message. We're waiting on final confirmation, but it looks like SQL query… Read more

0 comments, 507 reads

Posted in SQLAndy on 1 August 2008

Newer posts