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

Latest Blog Posts

Microsoft Ignite US 2017 – Major Azure Announcements

Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major announcements across the entire solutions portfolio suiteand this year 2017 was certainly no exception to that!

This year it was held in Orlando, FL over 5 days (25 – 29 Sep) and… Read more

0 comments, 236 reads

Posted in Mr. Fox SQL on 9 October 2017

Using xp_delete_file

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions, so you’d be better served by using Powershell or some other type of scripting mechanism. This procedure is not supposed to be supported in the future, so I’d remove this… Read more

2 comments, 228 reads

Posted in The Voice of the DBA on 9 October 2017

The evolution of SQL Server towards Digital Transformation challenges

SQL Server on Linux boosts the database market for Microsoft. Support of PolyBase (a feature to work with Big Data providers), In-Memory Optimized SQL Server, Real-time Operational Analytics, the scaling of Python and R Services for Data analytics, Graph database for NoSQL data, JSON support for transparent data interchange format… Read more

0 comments, 157 reads

Posted in PowerSQL By Prashanth Jayaram on 9 October 2017

Power BI Custom Visuals Class (Module 72 – HTML Viewer)

In this module you will learn how to use the HTML Viewer.  The HTML Viewer allows you to display the results of HTML code within your Power BI reports.

Module 72 – HTML Viewer


Read more

8 comments, 993 reads

Posted in Devin Knight on 9 October 2017

SQL Server 2017 Encrypted Backups And Compression

Let’s work through some code to do an encrypted backup. This feature is available to you if you are using SQL Server 2014 onwards but I decided to use SQL Server 2017.

To encrypt during backup, you must specify an encryption algorithm, and an “encryptor” to secure the encryption key.… Read more

1 comments, 920 reads

Posted in All About SQL on 9 October 2017

Small identity columns

We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small tables. Where we don’t even need an INT. An IDENTITY column can be any of the following data types tinyint, smallint, int, bigint, decimal(p,0), or numeric(p,0). INT and… Read more

5 comments, 1,238 reads

Posted in SQLStudies on 9 October 2017

Understanding ANOVA

ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze differences among groups and if the differences are statistically significant to arrive at any conclusion. The models were developed by statistician and evolutionary biologist Ronald Fischer. To give a… Read more

0 comments, 1,224 reads

Posted in Mala's Data Blog on 9 October 2017

SpeedPASS Download Naming Convention

This was the first time in a long time that I managed the check-in process of SQLSaturday Orlando and was surprised/dismayed to see that when I unzipped the download the filenames were all named with a less than helpful format; b9d73479-5a04-42a3-9f11-a56af7b56beb.pdf. The goal was to be able to quickly find… Read more

2 comments, 939 reads

Posted in SQLAndy on 9 October 2017

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, 728 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,711 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, 128 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,420 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, 238 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, 289 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, 142 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

0 comments, 1,302 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,295 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, 171 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, 163 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, 190 reads

Posted in SQL Swimmer on 5 October 2017

Newer posts

Older posts