Monthly Archives: July 2021
-
Server vs Instance. A rant.
3July 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 -
Speaking: In person vs webinars vs recordings
Leave a commentJuly 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 -
How do I unlock a SQL Server Login using T-SQL (without changing the password)?
2July 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 -
Experiment: If I have Dynamic Data Masking enabled will BCP pull the non masked data.
2July 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 -
Padding a string in SQL Server
3July 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 -
Interview with the Amazing Kellyn Pot’Vin-Gorman
Leave a commentJuly 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 -
The SQL Server community and the rising tide (and all that).
Leave a commentJuly 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 -
SQL Homework – July 2021 – Log shipping
Leave a commentJuly 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
SQL Studies 