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

Latest Blog Posts

Using DBCC Clonedatabase

I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw this:

On a quiet Friday afternoon, this seemed like a good time to experiment. We (Redgate Software) have a salesdemo VM that we use to show various Redgate… Read more

1 comments, 307 reads

Posted in The Voice of the DBA on 10 May 2017

Installation of SQL Server vNext CTP on Linux Distribution CentOS 7

It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was the first time in history that Microsoft ever designed SQL Server to run on a non-Windows operating system. SQL Server vNext was released for public preview so the user community…

Read more

0 comments, 256 reads

Posted in PowerSQL By Prashanth Jayaram on 10 May 2017

Copying files from/to a container

Last week I was having an issue with a SQL install within a container and to fix I needed to copy the setup log files out of the container onto the host so that I could review.

But how do you copy files out of a container?

Well, thankfully there’s… Read more

1 comments, 152 reads

Posted in The DBA Who Came In From The Cold on 10 May 2017

My Session about SQL Server Parameterization


Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the session was “How to Use Parameters Like a Pro and Boost Performance”.


Here is the abstract:


“Parameters are a fundamental part of T-SQL programming, whether they are… Read more

0 comments, 159 reads

Posted in Guy Glantser on 10 May 2017

SQL Server 2017 running on Windows Containers!

One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is – Why you want to run SQL Server on containers?

Here is what Microsoft has to say:

“Windows Containers are an isolated, resource controlled, and portable operating environment. An application…

Read more

0 comments, 366 reads

Posted in SQLSailor.com on 10 May 2017

Setting Up a Subscription

In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I will request you to go through before you start exploring this blog.

If you don’t have the Subscription database, You must create your subscription database. Once you created the… Read more

0 comments, 158 reads

Posted in SQL Geek on 10 May 2017

Pester Test Inception and the Show Parameter

My fantastic friend Andre Kamman b | t  and I presented at PSConfEu last week

and whilst we were there we were chatting about running Pester Tests. He wanted to know how he could run a Pester Test and not lose the failed tests as they scrolled past him. In… Read more

0 comments, 127 reads

Posted in SQL DBA With A Beard on 9 May 2017

T-SQL Tuesday 90 - Shipping Database Changes

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic blog | twitter.

This month’s tsql2sday is being hosted by James… Read more

0 comments, 306 reads

Posted in cjsommer.com on 9 May 2017

T-SQL Tuesday #90 – The Elephant’s Name is Database

T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community  It is the brainchild of Adam Machanic (B|T) and is not limited to just things around the SQL Server database engine. Each month a blogger hosts the event and anybody who wants to… Read more

0 comments, 152 reads

Posted in John Morehouse | Sqlrus.com on 9 May 2017

T-SQL Tuesday #90: The Death of the DBA in a DevOps World Has Been Greatly Exaggerated

It’s time for another iteration of the blog party known as T-SQL Tuesday. This month’s theme is Shipping Database Changes hosted by James Anderson (|@). Head on over to John’s announcement post and join in with the party by writing your own post or by just reading those that are…

Read more

Shipping Database Changes–T-SQL Tuesday #90

This is a good T-SQL Tuesday topic from James Anderson: shipping database changes. It’s especially poignant for me since I talk and present often on this topic. Much of my work at Redgate involves helping people implement DevOps for Databases, deploying changes smoothly and efficiently to databases.

I’ve got… Read more

0 comments, 235 reads

Posted in The Voice of the DBA on 9 May 2017

Power BI Custom Visuals Class (Module 50 – Narratives)

In this module you will learn how to use the Narrative Power BI Custom Visual.  The Narrative visual is developed by Narrative Science and it gives you the ability to automatically deliver analysis of your data.  The results look similar to a final report that a analyst might provide after… Read more

2 comments, 192 reads

Posted in Devin Knight on 9 May 2017

Slides from 24 Hours of PASS – Data Security

As promised, here are my slides from the 24 Hours of PASS on Data Security:

S1 – Brian Kelley_WhatYouAbsolutelyMustKnowAboutSQLServerSecurity (.pptx – 733 KB)

S7 – Brian Kelley_ProtectingDataAcrossTheEnvironment (.pptx – 1.3 MB)

Thanks for those who attended!

Read more

0 comments, 135 reads

Posted in Databases – Infrastructure – Security on 9 May 2017

Extended Events – I am dangerous (sometimes)

I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was creating a couple of extended events sessions and was playing around with some actions. I ended up with the following … Continue reading

Read more

2 comments, 147 reads

Posted in All About SQL on 9 May 2017

Continuous Integration

It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us to talk about Shipping Database Changes. I actually have some experience with an aspect of this at a previous company and I thought this would… Read more

0 comments, 137 reads

Posted in SQLStudies on 9 May 2017

Webinar Followup: End to End Security with SQL Server 2016

I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can click here to watch the recording of the webinar if you missed it. In this follow up I wanted to post the scripts I used and link to a… Read more

0 comments, 122 reads

Posted in Bradley Schacht on 9 May 2017

Some stuff with Date and Time in SQL Server

I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up to talk about dates and times, and converting them to string representations. Of course I don’t always have time enough to… Read more

0 comments, 180 reads

Posted in Si vis pacem, para sql on 9 May 2017

T-SQL Tuesday #90 – Shipping database changes



Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by “The Database Avenger”  James Anderson. This month we’re talking about Shipping Database Changes – something I’ve done many times and mostly correctly – although we… Read more

0 comments, 137 reads

Posted in measure twice, cut once. on 9 May 2017

Splitting Strings on SQL Server 2016

A small change, but a great one, in SQL 2016 is native support for splitting strings.

This has to be about the most common user defined function that people write in SQL Server. I’ve certainly seen it across many companies and clients that I’ve worked for over the years. From… Read more

0 comments, 237 reads

Posted in Matthew McGiffen DBA on 9 May 2017

Dynamic Data Masking

By David Postlethwaite


Dynamic data masking is a really useful new tool in SQL Server 2016. Keeping data safe is one of the most important tasks that a company has; this goes further than just making sure that users can only see their own data and hackers can’t get…

Read more

0 comments, 302 reads

Posted in The SQL DBA in the UK on 9 May 2017

Newer posts

Older posts