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 →Category: SQL Server
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 →Speaking at SQL Saturday Melbourne 2017
I’m very happy to once again be making a trip across the Tasman and will be speaking about adding Powershell to your DBA toolkit at SQL Saturday Melbourne on February 11th. Check out the list of speakers here: SQL Saturday Melbourne 2017 It looks like the Melbourne team have once again pulled together a great list […]
Read More →How to Force a Database to A Specific Database_ID
I walked into the office this morning and got asked a strange question: “Does a database you detach and re-attach have the same database id before and after the detach?”. While it may appear that it does in a simple test, it actually doesn’t – it just takes the next available id. If you detach […]
Read More →