SQLStudies

#PowershellBasics: Finding a common AD group for a set of users.

• by Kenneth Fisher

• SQLStudies

A while back (almost 7 years ??) I wrote a post on finding the common AD groups of a set ... Continue reading

2021-06-17

8 reads

Long names vs short names (or aliases)

• by Kenneth Fisher

• SQLStudies

I remember when I was first learning to code there was always the argument of how long a name should ... Continue reading

2021-06-15

4 reads

CROSS vs OUTER APPLY

• by Kenneth Fisher

• SQLStudies

I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER ... Continue reading

2021-06-10

373 reads

My journey with hybrid technologies. Where it started, how it’s going, and where it ends. : T-SQL Tuesday #139

• by Kenneth Fisher

• SQLStudies

One of my favorite people is hosting TSQL Tuesday this month. Ben Weissman (blog|twitter). He wants us to talk about ... Continue reading

2021-06-18 (first published: 2021-06-08)

177 reads

Use BCP to create a CSV (comma delimited) file from a table.

• by Kenneth Fisher

• SQLStudies

This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one ... Continue reading

2021-06-03

144 reads

SQL Homework – June 2021 – SQL Audits

• by Kenneth Fisher

• SQLStudies

Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. ... Continue reading

2021-06-14 (first published: 2021-06-01)

242 reads

The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.

• by Kenneth Fisher

• SQLStudies

I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading

2021-06-11 (first published: 2021-05-27)

189 reads

What account is xp_cmdshell using?

• by Kenneth Fisher

• SQLStudies

It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. ... Continue reading

2021-05-25

91 reads

#PowershellBasics: Writing to the screen

• by Kenneth Fisher

• SQLStudies

Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is ... Continue reading

2021-06-04 (first published: 2021-05-20)

567 reads

Creating a configurable SSMS script

• by Kenneth Fisher

• SQLStudies

Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from ... Continue reading

2021-05-28 (first published: 2021-05-18)

668 reads