what happened to good old fashioned command prompt tools

dir /s *.ldf

none of this fancy SQL malarkey 🙂

the only thing I can think to say is install SSDT - it may install a few DLLs  that he needs - it's not a big install and it's quite...

A neat little script that fits in well with some of the themes we're seeing recently about having clean databases with no customer data inside.

there are 2 other ways I...

most sites just say - reinstall ssms and ssdt

are the paths the same on both servers? I've never seen a dethatch lose a log file

I'd wager that the .ldf file is somewhere

I learnt this from a wise old network manager who told me that you catch more flies with honey than...

you might not want to use "alter user"

if you are setting a login password then ALTER LOGIN

a few things you can do

1: put static code analysis in place, if the devs can see their code isn't great, they'll have less of an argument

2:use the sql performance...

this helped me out last time

https://blogs.technet.microsoft.com/dataplatform/2017/08/03/sql-performance-counters-are-missing/

by the way - has anyone twigged that permission management for SSIS is a pile of garbage?

I use the 2017 tools (vs and ssdt) but I have just bumped up to sql management studio 18.3.1 which is "not what I expected" - especially since it has...

That's great. I...

If I can ever get SSIS to work, I'm hoping to start using it, I used to love bcp, other forms of bulk loads etc, but our systems got...

an ex  colleague of mine used to turn up in knee length shorts, Hawaiian shirt, flip flops and a lot of "bling" -

the directors put out an email...

I've also been hired many times to improve ETL processes and the first thing I normally do is get rid of the related SSIS packages because of the atrocities...

• This reply was modified 5 years, 11 months ago by MVDBA (Mike Vessey).