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,156 DBAs, developers and SQL Server users

Rss
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 | 114 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 | 464 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 | 390 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,414 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,736 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,596 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 | 509 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,082 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 | 432 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 | 1,973 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 | 258 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 | 368 reads
Question of the Day

That's a Switch!

By Steve Knox 2017/06/29 | Category: alter table
Rating: (not yet rated) |  Discuss |   Briefcase | 159 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
1.
GilaMonster
37597 156986 SSC Guru  
2.
Jeff Moden
36943 156219 SSC Guru  
3.
Steve Jones - SSC Editor
25171 110019 SSC Guru  
4.
Grant Fritchey
17482 74467 SSC Guru  
5.
Lynn Pettis
15546 68390 SSC Guru  
Latest forum posts