Writing Dynamic and Random Tests Cases for Pester
I have written a module SQLDiagAPI for consuming the SQL Server Diagnostics API with PowerShell. I blogged about how I...
2017-07-06
445 reads
SQL DBA With A Beard
Using Get-SQLDiagFix to get information from the SQL Server Diagnostic API with PowerShell
The SQL Server Diagnostics Preview was announced just over a week ago It includes an add-on for SQL Server Management...
2017-07-18 (first published: 2017-07-04)
1,496 reads
Creating a PowerShell Module and TDD for Get-SQLDiagRecommendations
Yesterday I introduced the first command in the SQLDiagAPI module. A module to consume the SQL Diagnostics API.
I have been...
2017-06-30
890 reads
PowerShell Module for the SQL Server Diagnostics API – 1st Command Get-SQLDiagRecommendations
I saw this blog post about the SQL Server Diagnostics add-on to SSMS and API and thought I would write...
2017-06-29
719 reads
VSCode – PowerShell extension 1.4.0 new command Out-CurrentFile
Yesterday David Wilson announced version 1.4.0 of the PowerShell extension for VSCode
Just released #PowerShell for VS @Code 1.4.0 with new...
2017-06-22
896 reads
dbatools at #SQLSatDublin
This weekend SQL Saturday Dublin occurred. For those that don’t know SQL Saturdays are free conferences with local and international speakers...
2017-06-21
896 reads
VS Code – Automatic Dynamic PowerShell Help
VS Code is my coding tool of choice. I love that one lightweight editor can do so much and as...
2017-06-12
565 reads
Pester for Presentations – Ensuring it goes ok
Whilst I was at PSCONFEU I presented a session on writing pester tests instead of using checklists. You can see it here
During the...
2017-05-16
675 reads
Pester Test Inception and the Show Parameter
My fantastic friend Andre Kamman b | t and I presented at PSConfEu last week
and whilst we were there we were...
2017-05-26 (first published: 2017-05-09)
982 reads
PowerShell Function – Validating a Parameter Depending On A Previous Parameter’s Value
I was chatting on the SQL Community Slack with my friend Sander Stad b | t about some functions he is writing for...
2017-04-26
435 reads
Blogs
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers