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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,887,173 DBAs, developers and SQL Server users

Headlines today   June 29, 2017

Scoring Outliers in Non-Normal Data with R

Using R to detect outliers is relatively easy, but most methods assume your data is normally distributed. How do you handle skewed datasets?  Read more...
By Nick Burns 2017/06/29 | Source: SQLServerCentral.com | Category: outlier detection
Rating: |  Discuss |   Briefcase | 247 reads

Azure Automation Methods

Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.  Read more...
By Additional Articles 2017/06/29 | Source: SQLPerformance.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 792 reads

Provisioning just got BIGGER

The recent launch of Redgate SQL Clone v2 has removed the previous 2TB size limit, as the tool now supports cloning databases up to a whopping 64TB. In this post, Karis Brummit explains how the increase has been possible.  Read more...
By 2017/06/29 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 641 reads
Previous headlines

Replace Bad Characters in Table

Learn how to clean bad characters from lots of data in this article.  Read more...
By souLTower 2017/06/28 | Source: SQLServerCentral.com | Category: data cleanup
Rating: |  Discuss |   Briefcase | 1,458 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2017/06/28 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 25,809 reads

Generating HTML from SQL Server Queries

You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.  Read more...
By Additional Articles 2017/06/28 | Source: SimpleTalk | Category: html
Rating: (not yet rated)  Rate this |   Briefcase | 2,729 reads

Filegroup Restoring and Database Consistency

In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.  Read more...
By Bogdan SAHLEAN 2017/06/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 517 reads

How to Read the Transaction Log File

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.  Read more...
By Additional Articles 2017/06/27 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 3,133 reads

Workplace Encounters: Using Volume Mount Points in SQL FCIs

How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points  Read more...
By Kenneth Igiri 2017/06/26 | Source: SQLServerCentral.com | Category: disks
Rating: |  Discuss |   Briefcase | 436 reads

A DLM Approach to Database Testing

Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,040 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016

In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment...  Read more...
By willassaf@gmail.com 2017/06/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 352 reads

Persisting data in docker containers – Part One

Normally when I work with SQL instances within containers I treat them as throw-away objects. Any modifications that I make...  Read more...
By Andrew Pruski 2017/06/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 547 reads
Question of the Day

That's a Switch!

By Steve Knox 2017/06/29 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 359 reads

In your Play database, you have two tables, dbo.Stage and dbo.Live. They have the same columns and indexes (and meet all other metadata requirements for ALTER TABLE ... SWITCH), but they...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
37724 157220 SSC Guru  
Jeff Moden
37139 156502 SSC Guru  
Steve Jones - SSC Editor
25309 110207 SSC Guru  
Grant Fritchey
17526 74565 SSC Guru  
Lynn Pettis
15602 68482 SSC Guru  
Latest forum posts