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

Latest Blog Posts

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, 39 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, 51 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, 42 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, 42 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, 71 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, 177 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, 103 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, 133 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, 147 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, 128 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, 97 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, 132 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, 88 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, 104 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, 85 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, 178 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, 94 reads

Posted in Tim Radney - Database Professional on 11 December 2017

Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”)

Welcome back! Previously, on “Who’s Collation is it Anyway?”, due to statements made in the Microsoft documentation for “Search Conditions” related to Code Page conversions, we started looking at what happens when VARCHAR data (mainly string literals that are not prefixed with a capital-“N”) is used in a Database… Read more

1 comments, 162 reads

Posted in SQL Quantum Leap on 11 December 2017

New Course: Implementing a Hybrid Cloud Solution in Azure

My latest Pluralsight course – SQL Server: Implementing a Hybrid Cloud Solution in Azure – is well over two hours and long and is based on part of my popular workshop/precon that I have been presenting over the past 18 months. This was a fun and challenging course to develop… Read more

1 comments, 181 reads

Posted in Tim Radney - Database Professional on 11 December 2017

An Open Letter to the SQL Community: Requests of Speakers

(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, graciously providing tens of thousands of hours of free training...(read more)

Read more

0 comments, 173 reads

Posted in SQLSequel on 11 December 2017

Older posts