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

Content with tag RedGate Rss

   Items 1 to 20 of 186    Older >>
 

Sign up for more free training from Redgate

Redgate has committed to hosting a free virtual event in every quarter of 2018, and will be kicking this off on February 28 with a livestream themed around data privacy and protection. The agenda has now been released, so you can see who will be presenting, what they will be presenting, and how you can tune in to watch.  Read more...
By 2018/02/20 | Source: Redgate | Category: event
Rating: (not yet rated)  Rate this |   Briefcase | 2,089 reads

How to reformat a database in one operation

Inherited a database from another team? Changed your team policy on the way that you format SQL? What’s to stop you formatting the code of an entire database nicely, when you’re developing it? It can be done, but the process can take longer than you expect. This article will demonstrate a simple 3-step approach to reformatting a whole database to your standard, in a single operation, using SQL Compare and SQL Prompt.  Read more...
By 2018/02/19 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,658 reads

How to Test SQL Server Functions and Procedures using SQL Prompt

When writing functions or procedures, a common chore is to devise and implement the tests that ensure that the routine always works as expected.  Read more...
By 2018/02/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,987 reads

How to monitor the impact of patching on SQL Server performance

In this article, Redgate use the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on your SQL Server estate.  Read more...
By 2018/02/13 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,787 reads

Baselining a ReadyRoll project from an existing database

When creating a new ReadyRoll project, the schema of your production environment can also be imported as a baseline. Further work can be built on top of the baseline in a sandbox development environment and, when you’re happy with the changes, the project can be deployed to production.  Read more...
By 2018/02/12 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,023 reads

Webinar: How the GDPR will impact your software delivery processes

With the GDPR enforcement date looming, organisations are focusing on how data is used internally. This webinar will explain the principals of data protection, translate the GDPR jargon, and cover the steps you'll need to consider to ensure compliance in your software delivery process.  Read more...
By 2018/02/09 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 4,579 reads

Introducing database automation with the SQL Toolbelt

In this post, Mary Robbins explains how Absa bank improved development efficiency and minimized risk by implementing SQL Toolbelt.  Read more...
By 2018/02/08 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,385 reads

How to use the SQL Prompt snippet placeholders for selecting and copying text

There are four SQL Prompt snippet placeholders that are all about selection and copying of text. These placeholders are very handy if, for example, you have two blocks of code that need to be part of a snippet. One part you hold on the clipboard, and the other part is a block of snippet text, selected using the $SELECTEDTEXT$ placeholder.  Read more...
By 2018/02/07 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,024 reads

Realistic, simulated data for testing, development and prototypes

This article proposes a scheme for using Redgate SQL Data Generator (SDG) as a ‘data generation and translation’ tool. We generate the data using a free copy of SQL Server Express, and then use standard bulk copy mechanisms to translate it to various formats, then distribute it out to the different data technologies and platforms that require a copy of the data. The tool becomes a mechanism to support ‘polyglot persistence’.  Read more...
By 2018/02/06 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,391 reads

Free webinar: Change your SQL Server troubleshooting from reactive to proactive with a monitoring tool

Redgate’s James King and Ben Emmett will demonstrate how to troubleshoot your SQL Server estate, and discuss how it shouldn’t be about reacting to problems when they occur, but rather having the tools to make proactive decisions to plan ahead, identify potential disruptions, fix common problems and make improvements.   Read more...
By 2018/02/01 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 5,237 reads

The 2018 State of Database DevOps report

In this year's survey, over 700 IT professionals across a range of sectors, in organizations of every size around the globe were asked about their plans to adopt DevOps, how they thought the database fitted into the picture, and what they thought the biggest challenges were.  Read more...
By 2018/01/30 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 2,399 reads

The Database DevOps Challenges SQL Clone Solves

With its PowerShell integration, SQL Clone becomes an important component in a broader database DevOps toolchain - Tony Davis explains in detail.  Read more...
By 2018/01/26 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,245 reads

Finding code smells using SQL Prompt: the SET NOCOUNT problem

SQL Prompt implements two static code analysis rules to check code for potential misuse of the SET NOCOUNT command. In this post, Phil Factor explains the issue.  Read more...
By 2018/01/25 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,564 reads

Free webinar: Database DevOps demo

Microsoft MVP Grant Fritchey, and Redgate’s Arneh Eskandari, will show you how Redgate’s Database DevOps solution works to improve your database development and deployment processes. You'll see a demo of tools from Redgate's SQL Toolbelt and see how they plug into GIT, Jenkins and Octopus Deploy. There will also be plenty of time to ask Grant and Arneh questions.  Read more...
By 2018/01/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 6,764 reads

Keeping track of history: SQL Compare and Temporal Tables

SQL Compare 13 introduces support for deploying changes to temporal tables, which were introduced in SQL Server 2016. This means that any changes made to the definition of a temporal table in a source database, including to the retention policy for that table, will be included automatically in any deployment script that SQL Compare generates for that database.  Read more...
By 2018/01/19 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,801 reads

Finding code smells using SQL Prompt: old-style join syntax

SQL Prompt implements a static code analysis rule which will check code automatically for occurrences of non-ANSI standard JOIN syntax - here's how it works.  Read more...
By 2018/01/18 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 3,320 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 | 2,439 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,714 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 | 3,926 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,775 reads
   Items 1 to 20 of 186    Older >>
 
Tags
webinar (27)    
devops (26)    
sql prompt (21)    
sql clone (16)    
sql compare (15)    
survey (13)    
dlm (9)    
provisioning (8)    
sql monitor (8)    
data masking (6)    
sql toolbelt (5)    
formatting (4)    
monitoring (4)    
readyroll (4)    
auditing (3)    
beta (3)    
compliance (3)    
database lifecycle management (3)    
events (3)    
gdpr (3)    
instant clone (3)    
sql data generator (3)    
sql data mask (3)    
tools (3)    
video (3)    
automated deployment (2)    
classification (2)    
code analysis (2)    
data governance (2)    
data privacy (2)    
financial (2)    
git (2)    
interview (2)    
microsoft (2)    
octopus deploy (2)    
pass summit (2)    
powershell (2)    
sql data compare (2)    
sql in the city (2)    
static code analysis (2)    
teamcity (2)    
tfs (2)    
user permissions (2)    
version control (2)    
automation (1)    
azure (1)    
azure sql database (1)    
competition (1)    
data protection (1)    
dbcc checkdb (1)    
dlm dashboard (1)    
event (1)    
execution plans (1)    
free training (1)    
group by (1)    
inventory (1)    
jenkins (1)    
join (1)    
json (1)    
microsoft data platform (1)    
oracle (1)    
patching (1)    
poll (1)    
postgresql (1)    
productivity (1)    
release management (1)    
restore (1)    
set nocount (1)    
snippets (1)    
software development (1)    
source control (1)    
source control for oracle (1)    
sql (1)    
sql backup pro (1)    
sql census (1)    
sql doc (1)    
sql graph (1)    
sql multi script (1)    
sql operations studio (1)    
sql provision (1)    
sql server 2016 (1)    
sql server 2017 (1)    
sql server on linux (1)    
sql source control (1)    
technical debt (1)    
test data (1)    
troubleshooting (1)    
visual studio (1)    
visual studio team services (1)    
vmware (1)    
white papers (1)