Forum Replies Created

Viewing 15 posts - 1 through 15 (of 216 total)

  • RE: Workplace Encounter: Effects of TLS 1.2

    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....

  • RE: Code Reviews

    adelio.stevanato 21159 - Monday, December 17, 2018 5:15 AM

    And i do most of those but it is just hard to see everything...

  • RE: Code Reviews

    paul s-306273 - Friday, December 14, 2018 8:11 AM

    Suggested code reviews, but never had any takers.
    Getting through change control is diferent though...

  • RE: Regex in Replace?

    Phil Parkin - Tuesday, September 25, 2018 2:21 PM

    ken.trock - Tuesday, September 25, 2018 12:27 PM

    September 25, 2018 at 2:39 pm


  • RE: The Right Connection

    Ken Mercadante - Thursday, April 19, 2018 6:35 AM

    I use the colored connections in Management Studio, but they're inconsistent and don't always...

  • RE: The Right Connection

    allinadazework - Thursday, April 19, 2018 3:53 AM

    It would probably help a great deal if servers had better names... they always seem...

  • RE: Can't zero pad a variable

    JustMarie - Wednesday, October 11, 2017 2:52 PM

    The reason you're not seeing your padding and Phil's code will work is that the...

  • RE: Identify gaps in date in employee table

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


  • RE: How to run SSIS Project as a SQL Job

    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...

  • RE: How to run SSIS Project as a SQL Job

    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...

  • RE: Using OVER() to Remove Duplicate Rows

    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...

  • RE: What's Your Backup Speed?

    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.


  • RE: 8 Ways to Export SQL Results To a Text File

    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...

  • RE: Can someone try this?

    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...

  • RE: SQL Authentication Via AD Groups Part III: What About Orphaned Users?

    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...

Viewing 15 posts - 1 through 15 (of 216 total)