Category Archives: SQLServerPedia Syndication
-
DDL Trigger to log database level security commands.
Leave a commentJune 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)
8June 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 -
My journey with hybrid technologies. Where it started, how it’s going, and where it ends. : T-SQL Tuesday #139
Leave a commentJune 8, 2021 by Kenneth Fisher
One of my favorite people is hosting TSQL Tuesday this month. Ben Weissman (blog|twitter). He wants us to talk about …
Continue reading -
Use BCP to create a CSV (comma delimited) file from a table.
1June 3, 2021 by Kenneth Fisher
This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one …
Continue reading -
SQL Homework – June 2021 – SQL Audits
Leave a commentJune 1, 2021 by Kenneth Fisher
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. …
Continue reading -
The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.
3May 27, 2021 by Kenneth Fisher
I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the …
Continue reading -
What account is xp_cmdshell using?
2May 25, 2021 by Kenneth Fisher
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. …
Continue reading
