Author Archives: Kenneth Fisher
-
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?
3May 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 -
#PowershellBasics: Writing to the screen
8May 20, 2021 by Kenneth Fisher
Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is …
Continue reading -
Creating a configurable SSMS script
1May 18, 2021 by Kenneth Fisher
Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from …
Continue reading -
#PowershellBasics: Comments and comment based help
5May 13, 2021 by Kenneth Fisher
I’ve talked about SQL Server comments before and how important they are. In PowerShell comments are important for all the …
Continue reading -
What do you do when technology changes? : T-SQL Tuesday #138
Leave a commentMay 11, 2021 by Kenneth Fisher
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us to discuss how we handle changes …
Continue reading -
All jobs that ran during a given time frame.
2May 6, 2021 by Kenneth Fisher
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of …
Continue reading
SQL Studies 