-->
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.

Can you speak at my User Group or Conference? No? Sweet As – can you help people register please?

This blog post is not going to be a technical one…. but it’s about technology – well more accurately about bringing technology to the masses.

I recently got awarded this:

0.0028% of people have been awarded within the PASS Community….   

What is it?

It is an award that is given… Read more

0 comments, 117 reads

Posted in The Hybrid DBA's Blog on 7 March 2019

How to resolve ‘Login failed for user’ and sa password lost (Error 18456)

This blog post explains how to get into SQL Server if you have lost your sa password or you have no way of getting into your SQL Server instance.

This blog post is dedicated to the people who came along to my training course in Wellington 22nd February 2019…..

Issue:

Read more

0 comments, 2,912 reads

Posted in The Hybrid DBA's Blog on 23 February 2019

Authentication considerations for your applications when migrating to Azure SQL Managed Instances

This blog post is related to my previous blog post on Azure SQL Managed Instances:

Azure SQL Managed Instance – full blown SQL Server in the cloud….?

Before you actually migrate your database you need to think about what changes to your application you may need to do.

Azure SQL… Read more

2 comments, 244 reads

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

Azure SQL Managed Instance – full blown SQL Server in the cloud….?

This blog post is one that I have had percolating in the background since around November 2018.

My good mate John Martin ( t ) was speaking at PASS Summit on Azure SQL Managed Instances and we had talked about use cases, some of the gotchas and things to consider… Read more

1 comments, 950 reads

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

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, 194 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, 233 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,182 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, 254 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

3 comments, 206 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, 245 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, 925 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,905 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, 772 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, 692 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, 990 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

2 comments, 515 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,579 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, 633 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, 355 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, 236 reads

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

Older posts