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

Content with tag RedGate Rss

   Items 1 to 20 of 221    Older >>

SQL in the City Streamed – Compliant DevOps: June 20 2018

Join Redgate’s livestream on June 20 and learn from Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey, and Kathi Kellenberger. The schedule will include sessions to help you learn how to demonstrate compliance with regulations such as the GDPR, HIPAA and SOX. Find out more and register for free  Read more...
By 2018/05/24 | Source: Redgate | Category: compliance
Rating: (not yet rated)  Rate this |   Briefcase | 1,515 reads

The 2018 State of DevOps Survey. Don’t just wait for it. Be a part of it.

Redgate is joining forces with DevOps Research and Assessment (DORA) and Google Cloud to support the pursuit of DevOps excellence. The research aim is to better understand the DevOps landscape, and to surface new findings that provide guidance for improvement in resource management, productivity, and quality of technology delivery teams. To have your say and be part of the research, simply take the survey - there are even some great prizes up for grabs!   Read more...
By 2018/05/22 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,737 reads

Monitoring Distributed SQL Servers using SQL Monitor

Many organizations are experiencing rapid expansion and diversification of their SQL Server estate to include Cloud, VMWare and other platforms, alongside traditional on-premise servers. This article explains the basic architecture and components of SQL Monitor, and then how to set up a distributed monitoring solution.  Read more...
By 2018/05/22 | Source: Redgate | Category: monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,431 reads

The State of SQL Server Monitoring 2018

Over 600 technology professionals who work in organizations that use SQL Server recently responded to our survey to discover the current state of SQL Server monitoring.  Read more...
By 2018/05/21 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,056 reads

Welcome to Redgate tools for SQL Operations Studio

Built on top of Visual Studio Code, SQL Operations Studio is a free lightweight tool for modern database development and operations that runs on Windows, macOS and Linux. It’s been designed for developers without a deep knowledge of database administration, so that they can manage databases and maintain them.  Read more...
By 2018/05/17 | Source: Redgate | Category: sql operations studio
Rating: (not yet rated)  Rate this |   Briefcase | 2,624 reads

Pseudonymizing your data with SQL Data Generator

SQL Data Generator was, as its name suggests, intended to generate the data for databases, as required for testing, development work and training. However, it is perfectly at home with using the original data as the default source of the new data, and then substituting in fake data for any column that you want to mask - here's how.  Read more...
By 2018/05/15 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,962 reads

Automatic Provisioning of Developer Databases with SQL Provision

This article shows a simple proof-of-concept workflow that allows an organization to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process.  Read more...
By 2018/05/11 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,809 reads

SQL Compare Snapshots: a lightweight database version control and rollback mechanism

SQL Compare snapshots provide an easy way to keep track of changes during development work, whether they are small changes between iterations, or significant changes between releases. Snapshots can be used to quickly generate rollback scripts during releases even in environments which are isolated by infrastructure design for security reasons.  Read more...
By 2018/05/10 | Source: Redgate | Category: version control
Rating: (not yet rated)  Rate this |   Briefcase | 2,673 reads

Join the leading experts in data governance and SQL Server at Redgate’s SQL Privacy Summit

The GDPR is almost here and, just one week before it’s launch, Redgate is hosting the first SQL Privacy Summit in London. The schedule of presentations, panel discussions and workshops has been created to help SQL Server professionals ensure their business meets the new data privacy and protection regulations.  Read more...
By 2018/05/08 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,060 reads

Avoid use of the MONEY and SMALLMONEY datatypes

One of SQL Prompt's code analysis recommendations is that you avoid using the MONEY and SMALLMONEY datatypes - this article from Phil Factor explains why.  Read more...
By 2018/05/04 | Source: Redgate | Category: code analysis
Rating:  Rate this |   Briefcase | 4,336 reads

The future of database DevOps

In this post, Redgate's Foundry team reflect on their assessment of the status of DevOps for the database. As well as giving you a behind-the-scenes look at how they've arrived at this thinking and setting out their future direction, they also invite you to shape the future of database DevOps by getting involved.  Read more...
By 2018/05/03 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,876 reads

A strategy for implementing database source control

Much has been written on the benefits of having a database under source control, though many articles are clear on “why” but conspicuously vague on “how”. In this ahis article, David Poole describes what was required of his organization's database source control solution, how they approached the challenges, and how using Redgate SQL Source Control as a template helped.   Read more...
By 2018/04/27 | Source: Redgate | Category: source control
Rating: (not yet rated)  Rate this |   Briefcase | 2,928 reads

Detecting Problems on Databases that use Snapshot-based Transaction Isolation

If you’re using SQL Server’s Read Committed Snapshot Isolation level (RCSI) to avoid long waits for a blocked resource, then you’ll want to monitor for possible side effects. This article describes one way to monitor for such problems, using an alert on version_ghost_record_count, to warn us when the number of row versions in tempdb is getting very high.  Read more...
By 2018/04/26 | Source: Redgate | Category: read committed snapshot isolation
Rating: (not yet rated)  Rate this |   Briefcase | 2,185 reads

Shift LEFT magazine: Issue 3

The latest issue of Redgate’s Database DevOps magazine explores the benefits of DevOps for CEOs, CIOs, and IT Managers, and takes a comprehensive look at the new General Data Protection Regulation, providing a valuable insight into how organizations can meet its demands.  Read more...
By 2018/04/25 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,333 reads

Approaches to masking email addresses

There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns.  Read more...
By 2018/04/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,957 reads

Effective Database Testing with SQL Test and SQL Cover

A well-established technique for improving application code quality, during software development, is to run unit tests, in conjunction with a code coverage tool. The aim is not only to test that your software components behave as you would expect, but also that your suite of tests gives your code a thorough workout.  Read more...
By 2018/04/17 | Source: Redgate | Category: testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,536 reads

Redgate’s SQL Privacy Summit – London, 18 May

Are you responsible for data privacy and protection of SQL Server databases in your organization? Then you might be interested in Redgate’s brand new conference, the SQL Privacy Summit, taking place in London on Friday 18 May.  Read more...
By 2018/04/16 | Source: Redgate | Category: event
Rating: (not yet rated)  Rate this |   Briefcase | 2,041 reads

Extending DevOps to the database: branching and merging

This webinar will focus on branching and merging with Visual Studio Team Services (VSTS) as part of a DevOps approach to database development. It will also show how Redgate tools plug into VSTS to enable the build, test and deployment of your database changes. There will also be plenty of time to ask Grant and Arneh questions.   Read more...
By 2018/04/12 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,986 reads

Take the SQL Estate Data Mapping Survey and help shape Redgate’s products

Help Redgate to learn more about how SQL Server teams keep on top of sensitive data. If you're planning, or are already implementing, an information audit or data-mapping exercise for your SQL Server estate, please complete their short survey.  Read more...
By 2018/04/03 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,323 reads

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

This article shows how to use the SQL Prompt actions that you can apply as part of the Format SQL command. These actions are designed to help improve the overall quality of your SQL code, in various subtle but meaningful ways, such as qualifying object names, standardizing the use of aliases, adding semicolons to the end of statements, and removing unnecessary square brackets around object names.  Read more...
By 2018/04/02 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,038 reads
   Items 1 to 20 of 221    Older >>
devops (32)    
sql prompt (28)    
webinar (28)    
sql clone (16)    
sql compare (16)    
survey (16)    
sql monitor (13)    
provisioning (10)    
data masking (9)    
dlm (9)    
gdpr (7)    
monitoring (7)    
sql toolbelt (6)    
compliance (5)    
data privacy (5)    
data protection (4)    
event (4)    
events (4)    
formatting (4)    
readyroll (4)    
sql data generator (4)    
tools (4)    
video (4)    
auditing (3)    
beta (3)    
code analysis (3)    
data governance (3)    
database lifecycle management (3)    
instant clone (3)    
sql data mask (3)    
sql provision (3)    
version control (3)    
automated deployment (2)    
azure sql database (2)    
classification (2)    
financial (2)    
git (2)    
interview (2)    
microsoft (2)    
octopus deploy (2)    
pass summit (2)    
powershell (2)    
snippets (2)    
source control (2)    
sql data compare (2)    
sql in the city (2)    
sql operations studio (2)    
sql source control (2)    
sql test (2)    
static code analysis (2)    
teamcity (2)    
testing (2)    
tfs (2)    
troubleshooting (2)    
user permissions (2)    
vsts (2)    
ad hoc queries (1)    
audit (1)    
automation (1)    
azure (1)    
code coverage (1)    
coding standards (1)    
competition (1)    
dbcc checkdb (1)    
deadlocks (1)    
dlm automation (1)    
dlm dashboard (1)    
download (1)    
execution plans (1)    
free (1)    
free training (1)    
group by (1)    
inventory (1)    
jenkins (1)    
join (1)    
json (1)    
managed instances (1)    
microsoft data platform (1)    
money (1)    
monitor (1)    
not in (1)    
oracle (1)    
patching (1)    
poll (1)    
postgresql (1)    
productivity (1)    
read committed snapshot isolation (1)    
release management (1)    
report (1)    
restore (1)    
rollback (1)    
scalar functions (1)    
set nocount (1)    
software development (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 search (1)    
sql server 2016 (1)    
sql server 2017 (1)    
sql server on linux (1)    
technical debt (1)    
test data (1)    
training (1)    
t-sql (1)    
visual studio (1)    
visual studio team services (1)    
vmware (1)    
white papers (1)