Pester 4.2.0 has a Because…… because :-)
I was going through my demo for the South Coast User Group meeting tonight and decided to add some details...
2018-01-18
369 reads
SQL DBA With A Beard
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day
Chrissy has written about dbachecks the new up and coming...
2018-01-15
331 reads
Converting a Datarow to a JSON object with PowerShell
This is just a quick post. As is frequent with these they are as much for me to refer to...
2018-01-05 (first published: 2017-12-18)
1,607 reads
Handling Missing Instances when Looping with Pester
In my previous posts about writing your first Pester Test and looping through instances I described how you can start...
2017-11-30
673 reads
2 Ways to Loop through collections in Pester
In my last post I showed you how to write your first Pester test to validate something. Here’s a recap
Decide...
2017-11-28
373 reads
Write Your first Pester Test Today
I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group@SQLGlasgow and presenting sessions with Andre...
2017-11-16
438 reads
TSQL2sDay – Folks Who Have Made a Difference
This months TSQL2sDay is an absolute brilliant one hosted by Ewald Cress
the opportunity to give a shout-out to people (well-known...
2017-11-14
263 reads
Comparing Agent Jobs across Availability Group Replicas with PowerShell
On the plane home from PAS Summit I was sat next to someone who had also attended and when he...
2017-11-27 (first published: 2017-11-10)
1,501 reads
Using Plaster To Create a New PowerShell Module
Chrissy, CK and I presented a pre-con at PASS Summit in Seattle last week
Tracey Boggiano T | B came along to our...
2017-11-22 (first published: 2017-11-09)
1,442 reads
dbatools with SQL on Docker and running SQL queries
I had a question from my good friend Andrew Pruski dbafromthecold on twitter or SQL Container Man as I call...
2017-11-07
544 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers