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

Latest Blog Posts

SQLpassion Online Training about Availability Groups

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Because of the huge success and additional requests I’m offering my webinar about SQL Server Availability Groups Read more

0 comments, 782 reads

Posted in Klaus Aschenbrenner on 9 October 2017


DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used to create read only copy of an existing database. Cloned database includes the schema and statistics of the source database but no data.

· Source database should be online &… Read more

3 comments, 1,765 reads

Posted in MSSQLFUN on 9 October 2017

Know About Android Database and How to Fix Android Data Corruption

Corruption is one of the common scenarios nowadays. It can occur in any platform or file format, for that matter. Similarly, Android SQLite database can be corrupted due to various reasons. Therefore, in this blog, we will introduce a best to for the recovery of damaged Android SQLite database. Before… Read more

0 comments, 133 reads

Posted in Zora's SQL Tips on 9 October 2017

Extracting Deadlock information using SYSTEM_HEALTH Extended Events

Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health information of the SQL Server instance. Today, we are going to explore how quickly we can read the Deadlock information using Extended Event – “Without passing the default location of… Read more

2 comments, 1,452 reads

Posted in SQL Geek on 7 October 2017

Simplified Networking with a Wsky USB NIC

I used to share an office with my wife. We both needed Internet connections, with both desktops needing Ethernet cables. That was fine when my DSL router was in the office, but at some point we got a new provider and the connection to another room, where we put the… Read more

0 comments, 244 reads

Posted in The Voice of the DBA on 6 October 2017

What’s new in SQL Server 2017 presentation

I just uploaded a new presentation called “What’s new in SQL Server 2017”.  It covers all the new features in SQL Server 2017 (which went GA this past Monday), as well as details on upgrading and migrating to SQL Server 2017 or to Azure SQL Database.  Check out the… Read more

0 comments, 301 reads

Posted in James Serra's Blog on 6 October 2017

Failed SSIS Build – DtsRuntimeException


I was helping a team debug a failed build today. Despite the fact that the build compiled on the devs box – something that’s become almost cliché to hear these days – it would fail using devenv.com via cmdline. Annoyingly, there was no errors outputted. So i cloned the… Read more

0 comments, 147 reads

Posted in Richie Lee's SQL Stuff on 6 October 2017

Automate Parameterising SSIS Connection Managers


Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all properties of a connection manager in a SSIS project were parameterised. This even happened automatically when they got deployed to a SSIS Server. Great! The feature was also written… Read more

1 comments, 1,337 reads

Posted in Richie Lee's SQL Stuff on 6 October 2017

SQL Server Database Corruption: That Might Occur in an Environment using SQL Server

SQL server is the highly employed database service and is a highly advanced relational database management system, which is used on a large scale by the employees and the professionals. The improved user interface and the advanced features of MS SQL server makes it one of the highly used database… Read more

0 comments, 1,345 reads

Posted in Zora's SQL Tips on 6 October 2017

SQL Server Features Comparison at IaaS vs PaaS vs On Premise

Hello friends, Please find the link for my blog here – https://social.technet.microsoft.com/wiki/contents/articles/40295.sql-server-features-and-basic-comparison-at-iaas-vs-paas-vs-on-premise.aspx Tagged: Azure, Microsoft Azure, SQL Azure, Sql Server, SQL Server 2016

Read more

0 comments, 186 reads

Posted in Kapil Blogs on 5 October 2017

girls + data is coming to SQL Saturday Charlotte

I am so excited to be part of the organizing team for SQL Saturday Charlotte again this year, the CBIG folks are always a pleasure to work with and I am honored to be able work with them.  I am proud to say that this year we are raising the… Read more

0 comments, 167 reads

Posted in SQL Swimmer on 5 October 2017

Visual Studio 2017 Irritants From the SSIS Developer View

I was among the many Integration Services (SSIS)/Database (DB) developers out there that cheered when Microsoft finally announced support for SSIS in Visual Studio 2017.  I mean really, VS2017 was released back on March 7, 2017, but if you wanted to develop any SSIS packages in VS2017, you had to… Read more

0 comments, 199 reads

Posted in SQL Swimmer on 5 October 2017

Compound FKs with SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today.

A person was wondering about how data is generated… Read more

0 comments, 582 reads

Posted in The Voice of the DBA on 5 October 2017

Ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

David is delivering his Microsoft Azure for the SQL DBA talk this weekend in SQL Saturday Denmark. Go and see him if you attending the event - you can find his session in the schedule

David has updated his eBook Putting Your Head in the Cloud: An Introduction to…

Read more

0 comments, 164 reads

Posted in The SQL DBA in the UK on 5 October 2017

Toolbox - Fix Your FILEGROWTH

One of the items we usually flag in reports is FILEGROWTH by percentage.  It doesn't help that for most versions of SQL Server the default FILEGROWTH increment for one or both files (DATA and LOG) is 10%.


As you probably already know, the key flaw to percentage-based FILEGROWTH is…

Read more

0 comments, 1,302 reads

Posted in Nebraska SQL from @DBA_ANDY on 5 October 2017

Enabling Database Containment for an Instance – #SQLNewBlogger

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.

I wanted to test a contained database feature the other day and… Read more

0 comments, 299 reads

Posted in The Voice of the DBA on 4 October 2017

Changes to Service Packs and Cumulative Updates for SQL Server 2017

For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update model, in order to get bug fixes and other improvements to customers faster. With SQL Server 2017, which runs on both Linux and Windows (as well as Docker containers for… Read more

0 comments, 211 reads

Posted in Born SQL with Randolph West on 4 October 2017

The Alpha and the Omega. The BEGIN and the END.

The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do a little review. Not to mention that there are always people just starting to learn about a subject.

So what is a BEGIN/END block? They are boundaries that define… Read more

2 comments, 615 reads

Posted in SQLStudies on 4 October 2017

Azure SQL Database Data Integrity Checks

If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it is and ponderings on how it is actually done. (https://blobeater.blog/2017/09/04/dbcc-checkdb-azure-sql-database/)

Recall that is consumes a lot of DTUs running CHECKDB on your Azure SQL Database so I had… Read more

0 comments, 179 reads

Posted in All About SQL on 4 October 2017

SQL Sequence vs Identity Column

Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever… Read more

1 comments, 173 reads

Posted in SQLEspresso on 4 October 2017

Newer posts

Older posts