Monthly Archives: July 2021

  1. Server vs Instance. A rant.

    2

    July 29, 2021 by Kenneth Fisher

    It’s a SQL Server Instance not a SQL Server. The product is SQL Server. The installed copy is an Instance. …
    Continue reading

  2. Speaking: In person vs webinars vs recordings

    Leave a comment

    July 27, 2021 by Kenneth Fisher

    I don’t speak all that often. A few times a year for the most part. Because of that I don’t …
    Continue reading

  3. How do I unlock a SQL Server Login using T-SQL (without changing the password)?

    1

    July 22, 2021 by Kenneth Fisher

    We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a …
    Continue reading

  4. Experiment: If I have Dynamic Data Masking enabled will BCP pull the non masked data.

    2

    July 20, 2021 by Kenneth Fisher

    Hypothesis: If I have Dynamic Data Masking enabled on a column then when I use something like BCP to pull …
    Continue reading

  5. Padding a string in SQL Server

    1

    July 15, 2021 by Kenneth Fisher

    I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to …
    Continue reading

  6. Interview with the Amazing Kellyn Pot’Vin-Gorman

    Leave a comment

    July 8, 2021 by Kenneth Fisher

    Thanks for agreeing to do this Kellyn. I’ve always found you to be one of the more interesting personalities in …
    Continue reading

  7. The SQL Server community and the rising tide (and all that).

    Leave a comment

    July 6, 2021 by Kenneth Fisher

    I was speaking with one of my favorite people in the SQL Server community, Grant Fritchey (blog|twitter), on twitter today. …
    Continue reading

  8. SQL Homework – July 2021 – Log shipping

    Leave a comment

    July 1, 2021 by Kenneth Fisher

    Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,576 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013