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

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

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/21 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 998 reads

Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.  Read more...
By Additional Articles 2017/04/04 | Source: SQLPerformance.com | Category: dbcc clonedatabase
Rating: (not yet rated)  Rate this |   Briefcase | 3,747 reads

SQL Clone Trivia Quiz - Terms and Conditions

By 2017/04/03 | Source: Redgate
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Tell Me a Joke

We missed April 1 this year, so Steve is looking for some good jokes.  Read more...
By Steve Jones 2017/04/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 90 reads

Step by Step Configuring AlwaysOn with Log Shipping

In this article, I will show you a procedure to combine SQL Server AlwaysOn with logshipping and to make log-shipping to work even in case of failovers between availability replicas in primary site.  Read more...
By Ganapathi varma Chekuri 2017/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 855 reads

Migrating a Disk-Based Table to a Memory-Optimized Table in SQL Server

The feature formerly known as Hekaton, now In-Memory OLTP can provide very useful performance gains where you carefully select the tables to become memory-optimised. How do you set about the job of converting existing tables to become memory-optimised tables? the process isn't entirely straightforward but the benefits that an In-Memory OLTP table delivers is worth your effort. Alex Grinberg takes you through the basics.  Read more...
By Additional Articles 2017/04/03 | Source: SimpleTalk | Category: memory-optimized table
Rating:  Rate this |   Briefcase | 4,294 reads

The Ideal Agile Database

The ideal Agile database needs to be secure, recoverable, transactional, resilient, and versatile enough to allow easy migration paths when you need to delegate tasks elsewhere, for scalability. Sounds like a relational database to Phil Factor.  Read more...
By Phil Factor 2017/04/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

A Single-Parameter Date Range in SQL Server Reporting Services

Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter.  Read more...
By John F. Tamburo 2017/03/31 (first published: 2015/11/18) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 8,093 reads

What do you do to relax after work?

Is the stuff we do in our off hours truly relaxing or just taking up time?  Read more...
By Ben Kubicek 2017/03/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 88 reads

Working with Windows Containers and Docker: The Basics

When you begin to work with containers, you will notice many similarities between a container and a virtual machine; but, in fact, these are two quite different concepts. Containers are going to change the way that we do Windows-based development work in the coming year, and they already underpin much of the devops work of speeding the delivery process. Nicolas Prigent explains how to use the Windows Containers feature.  Read more...
By Additional Articles 2017/03/31 | Source: SimpleTalk | Category: windows containers
Rating:  Rate this |   Briefcase | 4,822 reads

Webinar: how to get started with DevOps

More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it’s not always clear what's the best way to get started. Redgate have invited Steve Thair, CTO of the DevOpsGuys, to share some practical tips on how you can start implementing DevOps in your organization. Register for the free webinar.  Read more...
By 2017/03/31 (first published: 2017/03/22) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 4,315 reads

Performaing a Right and Comprehensive Age Calculation Part 2

Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.  Read more...
By Sergiy Floka 2017/03/30 | Source: SQLServerCentral.com | Category: age calculation
Rating: |  Discuss |   Briefcase | 886 reads

What's New in Master Data Services MDS 2016 - Part 1

SQL Server 2016 introduced many new features and improvements for all its products, and Master Data Services (MDS) is no exception. In this post, Koen Verbeeck gives a comprehensive overview of all the new MDS features.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,872 reads

Is work just work?

Are you enjoying your work? 
By Nitin Bhojwani 2017/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 91 reads

Audit and compliance survey with prize draw

The Foundry team at Redgate have been investigating how different regulations impact work with SQL Server. They understand the many regulations, but need your help to get a better idea of all the related activities. How has your experience with auditing and compliance been in the past? Fill out this short survey to let the team know, and in return you'll be entered into a draw to win a $100 Amazon gift card.  Read more...
By 2017/03/30 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 1,797 reads

Big Companies are Improving with DevOps

Steve Jones notes that not just the small, startup, agile companies use DevOps. Nor is it just technology companies.  Read more...
By Steve Jones 2017/03/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 37 reads

Justify the Remote access requirement for Biztalk Log Shipping

This article will show why there is a need for remote access with a Biztalk server that uses log shipping.  Read more...
By Bilal Ayub 2017/03/29 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 280 reads

Handling Graphs in SQL

Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are graphs in which attributes can be associated with the nodes and edges. It is a natural way to study relationships within the data. SQL databases aren't the easiest way of doing it, but it makes sense where the scale permits it. Because of the range of graphs and techniques, some Graph theory is unavoidable before you get stuck into the code, and who better to introduce graph databases than Joe Celko?  Read more...
By Additional Articles 2017/03/29 | Source: SimpleTalk | Category: graphs
Rating:  Rate this |   Briefcase | 4,221 reads


Getting hacked is no fun. Today Steve Jones notes he's been hacked, in more ways than one and wants you to think about this at your workplace.  Read more...
By Steve Jones 2017/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 340 reads

Performing a Right and Comprehensive Age Calculation

Age calculation based on the right method used in real life.   Read more...
By Sergiy Floka 2017/03/28 | Source: SQLServerCentral.com | Category: datetime conversions
Rating: |  Discuss |   Briefcase | 1,668 reads
<< Newer    Items 61 to 80 of 15646    Older >>