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

Archives: August 2018

How Do Azure Subscriptions Work?

In this Azure Every Day installment, I’d like to talk about your organization’s subscription hierarchy. When working with Azure, it can get confusing with talk of tenants, subscriptions and user accounts. There are some key components to understanding the organizational hierarchy of using Azure or other Microsoft cloud services. Read more

0 comments, 2,549 reads

Posted in DataOnWheels on 31 August 2018

Calculating Quartiles with DAX and Power BI

Like many of my blog posts, this post is inspired by some work I was doing with a customer who had a requirement to calculate quartiles of a ranked set of data. So I thought I’d take a few minutes to demonstrate how I accomplished this using DAX in Power… Read more

1 comments, 1,977 reads

Posted in SQL with Dustin Ryan on 31 August 2018

Extended Security Updates: No More Freebies

As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our environments.  Microsoft has moved away from releasing service packs to releasing just cumulative updates and the occasional hotfixes.  These hotfixes may or may not be security related, but it behooves… Read more

0 comments, 877 reads

Posted in John Morehouse | Sqlrus.com on 31 August 2018

I’m Speaking at SQLSaturday Cambridge!

Speaking at SQLSaturday Cambridge!

I’m proud to announce that I will be speaking at SQL Saturday Cambridge on September 8th 2018! And wow, 748 SQL Saturdays! This one won’t let you down. Check out the amazing schedule of International Experts and Microsoft MVPs!

If you don’t know what SQLSaturday is,…

Read more

0 comments, 284 reads

Posted in Anthony Nocentino's Blog on 31 August 2018

Talking Data: Six Word Stories

In six words, can you give a compelling description of your data?

I’m taking the Microsoft DAT248x course as part of the Data Science curriculum. This is one of the new courses added, and it’s about telling a story with the data. The point being made is we often only… Read more

0 comments, 262 reads

Posted in Databases – Infrastructure – Security on 30 August 2018

Maps in Power BI. Do I really need them?

(2018-Aug-30) While preparing for a recent Power BI Toronto meetup session, I found a very valuable whitepaper on Maps in Power BI written by David Eldersveld from the BlueGranite consulting company, and I had used some of the ideas and examples from that document in my presentation.

There is one…

Read more

4 comments, 933 reads

Posted in Data Adventures on 30 August 2018

ARM vs Classic Deployment in Azure

When Azure Resource Manager (ARM) was created back in 2014, I (like many) thought, “What does that mean?” Up until last year, every VM I created was in Classic Deployment model. In this Azure Every Day installment, I’d like to go over the differences between the two.

A deployment model… Read more

0 comments, 254 reads

Posted in DataOnWheels on 30 August 2018

Repair Visual Studio for Mac: Extension node not found in path

A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start. The actual error message (which I retrieved from a log file) said: Extension node not found in path: /MonoDevelop/Core/WebCredentialProviders Knowing what I know about complex software, it was unlikely that… Read more

0 comments, 254 reads

Posted in Born SQL with Randolph West on 30 August 2018

Custom Data Purging in SQL Monitor

In talking to a customer recently, they were worried about the amount of data kept by SQL Monitor. That’s a fair concern as monitoring a large number of servers can result in lots of data.

As an aside, data management is one of the reasons that I’d always want… Read more

0 comments, 361 reads

Posted in The Voice of the DBA on 30 August 2018

The unwanted Side Effects of enabling Read Committed Snapshot Isolation

(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.)

A lot of developers are approaching me very often, and tell me that they are using the… Read more

1 comments, 477 reads

Posted in Klaus Aschenbrenner on 30 August 2018

Helpful Undocumented Stored Procedure “sp_MsForEachDB”

This week’s post will be a short one to talk about a very helpful stored procedure in SQL Server called “sp_MSForEachDB”.

I ran across this stored procedure when trying to drop a login from multiple databases.  The uses of this stored procedure can go beyond just dropping a login, it… Read more

0 comments, 247 reads

Posted in vitamindba on 30 August 2018

How Azure Storage Kick Starts Your Big Data Projects

So, your boss says, ‘Let’s do big data!’ And you think: ‘I don’t even know what that means or what I have to do. Do I need big data? Do I need a bunch of servers?’ These are the questions we hear all the time.

A simple intro into the… Read more

0 comments, 938 reads

Posted in DataOnWheels on 29 August 2018

Next week is SQL in the City Streamed

This picture is out of date. I’ll make sure we get a new one next week at SQL in the City Streamed that includes Kendra Little.

On Sept 5th, is SQL in the City Streamed. Register today and watch us talk about Azure, Machine Learning, full stack development, and… Read more

0 comments, 335 reads

Posted in The Voice of the DBA on 29 August 2018

Azure SQL Database disaster recovery

My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with a blog post about disaster recovery in Azure SQL Database.  First, a clarification on the difference between high availability and disaster recovery:

High Availability (HA) – Keeping your database… Read more

3 comments, 1,062 reads

Posted in James Serra's Blog on 29 August 2018

A software architect replaces a relational database with a relational database

Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is no doubt biased. It might go into technical detail. Parts of it may be wrong. It may contain flippant remarks and editorialising. There are links to external references that may… Read more

2 comments, 267 reads

Posted in Born SQL with Randolph West on 29 August 2018

SQL Puzzle: Advent of Code

A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar of coding puzzles. Each day of December before Christmas there are two puzzles (with very Christmasy descriptions). You can do them with any language you choose, or even multiple… Read more

0 comments, 459 reads

Posted in SQLStudies on 29 August 2018

Undercover TV- Episode 2

The latest webcast from SQLUndercover.com. In this episode David and Adrian take a look at a few blog posts that have caught their interest, review Minion Backup from Minionware and announce the release of the all new Undercover Catalogue v0.1.

Links featured in this webcast are,

Read more

0 comments, 338 reads

Posted in SQL Undercover on 29 August 2018

Power BI Custom Visuals Class (Module 117 – Multi KPI)

In this module you will learn how to use the Multi KPI. The Multi KPI is great for displaying multiple KPI values in a single visual.

Module 117 – Multi KPI


Read more

0 comments, 1,098 reads

Posted in Devin Knight on 29 August 2018

MAXDOP Calculator

Every time I conduct a SQL Server health check, it’s pretty common for me to find wrong configurations at instance level. But one of the most common mistakes I see on the wild, is SQL instances having the “max degree of parallelism” (MAXDOP) set to “1” (single core) , probably… Read more

0 comments, 700 reads

Posted in DBA Mastery on 28 August 2018

What is Automatic Tuning in Azure SQL Database

Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many times they were of questionable merit. We have all seen the dreaded dta_index names in a database and rolled our eyes knowing that sometimes these indexes are not what is… Read more

0 comments, 407 reads

Posted in SQLEspresso on 28 August 2018

Older posts