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

<< Newer    Items 21 to 40 of 16459    Older >>
 

Customize Software or Process

The build v buy decision isn't the final one. We also need to decide if we'll use software as is or customize it.  Read more...
By Steve Jones 2018/01/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017

This step by step approach explains how to assess your SQL Server migration using DMA. Learn how to understand the behavior of your existing version and what changes need to be made to migrate to a newer version of SQL Server.  Read more...
By 2018/01/16 | Source: SimpleTalk | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 3,226 reads

NEW – Create, protect and manage non-production databases with SQL Provision

Redgate's newest offering helps address data privacy and protection concerns by creating copies of SQL Server databases that mask all sensitive data. SQL Provision serves as a gateway between production and non-production environments, to ensure the safe distribution of database copies from one central location, without blocking the team’s development and release processes.  Read more...
By 2018/01/16 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,834 reads

Install Visual Studio 2015 in Server without Internet Connection

Install Visual Studio 2015 in Windows Server without Internet Connection  Read more...
By Vishnu Gupthan 2018/01/15 | Source: SQLServerCentral.com | Category: visual studio
Rating: |  Discuss |   Briefcase | 400 reads

SQL Server Machine Learning Services – Part 2: Python Data Frames

SQL Server Machine Learning Services provides the ability to run Python scripts directly against data in SQL Server. To do so, you must understand how to work with the data frame object. Robert Sheldon explains how to get started using the data frame object, how to pass data from SQL Server to it, and how to manipulate it with Python and pandas commands.  Read more...
By 2018/01/15 | Source: SimpleTalk | Category: machine learning services (mls)
Rating: (not yet rated)  Rate this |   Briefcase | 2,962 reads

Do you have or make professional goals?

Goals can be important so we don't fall into complacency.  Read more...
By Ben Kubicek 2018/01/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 41 reads

How to automatically provision sanitized data using SQL Clone, Data Masker, and PowerShell

This article describes a strategy, using data masking, cloned databases, and PowerShell, which will allow you to sanitize data before it is copied or moved, for example from a production environment into testing or development environments.  Read more...
By 2018/01/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,344 reads

Data-driven Prototypes

Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.  Read more...
By Phil Factor 2018/01/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 35 reads

Binary Files Import and Export

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.  Read more...
By Sergey Benner 2018/01/12 (first published: 2008/08/28) | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 9,670 reads

Disable or Drop

When you need to debug or troubleshoot, Steve Jones wants you to disable, not drop, objects.  Read more...
By Steve Jones 2018/01/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

Finding code smells using SQL Prompt: procedures that lack schema-qualification

It is a very good idea to get into the habit of qualifying the names of procedures with their schema. It is not only makes your code more resilient and maintainable, but as Microsoft introduces new features that use schemas, such as auditing mechanisms, you code contains no ambiguities that could cause problems.  Read more...
By 2018/01/12 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,975 reads

SQL Server 2017 and Python Basics

This tutorial from Siddharth Mehta is intended to help experienced T-SQL Developers, DBAs, Data Analysts and Data Science enthusiasts to start using Python language with T-SQL.   Read more...
By 2018/01/12 | Source: MSSQLTips.com | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 3,587 reads

GDPR - A guide for the perplexed

If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?  Read more...
By David Poole 2018/01/11 | Source: SQLServerCentral.com | Category: gdpr
Rating: |  Discuss |   Briefcase | 1,547 reads

Job Interviews: What is Normalization?

Do you know how to answer normalization questions in an interview? Steve Jones gives you a few ideas and recommends you brush up on your knowledge.  Read more...
By Steve Jones 2018/01/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 118 reads

What is database DevOps, and why is it important for DBAs?

Over the past 20 years, the concept of database DevOps has always been around, but the ability to automate tasks hasn’t been as simple for the database as it has been for application development. Database DevOps tools have now emerged, however, and the benefits of including DevOps for the database are being realized by many organizations to achieve greater operational efficiency.  Read more...
By 2018/01/11 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 3,707 reads

A Walk Around SQL Operations Studio

SQL Server Management Studio has been the default tool for working with SQL Server for over a decade. It’s not, however, compatible with any operating system outside of Microsoft Windows. SQL Operations Studio (SQLOPS), the open source program originally called ‘Project Carbon’, is now available for users of Linux and macOS as well as Windows. Robert Cain demonstrates the features of SQLOPS.  Read more...
By 2018/01/11 | Source: SimpleTalk | Category: sql operations studio
Rating: (not yet rated)  Rate this |   Briefcase | 3,637 reads

Stairway to SQL Server Agent - Level 4: Configuring Database Mail

Examines the database mail system configuration in depth. You will learn how to configure database mail to work with SMTP mail systems, and get some troubleshooting tips.  Read more...
By Richard Waymire 2018/01/10 (first published: 2011/07/28) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,568 reads

SQL Crossword - Best Practices

This crossword tests your knowledge of SQL Server best practices.  Read more...
By Kenneth Fisher 2018/01/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2018/01/10 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 91,041 reads

How SQL Monitor Monitors Azure-based SQL Server Failover Cluster Instances

This article will show you how to set up SQL Monitor to monitor Azure-based clustered instances right alongside your on-premise clusters.  Read more...
By 2018/01/10 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,644 reads
<< Newer    Items 21 to 40 of 16459    Older >>