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

Archives: February 2017

How Do I Add an R Package to SQL Server from In-Database R?

Hello Dear Reader!  I'm working on some really fun stuff with in-database R using SQL Server 2016.
I needed to add a couple packages to my R engine so I could use them and call them from an R script. I realized I had not added any external packages to…

Read more

1 comments, 843 reads

Posted in SQLBalls on 28 February 2017


I’ve hosted a page on this blog that has all the T-SQL Tuesday blog invitations and roundups linked. I did this mainly because I was trying to ensure I have hosted a few, I wanted to know what others had chosen. Since I didn’t see a good list, I created… Read more

2 comments, 1,990 reads

Posted in The Voice of the DBA on 28 February 2017

Determining the Cost Threshold for Parallelism

In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the values you’re dealing with for the estimated costs on your execution plans can help you determine what the Cost Threshold on your system should be. However, we don’t want… Read more

10 comments, 1,836 reads

Posted in The Scary DBA on 28 February 2017

Power BI Custom Visuals Class (Module 40 – Long Text Viewer)

In this module you will learn how to use the Long Text Viewer Power BI Custom Visual.  The Long Text Viewer visual helps in displaying longer text fields that you have in your dataset.

Module 40 – Long Text Viewer


Read more

0 comments, 1,933 reads

Posted in Devin Knight on 28 February 2017

Not An Administrator For Analysis Services Tabular

A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in SQL Server Data Tools. When I had to choose where to locate the model – integrated or a server workspace – I got the… Read more

1 comments, 1,904 reads

Posted in Koen Verbeeck on 28 February 2017

Configuring and analyzing the Query Store through dbatools

In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely in your work as a DBA. Just one example: migrating SQL Server Instances takes a massive amount of work. You need to backup and restore every database, write down instance… Read more

0 comments, 2,149 reads

Posted in DotNine SQL Server and more on 27 February 2017

Upcoming Speaking Engagements

In the next few months I will be speaking at some awesome events around Europe.


SQLBits – April 5-8 

SQLBits is THE SQL Server event in Europe, with a very long tradition and a fantastic audience. I totally love SQLBits!
This time I will speak about “Benchmarking like… Read more

0 comments, 579 reads

Posted in SpaghettiDBA on 27 February 2017

Speaking at VS Live–Austin

I’ll be speaking at Visual Studio Live – Austin in May 2017. I was fortunate to be selected to speak again, after my first two VS Lives last year in DC and Orlando. I’m excited to go back, as the conference is a lot of fun, and Austin is a… Read more

0 comments, 904 reads

Posted in The Voice of the DBA on 27 February 2017

Database cloning – CLONEDATABASE

Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning.

The command syntax is very simple

DBCC CLONEDATABASE (source_database_name, target_database_name)

For example the next command

DBCC CLONEDATABASE (AdventureWorks2014, AdventureWorks2014_Clone)

will create database AdventureWorks2014_Clone with files created in the… Read more

0 comments, 664 reads

Posted in Si vis pacem, para sql on 27 February 2017

Queries with optional parameters

These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or a city. Simple enough, until you notice that or. We might only get a first name, or a state and the query still needs to work. These queries are… Read more

10 comments, 3,387 reads

Posted in SQLStudies on 27 February 2017

SQL VNext sp_configure on Windows and Linux with dbatools

This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I could test some scenarios and build an availability group.

IMPORTANT NOTE :- The names of dbatools commands with a Sql prefix WILL CHANGE in a later release of dbatools. dbatools… Read more

4 comments, 2,031 reads

Posted in SQL DBA With A Beard on 27 February 2017

The Empirical Rule

I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning of statistics and basic concepts, and illustrate them to the best of my ability using R and T-SQL where appropriate.

For this week I have chosen a statistical concept called… Read more

0 comments, 2,273 reads

Posted in Mala's Data Blog on 27 February 2017

SQL Clone

Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server databases for development and testing.

Oh god, that sounds like marketing speak. To heck with that. Let me tell you why I’m so excited about SQL Clone and why… Read more

4 comments, 2,065 reads

Posted in The Scary DBA on 27 February 2017

Monday Coffee 2017-02-27

Ergh, not a fun weekend rugby wise. But anyway…

Last week Microsoft released an image for SQL Server 2016 SP1 Developer Edition in containers. Previously the only edition available was vNext Enterprise Evaluation which was a real problem in making containers a viable option for many businesses.

There’s no… Read more

0 comments, 561 reads

Posted in The DBA Who Came In From The Cold on 27 February 2017

Installing Windows Server 2016 Nano on a Physical Server

Hey guys! So here's my adventure in deploying Windows Server 2016 Nano on a physical server. It was a hard fought battle, but I finally won. Note: SQL Server 2016 is not compatible with Windows Server 2016 Nano. This install was for clustering two physical Hyper-V servers. So here goes!…

Read more

0 comments, 767 reads

Posted in James' SQL Blog on 27 February 2017

Red Gate SQL Clone (#1) - Initial Setup

Note this was during earlier beta usage, so some of the UI and other features will have been updated more. I plan on writing more on this promising tool as I get a chance to dive into it more, especially the powershell cmdlets for database cloning automation. In the meantime,… Read more

0 comments, 669 reads

Posted in Sheldon Hull on 27 February 2017

SQL Server Deadlock Performance Counter

End users generally face a situation where the SQL server application gets hangs. What users generally do is restart the machine for fixing the problem and then continue with their work. This restarting activity works for two to three weeks and after that, a point comes where the system gets… Read more

0 comments, 2,352 reads

Posted in on 27 February 2017

Columnstore Indexes – part 99 (“Merge”)

Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

This blog post is focused on the MERGE statement for the Columnstore Indexes, or as I call it – the worst enemy of the Columnstore Indexes. It is extremely difficult to imagine some statement or… Read more

5 comments, 782 reads

Posted in Niko's blog on 26 February 2017

I Don’t Understand

I suspect this may make a few people angry, but I felt the need to share.

I was recently asked to go through my contacts and put together calls with some technologists for a series of discussions. OK. I thought about what we’d need, compared it to a mental list… Read more

10 comments, 3,332 reads

Posted in The Scary DBA on 24 February 2017

Is Your Database App Ready for the Cloud?

The cloud has evolved. Just a few years ago, cloud-based applications were the exception rather than the rule, and on-premises apps were the clear standard for database apps. However, with the numerous advantages of building in or migrating to managed services, the cloud isn’t just a niche anymore. Managed services… Read more

1 comments, 2,178 reads

Posted in Tim Mitchell on 24 February 2017

Older posts