-
#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
4May 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.
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
SQL Studies
Live, Learn, Share
