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

Archives: July 2017

Power BI Custom Visuals Class (Module 61 – Power KPI)

In this module you will learn how to use the Power KPI Custom Visual.  The Power KPI displays your KPI indicator values on a helpful multi-line chart with labels.

Module 61 – Power KPI


Read more

0 comments, 24 reads

Posted in Devin Knight on 25 July 2017

SSoL: Where are my data and log files?

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember the skills I used to have back in university. Read more

0 comments, 61 reads

Posted in The Voice of the DBA on 25 July 2017

Statistics and the Ascending Key Problem

I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly affect your cardinality estimation in some cases and therefore your execution plans.

The Ascending Key Problem relates to the most recently… Read more

0 comments, 32 reads

Posted in Matthew McGiffen DBA on 25 July 2017

SQL Server Management Studio: Video Tutorial

SQL Server Management Studio is the all in one tool for developers and DBAs alike to work with SQL Server. In this short tutorial we look at how you can download install and connect to a SQL Server instance and have a quick look at object explorer and some of…

Read more

0 comments, 49 reads

Posted in The SQL DBA in the UK on 25 July 2017

Sudden Differential Backup Failures after an Availability Group Failover

As so many stories do, this story starts with a failover - in this case an Availability Group (AG) failover.


There were several different backup and status check jobs failing on NODE01 and NODE02 because the AG01 availability group was now primary on NODE02 instead of NODE01 after a…

Read more

0 comments, 130 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 July 2017

Geek Sync on Wednesday: Taking Control of Your Organization’s SQL Server Sprawl

This Wednesday, July 26th, at 12 PM EDT, I’ll be giving a presentation through Idera’s Geek Sync series. You will need to register for the session.

Registration Link for Geek Sync talk

Here’s what I’ll be covering:

You have SQL Server sprawl throughout your organization. There are SQL Servers installed… Read more

0 comments, 66 reads

Posted in Databases – Infrastructure – Security on 24 July 2017


Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

There’s been a programmer test that was used for awhile to see… Read more

2 comments, 137 reads

Posted in The Voice of the DBA on 24 July 2017

Database Fundamentals #6: Create a Table with the SSMS GUI

The whole idea behind databases is to store information, data, in order to look at it later. The place where that data is going to be kept is referred to as a table. A table consists of columns and each column can be defined to store a variety of specific… Read more

0 comments, 79 reads

Posted in The Scary DBA on 24 July 2017

SQL Summer Vacation–SentryOne

We are having an extra Louisville SQL Server and Power BI User Group meeting this month due to the SQL Summer Vacation coming into town. SentryOne’s Kevin Kline (B|T) will be rolling into town for a fun filled 2-hour event on Wednesday the 25th. This is… Read more

0 comments, 76 reads

Posted in The SQL Professor on 24 July 2017

SQL Server on Linux Series: Additional Drives

One of the biggest differences with managing SQL Server Linux is with drive presentation. With Windows, we’d all scream if we saw a SQL Server with just one drive (C:) and everything piled on it. The same goes for any other operating system, including Linux. But, how do we get… Read more

0 comments, 94 reads

Posted in Technobabble by Klee from @kleegeek on 24 July 2017

Upcoming SQL Server User Group Presentations

I’ll be speaking at two New England area SQL Server user groups in the next few days! First, tonight I’ll be at the Portsmouth, NH, SQL Server Users Group speaking on the newly announced SQL Server on Linux. It’s going to be a blast showing folks that SQL Server… Read more

0 comments, 60 reads

Posted in Technobabble by Klee from @kleegeek on 24 July 2017

Default SQL Agent Reports – Top Jobs

Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several ways to do this depending on your preference. You can use the system views.

Honestly, though, as much as I love writing queries for… Read more

0 comments, 107 reads

Posted in SQLStudies on 24 July 2017

Upcoming Content

This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts will be are notes, code snippets and processes I am using and coming up with to figure out how to move the entire SQL Server infrastructure from on-prem to an… Read more

0 comments, 143 reads

Posted in WaterOx SQL on 24 July 2017

Announcing PSDay.UK – Whats a PSDay?

On Thursday evening I attended the joint London WinOps and PowerShell User Group. It was an excellent evening with two great sessions by Jaap Brasser and Filip Verloy.


There was also an exciting announcement about PSDay.UK  https://psday.uk

Read more

2 comments, 119 reads

Posted in SQL DBA With A Beard on 24 July 2017

Installing SQL Server: Video Tutorial

In this video I talk you through installing SQL Server 2017 RC1 on Windows Server 2016 virtual machine. It’s a nice simple process.

If you need help with SQL Server check out our SQL Server Consultingpage

Read more

0 comments, 84 reads

Posted in The SQL DBA in the UK on 24 July 2017

Monday Coffee: SQL Services in Containers

I had an interesting question on twitter last week when I published my post on Running Linux Container on Windows: –

“Does that container support Microsoft ML yet?”

I have absolutely no experience with Machine Learning so really had no clue. But as I had the container up and… Read more

0 comments, 94 reads

Posted in The DBA Who Came In From The Cold on 24 July 2017

RegEx in SQL Server for searching texts

As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding some strings/sub-strings in the text columns. In such situations we usually make two or more of queries in order to cover the various cases, or even don’t try it because… Read more

0 comments, 159 reads

Posted in Si vis pacem, para sql on 24 July 2017

Calculating Travel Distance/Time in Power BI using Bing Map API

[2017-July-24] Map visualization in Power BI has drawn many data professionals into a field of ?reating visual data stories with maps. It only takes a dataset of Geo located data points to do this and everything else is managed by map visual controls plus one's imagination. You have a choice…

Read more

0 comments, 599 reads

Posted in Data Adventures on 24 July 2017

24 Hours of PASS Session Slides Uploaded

My slide deck from the recent webinar series 24 Hours of PASS, Summit Preview session, where I presented a session called Virtual CPUs: Right to Ludicrous Speed, are now available for you to view up at SlideShare. Let me know if you have any questions! I hope to… Read more

0 comments, 125 reads

Posted in Technobabble by Klee from @kleegeek on 23 July 2017

Resolve Network Binding Order Warning in failover cluster

In this post, I’m going to talk about an issue that I found while running the cluster validation report. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.
Rule “Network binding order” generated a warning.

Read more

0 comments, 99 reads

Posted in Ganapathi's MSSQLLover on 22 July 2017

Older posts