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
457 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,504 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
902 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
732 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
905 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
908 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
577 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
691 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)
987 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
447 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCP Galuh Mas Telp:0817866887
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers