SqlServer: get rowcounts for wildcards

Gist.

Advertisements

SqlServer/PowerShell: simple test of backup and restore

The SQLServer package has taken over from SQLPS. Basic backup and restore examples on my GitHub, and the data I used to create the tables (just create the databases by hand for now).

And the screenshots as I got the hang of it…

 

SQLServer: refresh in February 2018

For my own playing, the combination of LocalDB and SSMS continues to be sufficient for me. LocalDB is about 50MB, SSMS is about 800MB.

Location for SSMS download is here. (UK location any road). Pictures hopefully cover the rest.

I see that a year back or so, we were at SSMS 17.0 RC1, and at that point or recommended for production use. Now on 17.4. And as for LocalDB, well that is one of the SQLExpress variants. A year ago that was at SQLServer 2016 Express SP1. Now we are at SQL Server 2017.

And every time I forget the server name for LocalDB. It is (LOCALDB)/MSSQLLocalDB.

Reaper: creating and editing loops

The pictures should cover it all, apart from removing the selection, which is done by pressing the Esc button while you are in Reaper.  Please comment if you think it needs more.

 

Cycling in France

Aiming to take the campervan to France this year. Potential main cycling routes… no info yet on the Routes Vertes or the VeloRoutes. (BdS references are to Baie de Somme)

Honfleur to Deauville – 1 hour

Honfleur to Rouen – 4.5 hours

Dieppe to Rouen – 3.5 hours

BdS to Dieppe – 3 hours

Calais to Gravelines – 1 hour

Le Touquet to Dieppe – 6 hours

Calais to Dieppe – 9 hours

Calais to Le Touquet – 4 hours

BaieDeSomme to Amiens – 3.5 hours

Useful motoring maps