Category Archives: Microsoft SQL Server
-
SQL Agent job history on a Managed Instance
4July 25, 2023 by Kenneth Fisher
The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them …
Continue reading -
db_ddladmin Jr.
1July 20, 2023 by Kenneth Fisher
A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema …
Continue reading -
How do I tell if a user is orphaned or actually created without a login?
5July 18, 2023 by Kenneth Fisher
One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what …
Continue reading -
The two hardest concepts of security are Who? and Where?
3July 13, 2023 by Kenneth Fisher
I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security …
Continue reading -
Code that made you feel a certain way : T-SQL Tuesday #164
3July 11, 2023 by Kenneth Fisher
It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever …
Continue reading -
End of year planning: T-SQL Tuesday #157
Leave a commentDecember 13, 2022 by Kenneth Fisher
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the …
Continue reading -
#PowershellBasics: Warnings and how to hide them.
1December 8, 2022 by Kenneth Fisher
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain …
Continue reading -
SQL Homework – December 2022 – What’s new in SQL Server?
Leave a commentDecember 1, 2022 by Kenneth Fisher
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I …
Continue reading -
What is production grade code? : T-SQL Tuesday #156
1November 8, 2022 by Kenneth Fisher
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would …
Continue reading -
SQL Homework – November 2022 – Getting ready for the next time you have to look for a job.
Leave a commentNovember 1, 2022 by Kenneth Fisher
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up …
Continue reading
SQL Studies 