SQL DBA With A Beard

Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh...

2014-09-04

1,593 reads

Refreshing A SQL Mirrored Database Using Powershell

SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...

2014-08-25

1,093 reads

I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
He...

2014-05-05

857 reads

A very short blog today just to pass on this little script.
I was required to list all of the SysAdmins...

2014-04-14

522 reads

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

I am off to Live 360 today, on my last trip of the year....

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...

Comments posted to this topic are about the item Stairway to Snowflake Level 5...

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';