Category Archives: SQLServerPedia Syndication
-
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 -
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 Homework – May 2021 – Extended Events.
4May 4, 2021 by Kenneth Fisher
You’ve probably heard about extended events right? I honestly don’t care if you are #teamProfiler or #teamXE you need to …
Continue reading -
WITDC Mental Health and Wellness Day- May 7th
Leave a commentApril 29, 2021 by Kenneth Fisher
Next Friday WITDC is having a Mental Health and Wellness Day virtual event and I’ll be speaking! I can’t tell …
Continue reading -
#PowershellBasics: Setting a variable vs a comparison.
1April 27, 2021 by Kenneth Fisher
In SQL Server both the set and equality functions are handled by the equals sign (=). For example: Set Equality …
Continue reading -
Right sizing int : T-SQL Tuesday #136
4March 9, 2021 by Kenneth Fisher
Brent Ozar (blog|twitter) is our host this month, which will make this the most popular #tsql2sday to date I’m sure. …
Continue reading
SQL Studies 