Category Archives: SQLServerPedia Syndication
-
#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.
Leave a commentMay 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.
2May 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 -
What is the CONTROL permission?
1January 19, 2021 by Kenneth Fisher
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: …
Continue reading -
Sometimes a change is as good as a break : T-SQL Tuesday #134
Leave a commentJanuary 12, 2021 by Kenneth Fisher
James McGillivray (blog|twitter) wants us to give him a break. Well. Actually I guess he wants to know how we …
Continue reading
