Words: 913
Time to read: ~ 4.5 minutes
DBA Fundamentals April 2018
Drip drip drop lil’ April showers…
When Stored Procedures say they Alter Schemas of the Target Table
…even when they shouldn’t!
Words: 423
Time to read: ~ 2 minutes
Continue reading “When Stored Procedures say they Alter Schemas of the Target Table”
Wait! There are JOINS in PowerShell???
And no I’m not talking about -join
Words: 278
Time to read: ~1.5 minute
Update: 2018-03-22 – Had the wrong link to Warren’s post on Join-Object; Added more examples on request.
Update: 2018-03-23 – Code and screenshot for LEFT JOIN was actually for FULL OUTER JOIN. Updated
PowerShell error “Quantifier {x,y} following nothing”
Some errors are stupid but some errors are helpful and it’s just you that’s stupid
Words: 819
Time to read: ~ 4 minutes
Continue reading “PowerShell error “Quantifier {x,y} following nothing””
T-SQL Tuesday #100 – Looking Forward 100 Months
Words: 584
Time to read: ~ 3 minutes
Continue reading “T-SQL Tuesday #100 – Looking Forward 100 Months”
Changing SQL Prompt defaults to work with Code Analysis
Code Analysis and Pester disagree on the whole “Green is good” aspect….
Words: 603
Time to read: ~ 3 minutes
Continue reading “Changing SQL Prompt defaults to work with Code Analysis”
DBA Fundamentals March 2018
3 months into the year, we’ll keep March-ing on!
Words: 9503
Time to read: ~ 5 minutes
Adding Your Own Checks to dbachecks
Check yo’self before you wreck yo’self!
Words: 691
Time to read: ~ 3.5 minutes
T-SQL Tuesday #99: Dealer’s Choice.
I need to get more hobbies!
Words: 771
Time to read: ~ 4 minutes
Advent of Code 2017: Day 01: Part 01
Because Christmas should be a time of PowerShell and debugging rather than this “joy” thing…
Words: 826
Time to read: ~ 4 minutes