I had trouble with IISCrypto. Instead, we used Set-Ciphers and DetectCipherConfig Powershell scripts developed by someone at Microsoft. We had a lot of machines to do and these really helped....

Thanks you guys for the queries. I hadn't thought of LAG(). My bad on the dates. Either one of these do the trick.

Ken

chuck.forbes (1/6/2017)

---

Just curious, why would this method be preferable over just creating a SQL Agent job and directly executing the dtsx? I've seen references to uploading SSIS jobs into the...

I use the "Save Copy of package" feature In Visual Studio project, choosing "SSIS Package Store" as package location, then when creating the SQL job browse for saved package. Is...

Whoa, I didn't realize either that deleting from the CTE could delete from the original table. And you can insert/update too. Glad I didn't learn that lesson at an inopportune...

2.4TB in just over 2 1/2 hours, or 1TB in just over an hour. This is for ~40DBs in total, compression ON. SQL 2012 using native backups.

Ken

For results to file, I have to Cast the columns to a shorter length than what they because, at least for .txt, a Varchar(200) will output a nice underlined column...

Yes, thank you everyone who responded. Definitely good info.

Lessons learned:

-Alias column names even in single table queries lest they get moved into larger queries un-aliased.

-Do thorough testing on even small...

Thanks a lot for the series. We have an intranet application that allows us to add users to domain groups that we're either a trustee or admin of. I have...