Category: SQL Server

How Microsoft Protect Your Azure Databases

Microsoft have made the claim that you don’t need to run consistency checks on Azure SQL Databases because they take care of it. That’s nice, one less thing to worry about right? Of course to a DBA a claim like that falls into the same category as your backups being reliable without verifying them, or…I dunno…internet privacy not being a problem for people with nothing to hide. In short, unless I know HOW they are achieving this I am not going to consider my data safe, and even then I’m probably going to be dubious.

Read More →

SQL Saturday South Island is going to be awesome!

It’s 8 days until SQL Saturday South Island in Christchurch, and apart from this guy who still has to write his presentation – the event is going to be awesome. SQL Saturday South Island always punches above it’s weight for a SQL Saturday in a small city, and this year is no exception with 4 streams chock full of quality speakers. We’ve got a good mix including a bunch of MCM\MVP’s, subject matter experts and seasoned international speakers. But with quality like that comes a dilemma or two…

Read More →

SQLSAT582: Resolving the “WinRM firewall exception will not work since one of the network connection types on this machine is set to Public” Error.

At SQL Saturday Melbourne, an otherwise excellent event, my demo failed on me because the DBAtools module failed to load with the following error: Set-WSManQuickConfig : <f:WSManFault xmlns:f=”http://schemas.microsoft.com/wbem/wsman/1/wsmanfault” Code=”2150859113″ Machine=”localhost”><f:Message><f:ProviderFault provider=”Config provider” path=”%systemroot%\system32\WsmSvc.dll”><f:WSManFault xmlns:f=”http://schemas.microsoft.com/wbem/wsman/1/wsmanfault” Code=”2150859113″ Machine=”<machinename>”><f:Message>WinRM firewall exception will not work since one of the network connection types on this machine is set to Public. […]

Read More →

Resolved – A job step received an error at line 3 in a PowerShell script. The corresponding line is ‘$space.ForegroundColor

I was working on some Powershell automation for a weekly process for one of my colleagues and set up the powershell script to run via a SQL 2014 agent job.  After some initial permissions errors I ran into this error: Executed as user: <Agent Account>. A job step received an error at line 3 in a […]

Read More →

Speaking at SQL Saturday Sydney 2017

I’m very happy to once again be making a trip across the Tasman and will be speaking about Increasing your SQL Server performance at SQL Saturday Sydney on February 18th.  Check out the list of speakers here: SQL Saturday Sydney 2017 This will be my second time presenting at the Sydney event after an enjoyable trip there […]

Read More →