You  are right however, Restricting database login rights reduces the impact surface of a successful SQL injection attack but does not prevent injection itself. Prevention requires parameterized queries and safe...

You’re right, putting proper user identification and security in the database is a strong solution. Using table and row level security properly can lock things down very tightly and, in...

nice

Hi it should do

Are you sure the database is in the elastic pool, I had a issue like this and for some reason the database was not added to the elastic pool and...

fixed it I just had too many columns in the CURSOR  I removed them like so and it works now. 

CURSOR FOR
...

at the moment I get 4 emails two are correct and two are blank I thought with the delete I would only get one email per email address. 
I would...

cheers i tried to code below it still did not work however, I turned the columns into decimal and it seems fine now. Cheers again

if you can still login as yourself with sa priv then I would say just change the password and secure it in a safe location

Hi Brad,

My company is too tight to give us a blackberry so we need to rely on a call out by some one else if there is an issue. Normally...

Hi I was wondering if you have a trusted domain I have seen an issue like this where a user made a change with a trusted domain login and when...

try dropping the msdtc resource and disk and recreate it. This should solve your issue.

Courses, I don't think there are many free courses and as Steve said i would not recommended them at this stage, I would as your DBA at work if you...

Thank you for this PowerShell script this has helped me alot, I can quickly access any of my SQL boxes with out logging on to the gui.

BCP FUNCTIONS are below

bcp tablename out table.csv -S servername then the options below what you would like. if you dont want to use command line you can use...