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

Archives: September 2018

Checking Trace Flags with dbachecks, online docs and PSPowerHour

It’s been a few weeks since i have blogged as I have been busy with a lot of other things. One of which is preparing for my SQL Pass Summit pre-con which has lead to me improving the CI/CD for dbachecks by adding auto-creation of online documentation, which you can…

Read more

1 comments, 1,783 reads

Posted in SQL DBA With A Beard on 29 September 2018

Native UTF-8 Support in SQL Server 2019: Savior or False Prophet?

(last updated: 2018-11-19 @ 10:05 EST / 2018-10-17 @ 15:05 UTC )

(NOTE: 2 of the bugs I reported are supposedly fixed in CTP 2.1, so I will retest with CTP 2.1 and update in a few days)

For some time now, many of us have struggled with… Read more

4 comments, 1,122 reads

Posted in SQL Quantum Leap on 28 September 2018

Understanding a UK Keyboard for a US developer

One of the very interesting parts of my job is that I run into UK keyboards on a regular basis. Redgate is a UK company and most of the trade show laptops that they bring to events are UK layouts. Our VMs are built in the UK, and when I… Read more

0 comments, 908 reads

Posted in The Voice of the DBA on 28 September 2018

Azure Cognitive Services – Vision APIs

In this final post of my Azure Cognitive Services week of Azure Every Day, I’ll focus on the Vision APIs and Services within this stack. Azure Vision Cognitive Services leverages image-processing algorithms to smartly identify, caption and moderate your pictures. There are 3 APIs and 3 Services available in the… Read more

0 comments, 189 reads

Posted in DataOnWheels on 28 September 2018

Off to #SQLSat Pittsburgh

I’ve never been to Pittsburgh. Actually, in all of my speaking and traveling, I don’t think I’ve even flown through the airport. I’ve been wanting to rectify this, and quite a few friends, like Bill and Konstantine, have been asking me to come for years. The timing hasn’t worked out… Read more

4 comments, 860 reads

Posted in The Voice of the DBA on 28 September 2018

Finding Objects in a Schema #SQLNewblogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

One of the things I needed to do recently was move some objects from one schema to another. I wrote about moving an object between schemas recently, but… Read more

5 comments, 876 reads

Posted in The Voice of the DBA on 27 September 2018

Azure Cognitive Services – Speech APIs

This week in my Azure Every Day posts, I’ve been focusing on Azure Cognitive Services and what these features can add to your applications and your organization. Today my focus is the Speech APIs, which you can use to convert spoken audio into text, use voice for verification, or add… Read more

0 comments, 199 reads

Posted in DataOnWheels on 27 September 2018

Overview of SQL UNION

This article will provide a deep dive into the SQL UNION operator, describing its many uses along with examples and explore some common questions like the differences between UNION vs UNION ALL. To address real-world data requirements, we may need … Continue reading

Read more

0 comments, 594 reads

Posted in PowerSQL By Prashanth Jayaram on 27 September 2018

Things To Know About SQL Saturday Charlotte #806

Did you know that SQL Saturday Charlotte is just a few weeks away on October 20, 2018?  This will be the seventh year for SQL Saturday Charlotte.  Here are a few things we think you should know.

What’s New


After being at the same venue for the last six… Read more

0 comments, 153 reads

Posted in SQL Swimmer on 27 September 2018

Using Microsoft Azure – Twitter Analysis

Time for a fun post, I have been working on a mini-project using technology from Microsoft Azure to hook into Arsenal FC public twitter feed to analyse what was being said about this great football club. (Yes I support Arsenal) … Continue reading

Read more

0 comments, 276 reads

Posted in All About SQL on 27 September 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, 581 reads

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

CCI Bulk Load Pitfalls 2 – Parametrization of Dynamic SQL


In the last blog I showed how important statistics are for CCI bulk load even on small tables. This time I would like to show the surprising behavior of dynamic SQL, based on DB setting.


Again, I’m not discovering America here but the impact on CCI load is… Read more

0 comments, 35 reads

Posted in Joyful Craftsmen Blog on 26 September 2018

Book Review – Learning Pentaho Data Integration 8 CE

Yes, you’re reading that right. A book not about the Microsoft BI stack. At a project, Pentaho Data Integration (PDI) was used as an ETL tool. To get to know this tool a little better, I bought the book Learning Pentaho Data Integration 8 CE (Third Edition) by the author… Read more

0 comments, 231 reads

Posted in Koen Verbeeck on 26 September 2018

Best Hidden Feature in SQL Server 2019

With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet.  Most likely if you are following along you have heard of Big Data Clusters, Spark, Performance Tuning, and security features.  I am really excited about this new feature and hope you are… Read more

0 comments, 341 reads

Posted in John Sterrett on 26 September 2018

Cloud ETL for the Modern Enterprise Workshop

We are introducing a new workshop focused on Cloud ETL. ETL, or Extract, Transfer and Load, is nothing new and we’ve been integrating data through ETL techniques for decades now. However, what is new is the growing cloud offerings organizations are using and have access to today.   For the… Read more

0 comments, 190 reads

Posted in Marc Beacom on 26 September 2018

Azure means hybrid now

On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to make life a lot more interesting for many people all over the world. There’s a lot to process, so I’m going to take my time to pick through the announcements… Read more

1 comments, 179 reads

Posted in Born SQL with Randolph West on 26 September 2018

Azure Cognitive Services – Language APIs

In today’s post focusing on Azure Cognitive Analytics, I’ll look at the Language Analytics APIs that are available. These language APIs allow your apps to process natural language with pre-built scripts, evaluate sentiment and learn how to recognize what users want. Often, you’ll work with Speech and Language APIs together,… Read more

0 comments, 229 reads

Posted in DataOnWheels on 26 September 2018

Azure Database Migration Service (DMS)

As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that makes it easy to migrate from on-prem/RDS to Azure and one database type to another.  I’ll give a brief overview of some of the key features:

The… Read more

1 comments, 2,353 reads

Posted in James Serra's Blog on 26 September 2018

sqlhelp: limit the x-axis of a geometry line graph

I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide a range for the X-axis, for a large variance of Y-axis values. Is there a way to limit the X-axis range? Update: We have an answer! Thanks MJ! Yeah,… Read more

0 comments, 237 reads

Posted in SQL Awesomesauce on 26 September 2018

No More Mysterious Truncation

If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions a trace flag, which some of you might appreciate.

Here’s a little repro:


As you can see, the plee I made has actually been heard. I don’t know… Read more

6 comments, 3,166 reads

Posted in The Voice of the DBA on 26 September 2018

Older posts