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

<< Newer    Items 61 to 80 of 15925    Older >>
 

Backup Preparations

This week Steve asks you to make sure you practice your restore skills periodically.  Read more...
By Steve Jones 2017/07/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 26 reads

Visual Checks on How Data is Distributed in SQL Server

There are many reasons for wanting to know how data is distributed. Sometimes you just want a rough idea of the way that data is distributed in a column. You may think, wouldn't it be nice to have a SQL function that just showed you roughly what the distribution was, graphically, in the results pane. Phil Factor thought that was well and turned the vague wish into reality.  Read more...
By 2017/07/03 | Source: SimpleTalk | Category: sql server
Rating:  Rate this |   Briefcase | 3,781 reads

Where’s the Ops in DevOps? Part 2

What does the future of IT Operations look like in a DevOps world? As more businesses rely on virtualisation, containers, cloud, Infrastructure as a Service, and Microservices, is there still a place for it? How do these teams change to continue to deliver value when supporting Agile Operations techniques?  Read more...
By 2017/07/03 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,477 reads

A Database Design Test

Steve Jones saw a database design test for developers, but he's never been given one.  Read more...
By Steve Jones 2017/06/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 164 reads

A General Way to Maintain History Tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2017/06/30 (first published: 2015/09/28) | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 9,354 reads

Export data from SQL Server to Excel

What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.  Read more...
By Additional Articles 2017/06/30 | Source: MSSQLTips.com | Category: excel
Rating:  Rate this |   Briefcase | 4,907 reads

The Louis Davidson custom style for SQL Prompt

In this article, Louis Davidson sticks his neck out, and offers what he believes is a sensible code formatting style, based on twenty-plus years of writing SQL. The result is the Louis Davidson custom SQL Prompt style that you can download using the link at the end of the post, try out, and adapt as required.  Read more...
By 2017/06/30 | Source: Redgate | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,370 reads

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 | 528 reads

Handling Data Corruption

This week Steve Jones wonders what you might do if you discovered data corruption.  Read more...
By Steve Jones 2017/06/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 40 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 | 3,286 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 | 2,792 reads

SQL Server is Lagging a Bit

The SQL:2016 standard is out in draft and SQL Server lags a bit.  Read more...
By Steve Jones 2017/06/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

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,804 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 | 26,914 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 | 5,031 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 | 628 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 | 4,493 reads

Classifying Sensitive Data

The ability to protect, and perhaps handle, sensitive data separately from other data is becoming more important. Steve Jones discusses the process and asks if it's something you perform on a regular basis.  Read more...
By Steve Jones 2017/06/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 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 | 485 reads

Improving Replication

If you have ideas for how to improve replication, Steve Jones is asking for them.  Read more...
By Steve Jones 2017/06/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads
<< Newer    Items 61 to 80 of 15925    Older >>