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

Archives: November 2017


It’s been a long career for me. In fact, I’ve been a SQL Server data professional for 17 years, just over half my life and almost the entire lifetime of the product.

In that time, I’ve worked for a number of companies in different positions. Some were good jobs, some… Read more

0 comments, 118 reads

Posted in The Voice of the DBA on 23 November 2017

Azure SQL Database – Service Tiers

Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from the least expensive basic database to the more premium ones I thought it would be worthwhile capturing the costs (GBP) across all tiers.

Basic 5 DTUs

Standard (S0) 10 DTUs

Read more

0 comments, 92 reads

Posted in All About SQL on 23 November 2017


As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it separately. In my previous tips of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install RHEL on the created virtual machine,… Read more

0 comments, 146 reads

Posted in SQL Geek on 23 November 2017

Biml for a Task Factory Dynamics CRM Source Component

I recently worked on a project where a client wanted to use Biml to create SSIS packages to stage data from Dynamics 365 CRM. My first attempt using a script component had an error, which I think is related to a bug in the Biml engine with how it currently… Read more

2 comments, 141 reads

Posted in Data Savvy on 22 November 2017

Finding #dbatools #PowerShell commands

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

I was reading about Pester from Rob Sewell… Read more

0 comments, 155 reads

Posted in The Voice of the DBA on 22 November 2017

MySQL has this feature that SQL Server needs

In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because MySQL is predominantly used for websites as part of the free LAMP stack (Linux, Apache, MySQL and PHP), while SQL Server’s range is much broader than that. There’s one neat… Read more

0 comments, 129 reads

Posted in Born SQL with Randolph West on 22 November 2017

I May Never Be a Data Scientist

Chances are extremely high that I’ll never put down Data Scientist as my job. Considering what you do and what you know, I’ll bet a healthy percentage of you are in a similar situation. That’s OK. You know why? You know a lot about data, data movement and data processing… Read more

2 comments, 122 reads

Posted in The Scary DBA on 22 November 2017

Monitoring and Alerts with Azure SQl Database

Continuing with the Azure SQL Database theme, in this short video David demonstrates how to setup alerts for an Azure SQL database and build a dashboard to monitor the metrics of your Azure SQL database

You can download the free ebook: Putting Your Head in the Cloud: An Introduction to…

Read more

0 comments, 107 reads

Posted in The SQL DBA in the UK on 22 November 2017

Thankful DBA

This week is Thanksgiving in the United States, so I thought it fitting to write a quick blog on what I am thankful for as a DBA. These are in no particular order and feel free to respond with something you are thankful for. I’d love to hear it.

  1. Glenn…

Read more

1 comments, 130 reads

Posted in SQLEspresso on 22 November 2017

"the input device is not a TTY" error running docker on VSTS build agent

I have been playing around with including all my build dependencies in docker for windows lately and had a build that kept giving me this error in the build log:

"the input device is not a TTY. If you are using mintty, try prefixing the command with 'winpty'"

The command…

Read more

0 comments, 106 reads

Posted in Ed Elliott's Sql Developer Blog on 22 November 2017


In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we will install SQL Server 2017 on Red Hat Enterprise Linux (RHEL).

  • Connect to the RHEL virtual machine and log on to the server by keying username and password

  • Switch to…

Read more

0 comments, 182 reads

Posted in SQL Geek on 22 November 2017

SQLpassion Black Friday Deal

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

As we all know the Black Friday approaches quite fast, and therefore I also want to offer… Read more

0 comments, 163 reads

Posted in Klaus Aschenbrenner on 21 November 2017

How do I use VSTS variables in YAML CI Build definitions?

Hey, VSTS YAML builds are my new favorite thing, by like a million miles.

If you have a yaml build definition ( .vsts-ci.yml ) and you want to use one of the build variables then it isn't totally clear how to include them in a definition (it hasn't been out…

Read more

0 comments, 147 reads

Posted in Ed Elliott's Sql Developer Blog on 21 November 2017

SQL Server 2017 : Data Transformation and Interpolation using Python

As a continuation to my previous article, How to use Python in SQL Server 2017 to obtain advanced data analytics, a little bit of curiosity about Deep Learning with Python integration in SQL Server led me to write this latest article.

With Python running within SQL Server, you can bring… Read more

0 comments, 128 reads

Posted in PowerSQL By Prashanth Jayaram on 21 November 2017

Power BI Custom Visuals Class (Module 78 – Data Image by CloudScope)

In this module you will learn how to use the Data Image Power BI Custom Visual by CloudScope. The Data Image visual helps in displaying images based on an image URL stored in your data.

Module 78 – Data Image by CloudScope


Read more

0 comments, 119 reads

Posted in Devin Knight on 21 November 2017

Microsoft Professional Program in Data Science – The Finish Line

In October 2017, I completed the capstone project of the Microsoft Professional Program for Data Science. I’ve blogged about this program before:

I’m happy to announce I got the certificate: Read more

0 comments, 218 reads

Posted in Koen Verbeeck on 21 November 2017

SQL Server on Linux Installation On RHEL Server – PART1

In the previous posts, we learned how to install SQL Server on Ubuntu Server & install SQL Server on CentOS. Today, we’ll walk through how to install SQL Server on RHEL Server. At the end of this blog, you will be familiar with the installation of SQL Server on… Read more

0 comments, 255 reads

Posted in SQL Geek on 21 November 2017

Sessions, Temporary Objects, and the Afterlife

For thousands of years theologians have offered various thoughts on the question of what happens when we die. Does some part of who we are come back to start over again? Do we go to some other place? Is “the end” simply that: the end, in an absolute sense? When… Read more

1 comments, 162 reads

Posted in SQL Quantum Leap on 20 November 2017

What is Azure Databricks?

Azure Databricks (documentation and user guide) was announced at Microsoft Connect, and with this post I’ll try to explain its use case.  At a high level, think of it as a tool for curating and processing massive amounts of data and developing, training and deploying models on that… Read more

0 comments, 175 reads

Posted in James Serra's Blog on 20 November 2017

Eliminating Hassles

It is easy for me to fall into the trap of the “who” versus the “what”. If we are not careful we can get caught up in a web entangled mess. I often get asked how do I go about handling each day and staying organized. Let me be the… Read more

0 comments, 112 reads

Posted in The SQL Professor on 20 November 2017

Older posts