Is anyone willing to review a short article of mine?

It's about running job synchronously.

No way, the Summit is too far and too expensive for me.

Especially now that I'm moving into freelance consulting.

Jeff Moden (5/25/2011)

Yes, I believe I can. And I...

I see. Thank you for the example Chris. I think I got it now.

I'm not sure that order matters. Personally, I hate RIGHT joins, I find them harder to read: they don't fit well in my mindset.

I tend to write queries starting from...

Thanks for the suggestion, Jason:

CREATE TABLE LOG_HOSTS (

ip_address varchar(48),

logon_count int,

last_logon datetime

)

GO

CREATE TRIGGER [TR_LOG_HOSTS]

ON ALL SERVER

FOR LOGON

AS

BEGIN

...

Indeed. Nice one, Rob.

Almost forgot: you can only track the host name, not the IP Address.

I guess you can perform the translation later from the app side if you need it.

I would suggest a logon trigger and then log hostnames to a table:

CREATE TABLE LOG_HOSTS (

hostname nvarchar(128),

logon_count int,

last_logon...

I guess you will have to use Jeff's code to extract a substring, then.

Try it: performs very well.

Every time I had to do something similar to this, I used Crystal Reports.

You can create a report with an Image field and read it from a binary column in...

Short answer: you don't want your data to sit in a single column. Each column MUST contain one and only one information.

Longer answer: you can use a split function to...

Looks like Oracle SQL.

Are you sure it's MS SQL Server T-SQL?

mikes84 (5/24/2011)

Why disable it? What if all users are accidentally locked out or deleted. SA is your guaranteed way in, no?

Don't use it for the...

It's an article series, some articles are yet to be published.