Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how...
2019-02-06 (first published: 2019-01-19)
2,251 reads
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how...
2019-02-06 (first published: 2019-01-19)
2,251 reads
Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together.
WARNING
This is NOT a...
2019-01-04 (first published: 2018-12-24)
1,853 reads
There was a question in the #dbatools slack channel
Getting dbatools
dbatools enables you to administer SQL Server with PowerShell. To get...
2018-12-03
245 reads
In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by...
2018-12-19 (first published: 2018-12-01)
1,845 reads
30/11/2018 – Function has been updated to deal with named instances.
Last week the Tiger Team released their Availability Group Failover Detection...
2018-12-17 (first published: 2018-11-28)
1,960 reads
Following an upgrade to SQL Server the backup share had a number of backups, some from the old version and...
2018-12-12 (first published: 2018-11-26)
1,707 reads
Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of...
2018-10-31
251 reads
It’s been a few weeks since i have blogged as I have been busy with a lot of other things....
2018-10-10 (first published: 2018-09-29)
1,944 reads
Just a quick post to share some code that I used to solve a problem I had recently.
I needed to...
2018-09-04 (first published: 2018-08-21)
5,365 reads
In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including...
2018-08-16
315 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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; GOSee possible answers