Experiences with Microsoft Surface Pro 4

A few months back, GSM Connections had incredible offers on the Surface Pro 4 (& still do – the m3 @ €799 & i5 @ €899) with a black or blue Type keyboard included free – https://www.gsmconnection.eu/collections/smart-phones/products/microsoft-surface-pro-4-128gb-intel-core-i5 . I was looking for offers on this latest Surface Pro model for both my eldest son and myself.

The first difficulty was choosing between the fan-less m3 and the more powerful i5. Eventually, both of us chose the m3 over the i5 to have something more like an iPad rather than a PC. Both of us have other workhorse machines for heavy-duty work and we wanted something could be taken everywhere and use anytime.

However, there were a number of important lessons along the way.


Before doing anything else, CHANGE THE DATE to today.

The Surface is almost useless until you do this. Microsoft has released lots of important patches for the Surface but Windows Update does not work while the date is set to the default. It manifested itself in many ways – the normal welcome setup process did not work & I was unable to download my Microsoft profile.

The date issue was not obvious, so I did jump through many hoops. One of the laptops appeared dead for hours on end and I thought that I would have to return it but a forced reboot and that date change and all was well.

More help can be found here

Battery Life

Battery life was found to be lower on the m3 compared to the other models. This was surprising on the “mobility” chipset. The consensus appeared to be that the SkyLake chipset has settings for low power and for overdrive but some internal logic caused the Surface to use overdrive too often reducing battery life too frequently.

There were some articles around this here that I found incredibly useful and help counter the problem

For a finish, it is great to have a laptop that still has an hour left when the battery life dips below 10%


With the keyboard attached, closing the keyboard over the screen can be configured to sleep, hibernate, or shutdown. However, with sleep or hibernate, sometimes, nothing happens when you “open” the keyboard. If it happens, try the following in order until it works.

  • just close and open again – a few times if necessary; this is the most likely solution.
  • press the power button
  • hold the power button for 20-30 seconds
  • hold the power and volume-up button for 20-30 seconds

Bluetooth & WiFi

WiFi performance is far, far better when the Bluetooth is disabled. However, the very cool Surface pen uses Bluetooth so it is a trade-off. Disable Bluetooth if you need to do some serious downloading.

The Surface Pen

… is totally awesome. My son was studying old mathematics exam papers in PDF format. Double-clicking the top of the pen would copy the PDF into OneNote where you could annotate the document, scribbling on equations and graphs.

Handwriting recognition is very nice and, sometimes, I would use the pen over the keyboard because writing just feels so right! The auto-correct works beautifully but words that are run together in web links like “TheJournal” or “NewYorkTimes” are difficult to write correctly; the software does not appear to recognise or allow missing spaces.


The face/eye recognition has improved a lot over the past few months. For a while, I had to remove my glasses to be recognised which was inconvenient since I am almost blind without them. In enhanced security, it does check that I am not 2D, requesting me to shake my head slowly.

The power brick connection is much easier to use than the original Surface. The brick also comes with a USB port for charging another device. It does get very hot and the cable from wall-plug to brick is very short which is impractical for the dog living behind my sofa.

The new type keyboard is an improvement over previous models and is easy to use. It feels far more rigid than earlier versions while still remaining light.

The multi-position kick stand is far better than older versions that had only 1 or 2 positions. I was surprised how easy it was to use both the surface comfortably on my lap while typing on the keyboard.


Overall, I really do enjoy using the Surface and have stopped “borrowing” my better half’s iPad for quick surfing. My son uses his Surface for everything except serious gaming and brings it everywhere.

It would have been nice to have Office included. It was included in some previous iterations and the Surface is not cheap.

But I have no regrets on this purchase.


Waiting for MSSQL Database Restores to complete?

In my current role, we can have a lot of restores in progress during a maintenance window. This handy script allows us to calculate how long the restores will take and when our coffee break will end!

— Check Restores in Progress
        ,CONVERT(NUMERIC(38,2),r.percent_complete) AS [Percent Complete]
        ,CONVERT(VARCHAR(20),DATEADD(ms,r.estimated_completion_time,GetDate()),20) AS [ETA Completion Time]
        ,CONVERT(NUMERIC(38,2),r.total_elapsed_time/1000.0/60.0) AS [Elapsed Min]
        ,CONVERT(NUMERIC(38,2),r.estimated_completion_time/1000.0/60.0) AS [ETA Min]
        ,CONVERT(NUMERIC(38,2),r.estimated_completion_time/1000.0/60.0/60.0) AS [ETA Hours]
        ,CONVERT(VARCHAR(1000),(SELECT SUBSTRING(text,r.statement_start_offset/2,
                                                                CASE WHEN r.statement_end_offset = -1 THEN 1000
                                                                ELSE (r.statement_end_offset-r.statement_start_offset)/2 END)
        sys.dm_exec_requests r
        command LIKE ‘%restore%’;

Did you miss SQLSaturday #501 in Dublin?

As a previous organiser of SQL Saturday events in Dublin, I was bitterly disappointed to miss being an ordinary attendee at this year’s SQL Saturday  ( http://www.sqlsaturday.com/501/eventhome.aspx ). I had registered many months ago. Unfortunately, there was an unavoidable planned monthly maintenance window which lasted the whole day. I had hoped to get away and join the event in the afternoon but it was not to be.

But the great news is that some of the events were recorded and broadcast live on Microsoft’s Channel 9 and they are still available on the website – https://channel9.msdn.com/Events/SQL-Saturday/Learn-more-about-SQL-2016-Live-at-SQL-Saturday-Dublin-Ireland

Thank you to Microsoft and SQLSaturday Dublin for making this possible.

Removing an MSSQL file that was accidently or incorrectly added to a database

Recently, I have had a number of occasions where a new file was accidently added to the SQL Server database; for example, to the wrong file group.

The problem is slightly compounded if there is Transaction Logging in place.

There are number of steps to follow to correct the error

1 – Force the file to be emptied of any data

USE [InsertDatabaseNameHere]
DBCC SHRINKFILE(‘InsertLogicalFileNameHere’, EMPTYFILE);

2 – Remove the file from the database

USE [master]
ALTER DATABASE InsertDatabaseNameHere REMOVE FILE InsertLogicalFileNameHere;

3- If there is Transaction Logging or Log Shipping for this database, run an extra log backup. One cannot remove a file and then create it again within the same transaction log.

4- Add the file again with the correct settings. Change the values below to suit your configuration,

USE [master]

ALTER DATABASE [InsertDatabaseNameHere]
    NAME = N’InsertLogicalFileNameHere’,
    FILENAME = N’Z:\InsertDirectoryPathHere\InsertPhysicalFileNameHere.ndf’,
    SIZE = 1024MB , 
    MAXSIZE = 10240MB ,
) TO FILEGROUP InsertFileGroupNameHere;

%d bloggers like this: