Author Archives: Kenneth Fisher
-
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 -
Another reason I prefer side-by-side SQL Server instance upgrades.
1June 29, 2021 by Kenneth Fisher
This is a quick non-technical discussion (i.e. not a how to in any way) of some of the benefits of …
Continue reading -
DDL Trigger to log database level security commands.
4June 24, 2021 by Kenneth Fisher
In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in …
Continue reading -
Why are my permissions missing?
Leave a commentJune 22, 2021 by Kenneth Fisher
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz …
Continue reading -
#PowershellBasics: Finding a common AD group for a set of users.
3June 17, 2021 by Kenneth Fisher
A while back (almost 7 years 😲) I wrote a post on finding the common AD groups of a set …
Continue reading -
Long names vs short names (or aliases)
9June 15, 2021 by Kenneth Fisher
I remember when I was first learning to code there was always the argument of how long a name should …
Continue reading -
CROSS vs OUTER APPLY
2June 10, 2021 by Kenneth Fisher
I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER …
Continue reading
SQL Studies 