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

Latest Blog Posts

Picking The Right Team

Years ago, back before I became a consultant, a job search led me to an interview with a technical company. The company was large enough to offer a variety of challenges with room for advancement, but wasn’t so big that one would get lost in a sea of employees. The… Read more

0 comments, 27 reads

Posted in Tim Mitchell on 14 December 2017

The Mystery Of The Failing Azure Cmdlet


I’ve been helping out a team with setting up a deployment pipeline that uses Azure Data lake Store, and so the obvious way to do this is to make use of the AzureRM.DataLakeStore PowerShell module. For those of you not ITK, Microsoft provide a set of PowerShell cmdlets that…

Read more

0 comments, 41 reads

Posted in Richie Lee's SQL Stuff on 14 December 2017

My Azure ARM template development workflow

Writing infrastructure as code is pretty nice and I enjoy the declarative approach of defining what you want and letting the tooling take care of the how. I guess this is because of my background as a SQL developer.

What I don't like so much is the development experience and…

Read more

0 comments, 141 reads

Posted in Ed Elliott's Sql Developer Blog on 13 December 2017

Configure SQL Server 2017 on Linux with mssql-conf, the Linux way

The configuration of any system plays a vital role in its working efficiently. However, configuring a system needs not necessarily be a daunting task. There are several tools that help with the process.

SQL Server on Linux provides a wide range of options for configuration, management, and administration.

  1. mssql-conf
  2. Transact-SQL

Read more

0 comments, 96 reads

Posted in PowerSQL By Prashanth Jayaram on 13 December 2017

How to Get Started with Always Encrypted for Beginners Part 2

In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so.

Now that we have encrypted our columns, it’s time to take a look at how we decrypt them inside SQL Server Management Studio or… Read more

0 comments, 101 reads

Posted in SQLEspresso on 13 December 2017

Take a walk

When I need to clear my head, I go for a walk. When I need to think about a problem, I go for a walk. When I need to plan a new talk, I go for a walk. My companion on my walks is Trixie, a purebred Chihuahua. Trixie is… Read more

0 comments, 95 reads

Posted in Born SQL with Randolph West on 13 December 2017

Is Your Database Overweight?

The obesity epidemic is much in the news these days. The list of health issues related to being overweight is long, and admonitions to watch what we eat and to exercise regularly and stay active abound.

But it’s not just people that can be affected adversely by being overweight. Databases… Read more

0 comments, 90 reads

Posted in The Monday Morning DBA on 13 December 2017

The Value of Consistent Design

Yesterday I wrote about best practices, illustrating that what may be an assumed technical design standard doesn’t fit every scenario. In a similar vein, I believe that consistency often trumps what are considered to be best practices. In this post, I’ll share some thoughts on the value of consistent design.… Read more

0 comments, 97 reads

Posted in Tim Mitchell on 13 December 2017

Understanding Keys and Certificates with Transparent Data Encryption (TDE)

I’ve been taking a bit of a deep dive into understanding Transparent Data Encryption (TDE). As part of that I’ve been reading a lot of blog posts, stack overflow answers and technical documentation to try and deepen my knowledge.

Within that I’ve found a lot of contradiction I’ve needed to… Read more

0 comments, 190 reads

Posted in Matthew McGiffen DBA on 12 December 2017

Power BI Custom Visuals Class (Module 81 – Social Network Graph)

In this module you will learn how to use the Social Network Graph Custom Visual. The Social Network Graph allows you to visualize relationships between people or items in your data.

Module 81 – Social Network Graph


Read more

0 comments, 122 reads

Posted in Devin Knight on 12 December 2017

BK’s Professional Learning Plans for 2018 #tsql2sday

With 2018 coming, I’ve thought about the question, “What do I want to be when I grow up?” I ask this question every few years because it helps me develop a plan of attack with respect to learning and opportunities to pursue. As a result, this T-SQL Tuesday topic comes… Read more

0 comments, 145 reads

Posted in Databases – Infrastructure – Security on 12 December 2017

T-SQL Tuesday #098–2018 Goals

A great topic for T-SQL Tuesday this time from @sqlmal. It’s Setting Learning Goals for 2018, and it’s a topic I both loathe and love. I hate making commitments that I can’t keep, and I constantly find that a chaotic life will get in the way of learning over… Read more

0 comments, 171 reads

Posted in The Voice of the DBA on 12 December 2017

SQL Server Failed to Open Loopback Connection – What?

I could not read my error log on one of my local SQL Servers, when I executed the following code:

EXEC sp_readerrorlog

I received the below:

Msg 22004, Level 16, State 1, Line 2 Failed to open loopback connection. Please see event log for more information. Msg 22004, Level 16,… Read more

0 comments, 143 reads

Posted in All About SQL on 12 December 2017

T-SQL Tuesday #97 – Setting learning goals for 2018

T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic on the first Tuesday of the month, and everyone who want’s to participate blogs on that subject, posting on the second Tuesday of the month. This… Read more

0 comments, 114 reads

Posted in SQLStudies on 12 December 2017

When Best Practices Aren’t Best

Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be applied to most problems in a given domain. Data professionals, carpenters, medical practitioners, retail professionals, hair stylists, and most any other craftsperson will learn through experience a set of rules… Read more

2 comments, 147 reads

Posted in Tim Mitchell on 12 December 2017

The Eleven Days of Festivus 2017

Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about SSIS, reporting, and leaving data trails. I had so much fun doing that stretch that I’m doing it again this year for Festivus 2017. Starting today and continuing through Festivus… Read more

0 comments, 102 reads

Posted in Tim Mitchell on 12 December 2017

T-SQL Tuesday #97 – We don’t need no Education! (or do we?)



Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by Mala Mahadevan. This month we’re talking about “Setting Learning Goals for 2018.

With so much change going on in the IT… Read more

0 comments, 120 reads

Posted in measure twice, cut once. on 12 December 2017

Creating a Knowledge Base Chat Bot w/ Azure Bot Service

A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that blog, I’ve received a lot of requests on the steps required to build the bot. The good new is that its super easy and really only take a few… Read more

0 comments, 98 reads

Posted in SQL with Dustin Ryan on 12 December 2017

PaaS and the ever changing role of the DBA

I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list of DMVs and I’m a happy camper.

Perfmon is probably my best friend. It’s always there and happy to tell me the truth. It seldom falters and has helped me… Read more

0 comments, 221 reads

Posted in Confessions of a Microsoft Addict on 12 December 2017

Microsoft to Decommission Connect on 12/31/2017

Microsoft will be decommissioning the Connect platform on 12/31/2017 due to privacy concerns and will be replacing it with a new forum on UserVoice. 

Connect has been a very valuable method for users to submit feedback and the community to be able to vote the item up if they too… Read more

0 comments, 108 reads

Posted in Tim Radney - Database Professional on 11 December 2017

Older posts