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

Archives: July 2018

Information Measurement with SQL Server, Part 4.2: The Jensen–Shannon Divergence and Its Relatives

by Steve Bolton

…………In the last installment of this amateur series of self-tutorials on DIY data mining metrics, we saw how a mathematical property known as absolute continuity hampered the Kullback-Leibler Divergence. It is still perhaps the most widely mentioned information distance measure based on Shannon’s Entropy, but a… Read more

0 comments, 2,200 reads

Posted in Multidimensional Mayhem on 31 July 2018

SQL Server – Blocking a Truncate

The truncate option is fast and efficient but did you know that it takes a certain lock where you could actually be blocked? What am I talking about? When you issue a truncate it takes a Sch-M lock and it … Continue reading

Read more

2 comments, 538 reads

Posted in All About SQL on 31 July 2018

Community Engagements Second Half of 2018 – It’s all about Biml

I have a couple of community engagements coming up in the second half of 2018 and I’d like to share an overview with you. Some might remember my Biml meetup session at the start of this year. Basically I turned this session into two talks: an introduction to Biml… Read more

0 comments, 316 reads

Posted in Koen Verbeeck on 31 July 2018

Power BI Custom Visuals Class (Module 113 – Small Multiple Line Chart)

In this module you will learn how to use the Small Multiple Line Chart. The Small Multiple Line Chart allows you to display multiple mini line charts within a single visual that you can facet by an attribute value.

Module 113 – Small Multiple Line Chart


  • Power BI Custom…

Read more

0 comments, 2,252 reads

Posted in Devin Knight on 31 July 2018

Should You Use Index Hints?

Watch this week’s post on YouTube

One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.

Usually it does a pretty good job, which is a great because if it didn’t then we’d be spending most of our… Read more

3 comments, 3,190 reads

Posted in Bert Wagner on 31 July 2018

Failed to join local availability replica to Availability Group – SQL Server error 41106 and 41158

When you configure SQL Server AlwaysOn Availability Group from management studio, it may fail with below error while joining secondary replica to the availability group. Today, While I was preparing some demo on AlwaysOn for the community event, I encountered the same issue. So, I thought to blog the solution… Read more

0 comments, 2,942 reads

Posted in SQL Geek on 31 July 2018

SQL Server Availability Group Auto Seeding Error

SQL Server Availability Group Auto Seeding is a wonderful thing, it saves database administrators time when setting up availability groups.  However I found an issue with the graphical user interface in bedded in SQL Server Management Studio that makes it appear as if auto seeding has failed and SQL Server… Read more

0 comments, 316 reads

Posted in vitamindba on 30 July 2018

Coming Back After complete 3 Years

Friends/My Readers,

Its been a long i have been away from my blogging.When i see back Its exactly 3 yrs Today(30/July/2015 – 30/July/2018)

Neither I stop Learning in all these Years Nor do i stop writing.
Neither I stop to Gain Experience Nor do i stop my Ideology “Help… Read more

0 comments, 298 reads

Posted in AshishSharePointBlog on 30 July 2018

Identifying HIPAA, PCI & SOX Data for Masking

Working for a company based in the UK (still currently a part of the EU) I had a lot of motivation to learn about the GDPR and what it means for data professionals. Further, the understanding that, through treaties and court precedent, the GDPR can apply to companies around the… Read more

0 comments, 2,656 reads

Posted in The Scary DBA on 30 July 2018

#SQLCareer 2/4 July 25th 2018

Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database field shared four random days out of our lives. This is one of them. Number two in fact. The first one was the day after… Read more

0 comments, 1,488 reads

Posted in SQLStudies on 30 July 2018

The Failed One Laptop Per Child Project

I wrote about OLPC back in 2010 (and before that, somewhere back on a post I didnt port over here from SSC). It was a vision worth pursuing.  It failed though, for many reasons, perhaps not the least of the killer branding around the “$100 laptop” which turned out to… Read more

0 comments, 328 reads

Posted in SQLAndy on 30 July 2018

Are you a morning or evening person?

I am not a morning person. I’ve really tried but there’s something in me that just stops me from getting out of bed, even though I know I should.

I have friends who get up at 05:30 every day and for me, that’s the middle of the night!

It doesn’t… Read more

0 comments, 289 reads

Posted in The DBA Who Came In From The Cold on 30 July 2018

Disable or Turn-off SQL Server Telemetry Service

With SQL Server 2016, Microsoft is installing SQL Server Telemetry or CEIP (Customer Experience Improvement Program) Services by default. It sends feature usage info back to Microsoft. You cannot skip the installation of these services. I find most of the DBAs even don’t aware that they have installed the… Read more

1 comments, 2,960 reads

Posted in SQL Geek on 30 July 2018

ArcGIS Maps for Power BI: Plus subscription (2nd part); What's in it for me?

(2018-July-29) My initial attempt to explore and test the ArcGIS Map paid version continued after receiving a response from the ESRI support team. Initially, I couldn't see all the additional features of the Plus subscription and I wrote about that in my last blog post - ArcGIS Maps for Power…

Read more

1 comments, 293 reads

Posted in Data Adventures on 29 July 2018

Considerations for Using Layout Images in Power BI

Using layout images in Power BI has become a popular design trend. When I say layout images, I’m referring to background images with shapes around areas where visuals are placed. This is different from the new wallpaper feature that became available in the July release, which can be used to… Read more

2 comments, 1,949 reads

Posted in Data Savvy on 28 July 2018

How to handle big numbers in SSAS Tabular



I have recently faced the issue of handling big numbers in SSAS Tabular. Our SSAS model processes accounting data for an international company and some amounts in the original currency are huge for countries with a weak currency. So, we’ve been facing an issue of overflow Currency datatype… Read more

0 comments, 128 reads

Posted in Joyful Craftsmen Blog on 27 July 2018

Power BI new feature: Composite models

There are two really great features just added to Power BI that I wanted to blog about: Composite models and Dual storage mode.  This is part of the July release for Power BI Desktop and it is in preview (see Power BI Desktop July 2018 Feature Summary).  I’ll also… Read more

0 comments, 716 reads

Posted in James Serra's Blog on 27 July 2018

I’m speaking at SQL Saturday 749 : Baton Rouge

Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many other exciting speakers from around the country. My topic is a performance troubleshooting guide for DBAs; but, all are welcome to attend. This year is going to be amazing so… Read more

0 comments, 493 reads

Posted in Confessions of a Microsoft Addict on 27 July 2018

Friday Reading 2018-07-27

Phew, I’m not going to complain about the hot weather…I’ll miss it when it’s gone.

Linux Load Averages: Solving the Mystery
Good post by Brendan Gregg (t) explaining a critical metric

SQL Server on Linux – I/O internal thoughts
David Barbarin (t) on IO internals for… Read more

0 comments, 323 reads

Posted in The DBA Who Came In From The Cold on 27 July 2018

Adding File to Database in AlwaysOn Availability Group

When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database, those commons will also be sent to all the Secondary replicas database via log records.

So, If you are adding a database file – data or log to the Primary… Read more

0 comments, 715 reads

Posted in SQL Geek on 27 July 2018

Older posts