-
Experiment: Does sp_recompile on a table update associated views.
2August 17, 2021 by Kenneth Fisher
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the …
Continue reading -
Work requests: It’s broke. Fix it.
3August 12, 2021 by Kenneth Fisher
Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you …
Continue reading -
Thoughts on a work/life balance – Spend Wisely : T-SQL Tuesday #141
1August 10, 2021 by Kenneth Fisher
Wow, it’s TSQL Tuesday again! Tjay Belt (blog|twitter) is our host this month and he’d like us to talk about …
Continue reading -
Interview Tip: Know your resume
Leave a commentAugust 5, 2021 by Kenneth Fisher
Seriously. Make a point of reading your resume before submitting it, and again before an interview. I’ve been helping with …
Continue reading -
SQL Homework – August 2021 – Security Standards
1August 3, 2021 by Kenneth Fisher
A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
Continue reading -
Server vs Instance. A rant.
2July 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)?
1July 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
1July 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
SQL Studies
Live, Learn, Share
