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

Archives: November 2017

Hit Refresh

I read Satya Nadella’s Hit Refresh recently, and it was a very enjoyable book. He’s had an interesting journey and I do think he’s dramatically transformed Microsoft. The book is recommended.

Anyway, the Microsoft MVP Program asked is MVPs would share a refresh moment from their lives, so here’s… Read more

1 comments, 353 reads

Posted in The Voice of the DBA on 30 November 2017

Information Measurement with SQL Server, Part 2.4: Conditional and Joint Entropy

By Steve Bolton

…………Since this series on using SQL Server to implement the whole gamut of information metrics is wide-ranging in nature, it will also be somewhat disorganized by necessity; this is doubly true, given that I’m writing it in order to learn the material faster, not because I’m… Read more

0 comments, 212 reads

Posted in Multidimensional Mayhem on 30 November 2017

Resources from the PASS community this coming month

Even though it is December, I noticed a lot going on for FREE in the PASS Microsoft Data Technology community. The first interesting one is a PASS Marathon: Linux!!! Here is the link. Never thought I would see something like this related to PASS. But it is here, so… Read more

0 comments, 241 reads

Posted in The Smiling DBA on 30 November 2017

SQL in the City 2017

It’s almost time for SQL in the City 2017, coming Dec 13, live from Cambridge, UK. I’ll be traveling over to England for the event, and you can stream it to your office live. Once again, we’ll be presenting the conference twice, 11am and 6pm (both GMT), and you… Read more

0 comments, 910 reads

Posted in The Voice of the DBA on 30 November 2017

Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)

I was setting up an availability group listener recently and when I tried to connect to the listener I got an error message to say "The host cannot be found" after the usual 15 seconds connection delay.

I checked the usual thing like TCP was enabled on the replicas and…

Read more

0 comments, 170 reads

Posted in Ed Elliott's Sql Developer Blog on 30 November 2017

I’m Presenting Two Linux Sessions on One Day!

On 12/13 I’m presenting two, back to back, sessions on SQL Server on Linux online. So you can attend from anywhere!

Let’s go through both!

First, on 12/13 at 1PM Central, I’m presenting for the PASS Database Administration Virtual Group here’s my session details:

Topic: Linux OS Fundamentals for… Read more

0 comments, 166 reads

Posted in Anthony Nocentino's Blog on 30 November 2017

Handling Missing Instances when Looping with Pester

In my previous posts about writing your first Pester Test and looping through instances I described how you can start to validate that your SQL Server is how YOU want it to be.

Unavailable machines

Once you begin to have a number of tests for a number of instances you… Read more

0 comments, 171 reads

Posted in SQL DBA With A Beard on 30 November 2017

Using Common Table Expression (CTE) – Did you know…

Today I will write just a short blog post to do a quick reminder!

I still hear a lot of people suggesting CTEs because they think it works like a temporary table (you populate the table and then it can be/is reutilized).

It doesn’t!

From de documentation:

Specifies a…

Read more

0 comments, 198 reads

Posted in Cláudio Silva on 30 November 2017

SQL Server Data Tools 2017 and TFS Integration

I’ve blogged a while back on how SSIS 2017 was finally here. Not much has changed; there is still no Visual Studio extension for SSIS, so if you want to create SSIS projects you still need to install SQL Server Data Tools (which makes it a bit useless that… Read more

0 comments, 455 reads

Posted in Koen Verbeeck on 30 November 2017

Design Concepts For Better Power BI Reports – Part 2: Preattentive Attributes

Preattentive attributes are visual properties that we notice without using conscious effort to do so. Preattentive processes take place within 200ms after exposure to a visual stimulus, and do not require sequential search. They are a very powerful tool in your data visualization tool box – they determine what… Read more

5 comments, 403 reads

Posted in Data Savvy on 30 November 2017

Upgrading an expired SQL Server 2016 Evaluation Edition

It's happened to almost everyone. Someone installs Evaluation Edition and now you need to upgrade it to a licensed copy using "Edition Upgrade" in the SQL Server installer. Microsoft would have you think this is easy even if the copy has expired but the truth is far more difficult.

Read more

0 comments, 188 reads

Posted in Cody Konior on 30 November 2017

How to get started with Always Encrypted for Beginners Part 1

Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server has made it very simple when they introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database. Unlike Transparent Data Encryption (TDE) which only encrypts… Read more

4 comments, 361 reads

Posted in SQLEspresso on 29 November 2017

Introducing SQL Operations Studio

Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did not meet the publishing deadline. A new cross-platform tool for SQL Server and Azure SQL Database Microsoft has announced the preview of SQL Operations Studio, an exciting addition to the… Read more

0 comments, 373 reads

Posted in Born SQL with Randolph West on 29 November 2017

Pluralsight for Another Year

One of the ways that I try to keep current and learn is through Pluralsight. I’m lucky to get a subscription as a Data Platform MVP, but I’m sure Redgate would pay for one if I didn’t.

My subscription ran out last week, but the support staff at… Read more

1 comments, 902 reads

Posted in The Voice of the DBA on 29 November 2017

SQL Puzzle – Word Scrambler

I’ve been writing crosswords for the last few months and to change things up I thought I would do a word scramble. Well, step one was to create a function that would scramble the words for me. Below is my attempt at creating a word scrambler. Your task (should you… Read more

2 comments, 244 reads

Posted in SQLStudies on 29 November 2017

The One Piece of Career Advice I Wish I’d Gotten

Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started in technical careers. Some of these questions come from new or soon-to-be college graduates who are just starting their journey, while others are from experienced professionals looking to move into… Read more

2 comments, 2,166 reads

Posted in Tim Mitchell on 29 November 2017

Server Roles and Azure Active Directory in an Azure SQL Database

This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login a server roles and how to give an Azure Active Directory user permissions to an Azure SQL database.

You can download the free ebook: Putting Your Head in the Cloud:…

Read more

0 comments, 252 reads

Posted in The SQL DBA in the UK on 29 November 2017

Checking SQL Configuration with Pester & Dbatools

I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing around with Pester recently and it’s pretty cool!

The script I’ve written here will use Pester & Dbatools to check all settings in sys.configurations against values stored in a .csv… Read more

0 comments, 1,240 reads

Posted in The DBA Who Came In From The Cold on 29 November 2017

Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2

Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is Adaptive Joins.

Before we start Adaptive Joins, SQL Server's Query optimizer internally has 3 join types.

Nested Loop Join - Usually picked by optimizer, when tables participating in the…

Read more

1 comments, 447 reads

Posted in SQL and SQL Only on 29 November 2017

Introduction to Extended Events

Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in SQL Server 2008, and it provides a very rich method of collecting diagnostic data from SQL Server. You can get in-depth detailed information using extend event for troubleshooting which was… Read more

0 comments, 231 reads

Posted in SQL Geek on 29 November 2017

Older posts