wait until you get an application that wants to create sql agent jobs and then delete them after.  not a hope in hell stopping that process running as...

joe - I cannot believe what you just posted.. 3rd normal form is what boyce and codd designed.

if you have a table for customers and they have multiple phone numbers...

if you want to performance test each proc then (depending on how many procs) then you might want to use an automation tool or a trace replay.

the important thing in...

this is from an old post, but it might help

https://www.sqlservercentral.com/articles/the-defaultbuffermaxrows-and-defaultbuffersize-properties-in-ssis

what kind of QA testing? unit testing? performance testing? basic smoke tests? scalability testing?

all of these use different tools

they vary, some are just overnight, some are hourly, some every 15 minutes

wait until you get an application that wants to create sql agent jobs and then delete them after.  not a hope in hell stopping that process running as SA

we ended...

im sure you can google this

but

begin tran

Begin try

--do some sql stuff

End Try

begin catch

--raise error or rollback transaction

--do some other stuff

End catch

Best thing for you to do is google DMZ (wiki has some nice diagrams) then you can make your mind up.

SQL hardening is quite complex, it's not just firewalls... it's...

First, what David Poole said. 🙂

Don't sing the praises of stored procedures and writing T/SQL without being upfront about the disadvantages too. For every benefit stored procedures grant they...

there's a fine line...

I am loving these excellent comments.

I will point out that developers have a very short and predictable list of persistence requirements: load a grid, populate a form, save on...

The Job and SQL agent gets hung in a few seconds(<10 sec).

Weird thing is, when I run sp_addsubscription manually in SSMS, it is successful.  The issue is only when...

We have a group who's sole responsibility is to write reports.  They are supposed to be doing data analysis, but that's another subject.

None of them have any technical skills,...

how long does the job hang for before you kill it - a 650GB restore across the network will take a bit of time … just thinking

also with backup and...