-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Hybrid DBA's Blog

Hamish is a Systems Management Specialist with a passion for efficient application deployment using DevOPs methodologies. He has 19 years IT experience in managing large scale databases SQL Server technologies. He has been managing SQL Server since SQL Server 2000 and pragmatic architectural design is his main focus in his current job. Educating and helping others learn is a driver for Hamish and he is a PASS User Group Leader, International speaker and a repeat guest lecturer at a local university.

Some of my goals for 2019

In late December 2018 I had a discussion with Amanda Martin the PASS Community Manager around things that I would be doing in 2019.  I thought I would share the questions we discussed, and my replies below.

What are your professional goals for 2019?

My professional goals for 2019… Read more

0 comments, 154 reads

Posted in The Hybrid DBA's Blog on 3 January 2019

Adding a database running in a docker container to SQLTest

in my previous post I wrote about how easy it is to add the tSQLt unit test framework to your database if it is running in a docker container.

How to use tSQLt unit test framework with a SQL Server database in a docker container

But let’s say you have… Read more

0 comments, 179 reads

Posted in The Hybrid DBA's Blog on 29 December 2018

How to use tSQLt unit test framework with a SQL Server database in a docker container

This blog post describes how to add the tSQLt unit testing framework to a database running in a docker container. You may have already read my article on how easy it is to install against a ‘normal’ SQL Server instance – running on windows…

How to install the tSQLt unit… Read more

1 comments, 1,073 reads

Posted in The Hybrid DBA's Blog on 29 December 2018

How to install the tSQLt unit test framework to start unit testing your database code

This blog post describes how easy it is to install the tSQLt framework.

Don’t know much about tSQLt? If you are serious about dealing with data in SQL Server then you should be as serious about unit testing the changes you are making to your stored procedures, functions and the… Read more

1 comments, 184 reads

Posted in The Hybrid DBA's Blog on 29 December 2018

SQL Server services will not start automatically after server reboots

This blog post is about a situation where after windows patching the SQL Server service and SQL Server Agent services will not start automatically – but will manually.

At a client site they had recently patched the servers – things went swimmingly – except the SQL Server services would not… Read more

1 comments, 161 reads

Posted in The Hybrid DBA's Blog on 17 December 2018

Setting up CentOS to run docker for SQL Server

This blog post is about running SQL Server in a docker container on CentOS Linux distribution.

This was both an experiment and also for me to re-learn CentOS – years ago I had done a fair bit with CentOS – back when I was a true Operations Consultant. Up until… Read more

4 comments, 209 reads

Posted in The Hybrid DBA's Blog on 13 December 2018

This is a company that practises what they preach

How good is a company at engaging with their user base? Obviously when things are going great then it’s wins all around for the company and hopefully the people have invested their money in that company’s products…

When things are not going well – I feel this is how you… Read more

0 comments, 873 reads

Posted in The Hybrid DBA's Blog on 22 October 2018

Connecting to SQL Server 2017 using Visual Studio 2017 and getting “An incompatible SQL Server version detected”

This blog post details the error you may get when using Visual Studio 2017 and you get errors that you cannot connect to SQL Server 2017 using Test Explorer or SQL Server Object Explorer.

TL;DR – upgrade Visual Studio from base version…..

I had built a new DEMO machine for… Read more

1 comments, 1,836 reads

Posted in The Hybrid DBA's Blog on 13 October 2018

Getting error “unable to parse remote unpack status” when attempting to push to Azure Repo in Azure DevOps

This blog post is about a situation where I went to push my latest local changes to my git repository up in Azure DevOps and got the weirdest error:

error: unable to parse remote unpack status: ng refs/heads/..

An error occurred while communicating with the remote host. The error code… Read more

0 comments, 709 reads

Posted in The Hybrid DBA's Blog on 27 September 2018

Why you should always build an Azure based VM in a Resource Group

This blog post is based on conversations I witnessed between MVPs around commissioning and more importantly de-commissioning virtual machines (VMs) hosted in Azure. Don’t worry – this blog post is not going to divulge NDA material….

…my MVP award is way too valuable to me to squander it!!

It comes… Read more

2 comments, 646 reads

Posted in The Hybrid DBA's Blog on 26 September 2018

How to sync user logins across SQL Server instances – dbatools is brilliant

This blog post is about how brilliant dbatools are. In this case – for syncing user logins between SQL Server instances.

Background:

Whenever I do my “DevOps and the DBA” talk I dedicate a minute or two talking about dbatools.

You can find the tools here:

https://dbatools.io/

Simply download and… Read more

1 comments, 810 reads

Posted in The Hybrid DBA's Blog on 13 April 2018

How to change the TFS Agent _work folder

This blog post is about how to change the default work folder _work that TFS agents use when building a solution.

Background:

I’m now a consultant – which is awesome – it means I get to visit clients and make a difference for them.

One particular client had installed TFS… Read more

1 comments, 451 reads

Posted in The Hybrid DBA's Blog on 10 April 2018

Use Boot Diagnostics to see what your Azure VM is doing at boot time

This blog post is about how to diagnose what your Azure VM is doing while it is booting.

I have a DEMO VM that is hosted in Azure – it is where I have Visual Studio, Redgate tools as well as all my DEMO systems, presentations hosted for when I… Read more

0 comments, 1,534 reads

Posted in The Hybrid DBA's Blog on 4 April 2018

Authentication issues with GitHub: An error occurred while sending the request —> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.

This blog post is about an error that you may receive if you’re using git commands in PowerShell and authenticating against GitHub.

My GitHub account uses 2 Factor Authentication so I thought it might be that – however I could use GitHub Desktop fine.

I was cloning a new project… Read more

0 comments, 555 reads

Posted in The Hybrid DBA's Blog on 31 March 2018

Redgate SQL Test utility isn’t showing up in SSMS

I had recently installed the SQL Toolbelt from Redgate at a client site on a laptop they’d supplied me.

(Fantastic product that SQL Toolbelt BTW.)

Things were going swimmingly – in fact thanks to SQL Compare, SQL Source Control and Team Foundation Server I had implemented an automated Continuous Delivery… Read more

0 comments, 323 reads

Posted in The Hybrid DBA's Blog on 21 March 2018

Automation and cleaner code/data are the key to future success

This blog post is a copy of a post I wrote for SQL Masters Consulting as part of T-SQL Tuesday. The original link can be found here:

https://sqlmastersconsulting.com.au/SQL-Server-Blog/t-sql-tuesday-100-automation-and-cleaner-code-data-is-the-key-to-future-success/

If you don’t already follow T-SQL Tuesday on twitter – you should – search for

#TSQL2sday

The blog post was a slight…

Read more

0 comments, 200 reads

Posted in The Hybrid DBA's Blog on 15 March 2018

Doing DevOPs for your Database? You need to start here…

I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…

In fact it was when I first joined Jade Software that I realised that Ops and DEV had a common interest in making systems go. In 2002 I started working… Read more

6 comments, 1,146 reads

Posted in The Hybrid DBA's Blog on 28 February 2018

The Data Platform has expanded – so too should our approach in using it….

In recent years we as data professionals have moved from dealing with SQL Server databases with SQL Server Reporting Server and SQL Server Analysis Services interacting with them (all on-premises) to a wide scale data platform.

In fact even the name of most SQL Server things (like my MVP) have… Read more

0 comments, 442 reads

Posted in The Hybrid DBA's Blog on 26 February 2018

If your Surface Book loses it’s keyboard and trackpad – try removing KB4074588 update

My Surface Book (gen 1) recently did updates and then a day or so later the keyboard and trackpad mysteriously stopped working. Then I heard of 3 other people who experienced the same issue within 24 hours.

I could use the Surface Book in tablet mode – but I tired… Read more

1 comments, 408 reads

Posted in The Hybrid DBA's Blog on 24 February 2018

Speaking at PASS Summit and why you need to think about submitting….

This post is about the honor and experience of speaking at PASS Summit not once (2016) but twice (2017).

I recently received an email from PASS HQ that asked past speakers to share our success stories – to help others consider submitting for PASS Summit as… Read more

1 comments, 328 reads

Posted in The Hybrid DBA's Blog on 29 January 2018

Older posts