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,852 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,706 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
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
A Question
Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b...
2018-08-17 (first published: 2018-08-01)
2,736 reads
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...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers