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,907 reads

Posted in SQL DBA With A Beard on 29 September 2018

Missing Index Recommendations, These Are Not The Indexes You’re Looking For

Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him a call…

Read more

0 comments, 132 reads

Posted in Gavin Draper's SQL Server Blog on 29 September 2018

Missing Index Recommendations, These Are Not The Indexes You're Looking For

Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him a call…

Allister : "Hey Doug, got this really slow query can you tell me why?"
Doug : "Sure send me the execution plan"
Allister "One sec.. Requested the plan…

Read more

0 comments, 123 reads

Posted in Gavin Draper's SQL Server Blog on 29 September 2018

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

(last updated: 2019-01-10 @ 16:00 EST / 2019-01-10 @ 21:00 UTC )

(NOTE: For recent update, please see “Update for CTP 2.2” section)

For some time now, many of us have struggled with data that is mostly standard US-English / ASCII characters but also needs to… Read more

5 comments, 1,550 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, 1,004 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, 279 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, 955 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, 1,101 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, 296 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, 742 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, 241 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, 398 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, 772 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, 127 reads

Posted in Joyful Craftsmen Blog on 26 September 2018

Azure Outage Post-Mortem Part 3

My previous blog posts, Azure Outage Post-Mortem – Part 1 and Azure Outage Post-Mortem Part 2,made some assumptions based upon limited information coming from blog posts and twitter. I just attended a session at Ignite which gave a little more clarity as to what actually happened. Sometime tomorrow you… Read more

2 comments, 46 reads

Posted in Clustering for Mere Mortals 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, 402 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, 507 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, 279 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, 332 reads

Posted in Born SQL with Randolph West on 26 September 2018

Older posts