Need a 1st Contract

[Spacecadet]

How secure is it getting IIS and SQL working together to blat out XML....always scared the hell out of me....?!
(not talking about the FOR XML obviously) but the IIS extensions....

OK - its not very secure by default but then this is Windows :P

Theres two other things that I did with the XML support for IIS in SQL Server

a. Set the config so that only the XML templates that you define yourself as DBA may be accessed. The XML templates contain the SQL queries to run and handle any incoming parameters. This is actually pretty good as the templates allow you to do a lot of XML type stuff and pass the parameters the URL easily. However the templates are just stored on the disk and not within the database structure.

b. If its only 1 server (or computer) that needs access you can lock down access to limited IPs

[Perhentian]

Err...

How secure is it getting IIS and SQL working together to blat out XML....always scared the hell out of me....?!
(not talking about the FOR XML obviously) but the IIS extensions....

[expat]

Thats usual from DBAs - they have to be nazis and have that persona permanently as the company tends to rely on them more than anyone else. One cock up means you lose the DB since the last transaction log backup/nightly which could be a fatal for an ecommerce company for example.

Your personality will slowly change to that over the years.

When I'm doing my DBA thang, I'm equally as Nazi. Mind you the same when I'm writing code.

I tend to not let people near a DB by security restriction unless it's via stored procedures I've thoroughly tested myself.

OK, you mentioned the nazis. Stop this thread!

[Spacecadet]

Blimey spacecadet, you mean you're a DBA who actually makes it easy for people to use the data in your databases?

I think that's where you're going wrong. Everybody knows a DBA's supposed to think up every excuse to forbid that sort of thing wherever possible.

That is why the data is there
First DBA i worked under was a right grumpy sod though, unhelpful to the point where its the only thing i really remember about him - promised myself to be the opposite to everything he was when i got to DBA status.

[thunderlizard]

Blimey spacecadet, you mean you're a DBA who actually makes it easy for people to use the data in your databases?

I think that's where you're going wrong. Everybody knows a DBA's supposed to think up every excuse to forbid that sort of thing wherever possible.

[Spacecadet]

Still a crap product though - much prefer a DBA that writes what I want in five seconds flat into a CSV and use Excel to do the pretty presentation stuff.

I'm a SQL Server DBA - I used to use XMLsupport in IIS to produce reports and then educate people how to grab that data useg excel. Saved me time, only had to set up the report once then they could refresh the data as many times as they liked.

I still can't get my first f****** contract though

[mcquiggd]

OK, so who changed the default boolean connector on Jobserve? It used to be AND and now it seems to be OR. Seach for Contract, 7 days, and "Crystal AND Reports" and you get 98 matches. Knock out the AND and you get 1058...

Still a crap product though - much prefer a DBA that writes what I want in five seconds flat into a CSV and use Excel to do the pretty presentation stuff.

Erm jobswerve did, due to competition - they display anything you typed in, in the vain hope you might work in London for 30 quid a day with 200 years experience.

HINT: The people who search jobswerve are not neccessarily from western europe......

[Chappo]

or use reporting services - much better solution

[malvolio]

OK, so who changed the default boolean connector on Jobserve? It used to be AND and now it seems to be OR. Seach for Contract, 7 days, and "Crystal AND Reports" and you get 98 matches. Knock out the AND and you get 1058...

Still a crap product though - much prefer a DBA that writes what I want in five seconds flat into a CSV and use Excel to do the pretty presentation stuff.

[thunderlizard]

That jobserve search includes any ads that just have "reports" in the description.

I reckon there's about 50.

You're doomed.

Unless you look outside Jobserve.

Oh no, that's what you asked for in the first place isn't it?

[boredsenseless]

I only found 499, what did I do wrong?

tim

You obviously didn't click the 'I am malvolio' check box

[malvolio]

Seeking, grasshopper, is the first step to enlightenment.

Perhaps there's been a sudden surge in demand...?

[tim123]

I found 775 in 5 seconds flat, here:

http://www.it.jobserve.co.uk/searchr...cid=0&x=26&y=6

Now why can't you do that...?

I only found 499, what did I do wrong?

tim

[malvolio]

Hello people,

I was wandering if anyone knew of any vacant contracts within the feild of Crytsal Report writing.

THanks in Advance.

I found 775 in 5 seconds flat, here:

http://www.it.jobserve.co.uk/searchr...cid=0&x=26&y=6

Now why can't you do that...?

[iib900316a]

Hello people,

I was wandering if anyone knew of any vacant contracts within the feild of Crytsal Report writing.

THanks in Advance.