-
#PowershellBasics: Multiple run spaces in ISE
2October 16, 2019 by Kenneth Fisher
As you know from the last few posts, I’m in a class on Powershell. One of the first things we …
Continue reading -
#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.
Leave a commentOctober 14, 2019 by Kenneth Fisher
I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That …
Continue reading -
#PowershellBasics: Powershell vs Powershell Core
1October 10, 2019 by Kenneth Fisher
I’m taking a Powershell class this week and I have to say the teacher is one of the best I’ve …
Continue reading -
Using 3rd party tools. T-SQL Tuesday #119
1October 8, 2019 by Kenneth Fisher
It’s that time again! Alex Yates (b/t) has asked us to discuss a time in tech when we’ve changed our …
Continue reading -
SQL Homework – October 2019 – Code review (self and peer)
Leave a commentOctober 2, 2019 by Kenneth Fisher
Every database person I’ve ever met writes at least some code at some point in their career. That code might …
Continue reading -
See SQL Run 2
2September 30, 2019 by Kenneth Fisher
Note: I am perfectly aware of my ability as an artist so let the ribbing begin 🙂
-
Blogging and coding best practices
Leave a commentSeptember 25, 2019 by Kenneth Fisher
I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. …
Continue reading -
Debugging techniques (focusing on T-SQL)
11September 23, 2019 by Kenneth Fisher
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: …
Continue reading -
When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.
Leave a commentSeptember 18, 2019 by Kenneth Fisher
When studying Azure one of the things you’ll be asked to learn is the Powershell commands that can control, well, …
Continue reading -
DBA Myths: CHECKDB runs on startup.
2September 16, 2019 by Kenneth Fisher
If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup: CHECKDB for …
Continue reading
SQL Studies
Live, Learn, Share
