Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh...
2014-09-04
1,635 reads
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh...
2014-09-04
1,635 reads
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...
2014-08-25
1,113 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
943 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
537 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers