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

Archives: July 2018

Forcing Execution Plan

Very rarely there is a need to force an execution plan and even more rarely we should be doing it. But once you decide there is no other way or you need a quick temporary workaround to get production going and gain some buffer time for yourself to do proper… Read more

0 comments, 79 reads

Posted in SQL Toast on 20 July 2018

Silly Photos at Work

Someone I stumbled across this picture of @brento on my drive.

This might be the best one:

And this was a good time:

However, I have a collection of silly moments. Enjoy.

Read more

0 comments, 100 reads

Posted in The Voice of the DBA on 20 July 2018

Paper Model of Hubble Telescope

Not even close to being about SQL, I ran across the plans for a paper model of the Hubble Telescope while doing some follow up reading on the Hale Telescope (because I just read a book about it). I haven’t attempted the model, but wanted to note it here in… Read more

0 comments, 137 reads

Posted in SQLAndy on 20 July 2018

The need for having both a DW and cubes

I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP models).  And I have heard others say if you have OLAP cubes, you don’t need a data warehouse.  I strongly… Read more

0 comments, 89 reads

Posted in James Serra's Blog on 20 July 2018

Selecting a Random Row From a Table

A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from a table?’.

There are often a few ways of doing this suggested, most seem to rely using CTEs or temp tables.  I thought I’d share, in a quick post a… Read more

0 comments, 96 reads

Posted in SQL Undercover on 20 July 2018

Friday Reading 2018-07-20

Haven’t posted one of these for a while! It’s good to have some time back to be able to read/write.

I’ve had a pretty mixed week, but the highlight has definitely been pulling the trigger on buying a Dell XPS 13 running Ubuntu. The Dell is a pretty slick machine,… Read more

0 comments, 77 reads

Posted in The DBA Who Came In From The Cold on 20 July 2018

My #SQLCareer Day–July 19

I’ve asked for #SQLCareer posts, and I haven’t done any. My job isn’t a data platform DBA or developer, but it is SQL related, so a glimpse of the nonsense I perform. I’m asking for more posts, so a note at the bottom.

This should have been a cool day,… Read more

1 comments, 187 reads

Posted in The Voice of the DBA on 20 July 2018

Getting Schooled by Brent

Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training is good! I signed up with a few thoughts in mind:

  • I had not taken a class recently (I like to self learn, perhaps to a fault)
  • I was curious…

Read more

0 comments, 95 reads

Posted in SQLAndy on 19 July 2018

SQL Solver

A few months back I ran across this article for checking semantic equivalencies of queries. That’s interesting, from the perspective of someone that has once or twice rewritten a query to be faster and then discovered it was subtly different. I don’t think we have the equivalent. We can compare… Read more

0 comments, 109 reads

Posted in SQLAndy on 19 July 2018

Backup and Restore operations with SQL Server 2017 Docker containers using SQL Operations Studio

In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers using SQL Ops Studio (SOS). Before proceeding, you need to have Docker engine installed and SQL Ops studio configured on … Continue reading

Read more

0 comments, 257 reads

Posted in PowerSQL By Prashanth Jayaram on 19 July 2018

Temporal Tables

Let’s start off with what is a temporal table? SQL Server 2016 introduced support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the… Read more

0 comments, 107 reads

Posted in The SQL Girl on 19 July 2018

Data Masker for SQL Server and Temporal Tables

A customer had a question recently about using Data Masker for SQL Server and temporal (or system versioned) tables. I decided to make a quick demo that will show how this works.

This is a simple demo, using just a few changes, but the concepts are useful for larger systems. Read more

0 comments, 342 reads

Posted in The Voice of the DBA on 18 July 2018

TDD for SQL Server using tSQLt course certificates now available

I have been asked a few times now for course completion certificates so I have decided to give out certificates to anyone who pays for a plan and sends me a screen shot of a unit test they have written and answer a question on unit testing. I will generate…

Read more

0 comments, 87 reads

Posted in Ed Elliott's Sql Developer Blog on 18 July 2018

Is this a SQL Provision Cloned Database?

As I work with SQL Provision, I keep finding new questions and concerns from clients and customers. Recently I had someone wonder if we could determine whether or not a database on which they were working was a SQL Clone cloned copy.

You can, and it’s easy to check.… Read more

0 comments, 280 reads

Posted in The Voice of the DBA on 18 July 2018

Data lakes and swamps, oh my

I was lamenting to my friend and fellow MVP Shamir Charania (blog | Twitter) that I didn’t have a topic for this week’s blog post, so he and his colleague suggested I write about data lakes, and specifically Azure Data Lake. What is a data lake? This is what Wikipedia… Read more

0 comments, 275 reads

Posted in Born SQL with Randolph West on 18 July 2018

Working Hard in Baton Rouge

I’m heading back to Baton Rouge for SQL Saturday #749 this August. This is one of the largest SQL Saturdays in the US, and one I really enjoy. I’ve been there 5 or 6 times, and I was honored to be selected again.

But they’re working me. The schedule is… Read more

0 comments, 217 reads

Posted in The Voice of the DBA on 18 July 2018


Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the easiest thing (at least for me) to understand at first.


Specifies that the restore operation loads the information into the msdb history tables. The…

Read more

1 comments, 266 reads

Posted in SQLStudies on 18 July 2018

Know How Table Variables Different From Temporary Tables in SQL Server

Know What Table Variables are ?

SQL Server support features that allow users to work with temporary data that gets stored in temporary tables. Microsoft introduced table variables for the first time with SQL Server 2000 as an alternate option to using temporary tables. Table variable is a type of… Read more

0 comments, 250 reads

Posted in SQL Server Overview on 18 July 2018

Creating SQL images in Azure with ACR Build

Whenever I’ve pushed images up to an Azure Container Registry I’ve been building them locally (using Docker for Windows) and then manually pushing them up. However, I don’t need to do this. What I can do instead is use the Azure Container Registry Build service.

Let’s have a look at… Read more

0 comments, 109 reads

Posted in The DBA Who Came In From The Cold on 18 July 2018

Schedule an Extended Event to run at a Specific Time

When you are using the extended event to capture some data for troubleshooting purpose, you may want to start or stop it at a specific time. Unfortunately, the Extended Event feature doesn’t provide you the option to schedule it. But, it can easily be accomplished by using “ALTER EVENT SESSION”… Read more

0 comments, 120 reads

Posted in SQL Geek on 18 July 2018

Older posts