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

Latest Blog Posts

Trying GO with SQL Server

Not the batch separator, but the GO language.

I’m always interested in learning new things, and GO has been one of those items that I’ve wanted to look at and see how it works. This is a big language at Google and

I saw a new blog from Mat Hayward-Hill… Read more

0 comments, 429 reads

Posted in The Voice of the DBA on 15 May 2017

SQL Saturday Atlanta Precon – The Complete Primer to SQL Server Virtualization & Cloud

If you are attending this year’s SQL Saturday in Atlanta, GA, on July 15, I urge you to attend my preconference training session – “The Complete Primer to SQL Server Virtualization & Cloud“. The architecture of the infrastructure underneath your mission-critical SQL Servers is vital to the… Read more

0 comments, 149 reads

Posted in Technobabble by Klee from @kleegeek on 15 May 2017

Why shouldn’t I shrink my database log file?

TL;DR: It’s pretty pointless and can cause performance issues.

Let’s start by asking why you might want to shrink your log.

It’s too big
I find that people who say this frequently don’t have a firm idea of what is too big or even why it might be as big… Read more

0 comments, 121 reads

Posted in SQLStudies on 15 May 2017

Creating Azure Database for MySQL and using Azure Cloud Shell

After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is really easy to build a MySQL database and I have a feeling that this might be the start of an … Continue reading

Read more

1 comments, 141 reads

Posted in All About SQL on 15 May 2017

Monday Coffee 2017-05-15

After the latest cyber attack I’ve had a fun weekend making sure all my devices are fully up-to-date with the latest patches. If you’re unaware of what’s been happening, you can read about it here.

I took this as an opportunity to go over all my backups as well.… Read more

0 comments, 125 reads

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

SQL Server 2017 sys.dm_os_enumerate_fixed_drives

In SQL Server 2017,  you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement of xp_fixeddrives.

Old way


New Way

SELECT * FROM sys.dm_os_enumerate_fixed_drives;

I wish Microsoft could have included the capacity of the drive. Not including the drive capacity requires the DBA… Read more

0 comments, 213 reads

Posted in SQL Geek on 15 May 2017

SQL Server 2017 – The operating system returned the error 21

Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was restoring the databases using tsql script on the SQL Server 2017 instance, and I didn’t encounter any issue. But, When I tried to restore a database backup using GUI using… Read more

0 comments, 134 reads

Posted in SQL Geek on 15 May 2017

Using Azure Machine Learning with an on-premises Database

With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning tasks on your data. One disadvantage I frequently run into is that cloud based approach of AzureML since the data you are building your machine learning models on has to… Read more

0 comments, 442 reads

Posted in DotNine SQL Server and more on 14 May 2017

Quick Graph Database

There’s a sample to work through here: https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-sample

I decided to try this in CTP2 and just see how it works. I didn’t do much, but I added a node and an edge with this code:


Read more

2 comments, 506 reads

Posted in The Voice of the DBA on 12 May 2017

Speaking at Charleston PASS on May 18, 2017

During the day of the 18th I’ll be at the Syntax Code and Craft Conference in Charleston, SC. That evening I’m stopping by Charleston PASS to visit and give a presentation.

Register for Charleston PASS’ May 18th Meeting

I’m stepping away from my comfort zone of security and presenting on… Read more

0 comments, 103 reads

Posted in Databases – Infrastructure – Security on 12 May 2017

Microsoft Build event announcements

Another Microsoft event and another bunch of exciting announcements.  At the Microsoft Build event this week, the major announcements in the data platform space were:

Azure Cosmos DB

Azure Cosmos DB is the next big leap in the evolution of DocumentDB.  Cosmos DB is Microsoft’s globally-distributed, horizontally scalable, multi-model database… Read more

0 comments, 224 reads

Posted in James Serra's Blog on 12 May 2017

Friday Reading 2017-05-12

The weather this week in Dublin has been absolutely fantastic, please hold out for the weekend. Anyway, whilst I’ve been stuck inside this week I’ve been reading…

Why PowerShell?
Why indeed? Anthony Nocentino talks about why he got into powershell

Thoughts on public speaking / presenting / teaching
Erin Stellato… Read more

0 comments, 122 reads

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

DevOps Basics–Creating a local repo and committing files

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

A local repo is a repository, and is the version control… Read more

0 comments, 221 reads

Posted in The Voice of the DBA on 11 May 2017

Dynamic SQL and the joys of QUOTENAME

I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even a Generic Dynamic SP although that last one was a bit so so in my opinion. Depending on what type of dynamic code you are writing QUOTENAME will be… Read more

5 comments, 137 reads

Posted in SQLStudies on 11 May 2017

Find the number of rows for a value, without querying the table

Dear all,

Being a DBA, developers approach me with questions like can you run this query for me in production?

Select *

WHERE UnitPrice = 32.6

Lets, say the table contains few billion rows and UnitPrice is not an indexed column, then query would take ages…

Read more

3 comments, 138 reads

Posted in SQL and SQL Only on 11 May 2017

SQL Server Wait Types Library – UPGRADED!

Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding? I was online and noticed a tweet from the main man himself – Paul Randal where he did a blog … Continue reading

Read more

0 comments, 160 reads

Posted in All About SQL on 11 May 2017

PASS Summit Call for Speakers

Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov 3rd. Oct 30th and 31st are for pre-conference sessions (all day workshops) and this year there is no open call for these sessions. Not sure the selection process because it… Read more

0 comments, 133 reads

Posted in The Smiling DBA on 11 May 2017

MySQL and Backups As A Service

With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more exciting opportunities have presented themselves for companies to build and manage their information. According to the DB-Engines Ranking, MySQL is the second most popular data management system out there.… Read more

4 comments, 268 reads

Posted in The Scary DBA on 10 May 2017

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, 303 reads

Posted in The Voice of the DBA on 10 May 2017

Newer posts

Older posts