EditorsBlog - All Comments

re: What Does the Internet Say About You?

unclebiguns — Tue, 30 Dec 2008 17:18:41 GMT

As long as the employer verifies the information is really about me I don't mind. Google Jack Corbett and check out the first result. For my chosen path that is NOT the reputation I would like!

re: Happy Holidays

minijogy — Wed, 24 Dec 2008 16:06:39 GMT

Why is same guy posting too many articles with different names?

Ashish Kaushal, Ashish Kumar Mehta seems to be the same person?

Too many articles about simple topics by 1 person using different names reduces the overall quality of the articles page because really good articles get missed in the crowd of "how to export" and "how to import"

re: SELECT * FROM Employees

HanShi — Wed, 24 Dec 2008 11:14:02 GMT

I'm European and as you said it is quite common to learn multipple languages. I am native Dutch speaker, but I also get around with English and German. Besides that I am currently learning Mandarin Chinese (mainly for holiday purposes).

But I don't see the SELECT * FROM change very soon. That will only happen when a company from China becomes dominant with a competative database application. But you never say never...

Best wishes for the coming new year to all!!

re: Commodity Hardware

goodideadave — Mon, 22 Dec 2008 18:12:14 GMT

And the problem with a blog that encourages comments is that if you aren't extra careful in your editing, some jerk will instantaneously point out every little error. ;)

re: Staying on Top

Jallman — Fri, 19 Dec 2008 19:21:25 GMT

I expect to be retired in 10 years (or so), but I expect my job responsibilities to change many times in that period of time. We will learn at least three new SQL Server Versions in that time, and at least two new Windows technologies.

Merry Christmas Peter.

re: Successful Backups

dschaeff — Fri, 19 Dec 2008 15:53:47 GMT

Just today I unchecked the "Verify Backup" box for our full backups maintenance plan. I hated to do that, but the verification step was taking twice as long as creating the backups. We need the backups to finish within a set time. The solution for me might be to create a another step in the maintenance plan that verifies all the backups at the conclusion, instead of after each one is written.

re: Workplace Challenges

logan1998 — Thu, 18 Dec 2008 19:12:55 GMT

We're a small outfit of less than 10 people. I've had issues with my boss looking at everything from a database design point of view and not even thinking about customer impact of changes, timelines for rebuilds, costs to implement changes, if people even want the change, employee receptiveness, etc. He doesn't even see that we've implemented some of his technical ideas. Mostly we developers/customer relations people ignore him and do what progresses and sells our software. Is that a solution? Ignoring? :)

re: DIY Patching

JohnKasra — Wed, 17 Dec 2008 22:02:16 GMT

I cant understand this. One of the things that any IT department should be ensuring is the safety of the corporate network. Unpatched computers cannot be deemed to be safe.

We have a hybrid manual/automatic patching system using SMS. Whenever a patch is required to be run, an icon is displayed in the system tray. This gives the user the ability to run the patch within 5 days for non-critical patches, or 1 day for critical patches. If the user does not patch their system in this time, the patches are automatically applied and the machine rebooted (if required).

To completely trust an end user with the responsibility of keeping the corporate network secure is a very poor decision.

re: DIY Patching

jmoss111 — Wed, 17 Dec 2008 17:15:08 GMT

There should be some type of audit in place that verifies and ensure that certain patches are in place. And user patching of servers... forget about it

re: Database Testing

matt.chatterley — Sun, 14 Dec 2008 22:30:33 GMT

We tend to achieve this via automated testing (NUnit) of DataLayer methods which encapsulate the database functionality - test fixture set up methods prepare the data (either in a few inline queries if simple, or loading bulk from XML if complex) - and then run through all the methods in their various negative and positive permutations.

That said, this doesn't really solve the problem of creating the test data in the first place - even though we refine test data if issues arise from manual testing later on - essentially using it to prevent regressions - it is still easy to overlook complex interactions if extreme care is not taken!

Bookmarks about Sql

Bookmarks about Sql — Sun, 14 Dec 2008 03:45:10 GMT

Pingback from Bookmarks about Sql

re: Commodity Hardware

pward — Sun, 14 Dec 2008 02:16:23 GMT

It is amazing the difference in meaning a typo can make :)

re: SQL Server 2008 Adoption

pward — Sun, 14 Dec 2008 02:15:20 GMT

A lot of people where caught out when they purchased Software Assurance with SQL Server 2000 hence did not purchase SA with SQK Server 2005

re: SQL Server 2008 Adoption

phcahill — Sat, 13 Dec 2008 00:35:58 GMT

In our case it's not only the service packs. When the company I'm working for sorted its licencing out, it bought 2005 licenses but continued to run with 2000. The upgrade to 2008 would be very expensive.

re: Commodity Hardware

goodideadave — Wed, 10 Dec 2008 17:39:25 GMT

"I will be heading to Vietnam over Christmas as the groom in a friend's wedding"

I should hope so!