-
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
Leave a commentAugust 18, 2022 by Kenneth Fisher
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in …
Continue reading -
SQL Server Query Tuning and Optimization by Benjamin Nevarez
Leave a commentAugust 16, 2022 by Kenneth Fisher
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as …
Continue reading -
Using DBCC CLONEDATABASE to create a schema only copy of your database.
Leave a commentAugust 11, 2022 by Kenneth Fisher
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s really cool when I need it. …
Continue reading -
Visiting with DBAs at midnight : T-SQL Tuesday #153
Leave a commentAugust 9, 2022 by Kenneth Fisher
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our host for this month’s episode of …
Continue reading -
What’s next III
2August 4, 2022 by Kenneth Fisher
In case you didn’t know I was given notice about a month and a half ago. Since I’ve talked about …
Continue reading -
SQL Homework – August 2022 – Replication part 1
Leave a commentAugust 2, 2022 by Kenneth Fisher
You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really …
Continue reading -
Perspective
1July 28, 2022 by Kenneth Fisher
I recently passed the second anniversary of the start of my stay in the hospital. A lot has happened since …
Continue reading -
SSMS Put pinned tabs in their own row
2July 21, 2022 by Kenneth Fisher
A while back (6 years ago 😲) I talked about how you can change the behavior of SSMS so that …
Continue reading -
#PowershellBasics: Multi-line commands
2July 19, 2022 by Kenneth Fisher
When I’m sharing code one of the things I hate most is having a scroll bar along the bottom. I …
Continue reading