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

Content with tag RedGate Rss

   Items 1 to 20 of 196    Older >>

Investigating problems with ad-hoc queries using SQL Monitor

There is nothing wrong with the principle of using ad-hoc queries; one can use them occasionally and perfectly legitimately. However, when ad-hoc queries run as part of a processes that does database operations iteratively, row-by-agonizing-row, they can be one of the most unremitting ways of sapping the performance of a SQL Server instance.  Read more...
By 2018/03/20 | Source: Redgate | Category: ad hoc queries
Rating: (not yet rated)  Rate this |   Briefcase | 668 reads

Masking Dates in a Non-Production Database

All too often there’s a reluctance to use masked data since it’s perceived to be just X’s and N’s and therefore not useable. That’s not the case if you use Redgate’s Data Masker tool.  Read more...
By 2018/03/19 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,533 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 our short survey.  Read more...
By 2018/03/16 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 1,481 reads

Extending DevOps to the database with Redgate: the role of automated testing

This webinar will show you how to use Redgate's SQL Test to include automated testing as part of a database DevOps workflow. There will be a walk-through of an automated build and deployment process with DLM Automation in VSTS, and plenty of time to ask questions.  Read more...
By 2018/03/15 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,336 reads

Consider using [NOT] EXISTS instead of [NOT] IN (subquery)

The query optimizer now treats EXISTS and IN the same way, whenever it can, so you’re unlikely to see any significant performance differences. Nevertheless, you need to be cautious when using the NOT IN operator if the subquery’s source data contains NULL values. If so, you should consider using a NOT EXISTS operator instead of NOT IN, or recast the statement as a left outer join.  Read more...
By 2018/03/13 | Source: Redgate | Category: not in
Rating: (not yet rated)  Rate this |   Briefcase | 4,759 reads

Redgate’s support for Azure SQL Database Managed Instances

Last week Microsoft released the public preview of Azure SQL Database Managed Instances – an exciting new option for running SQL Server workloads in the cloud. This blog post explains what they are, and how Redgate's SQL Toolbelt supports them.  Read more...
By 2018/03/12 | Source: Redgate | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,893 reads

SQL Provision adds fully integrated data masking

SQL Provision launched in January, offering users blazingly fast database copying, with a light storage footprint, centralized management, and the ability to mask any sensitive data, prior to distribution. This new release takes compliant provisioning one step further, by integrating data masking directly into SQL Clone’s image creation process, rather than running it as a separate step prior to the image creation.  Read more...
By 2018/03/07 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,308 reads

Misuse of the scalar user-defined function as a constant

If you use an unverified scalar function, then the query will be grindingly slow because you will be executing it on every row whether it has a parameter or not. This post explains the issue in more depth, and shows how SQL Prompt code analysis rules can help you avoid it altogether.   Read more...
By 2018/03/05 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 3,125 reads

Customizing the SQL Prompt built-in snippets: a better ‘ata’ snippet

Snippets are a great feature of SQL Prompt - they save coding time, and introduce standards and consistency to the way you build code modules. But did you know you can customize them? Phil Factor shows how by using ALTER TABLE ADD as an example.  Read more...
By 2018/02/27 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,416 reads

Avoid T-SQL Technical Debt using SQL Prompt Code Analysis

SQL Prompt’s new Code Analysis feature helps you discover code issues and hidden pitfalls during code development, as you type. In this article, Catherine shows how the Code Analysis feature works, and illustrates how to use the feature to improve the quality of your team’s SQL code.  Read more...
By 2018/02/23 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,078 reads

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,994 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:  Rate this |   Briefcase | 3,368 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 | 3,493 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 | 3,121 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,265 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 | 5,537 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,442 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,082 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,449 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 | 6,163 reads
   Items 1 to 20 of 196    Older >>
devops (27)    
webinar (27)    
sql prompt (24)    
sql clone (16)    
sql compare (15)    
survey (14)    
dlm (9)    
provisioning (9)    
sql monitor (9)    
data masking (7)    
sql toolbelt (6)    
compliance (4)    
formatting (4)    
monitoring (4)    
readyroll (4)    
tools (4)    
auditing (3)    
beta (3)    
database lifecycle management (3)    
events (3)    
gdpr (3)    
instant clone (3)    
sql data generator (3)    
sql data mask (3)    
video (3)    
automated deployment (2)    
azure sql database (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)    
snippets (2)    
sql data compare (2)    
sql in the city (2)    
sql provision (2)    
static code analysis (2)    
teamcity (2)    
tfs (2)    
user permissions (2)    
version control (2)    
ad hoc queries (1)    
audit (1)    
automation (1)    
azure (1)    
competition (1)    
data protection (1)    
dbcc checkdb (1)    
dlm automation (1)    
dlm dashboard (1)    
event (1)    
execution plans (1)    
free training (1)    
group by (1)    
inventory (1)    
jenkins (1)    
join (1)    
json (1)    
managed instances (1)    
microsoft data platform (1)    
not in (1)    
oracle (1)    
patching (1)    
poll (1)    
postgresql (1)    
productivity (1)    
release management (1)    
restore (1)    
scalar functions (1)    
set nocount (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 server 2016 (1)    
sql server 2017 (1)    
sql server on linux (1)    
sql source control (1)    
sql test (1)    
technical debt (1)    
test data (1)    
testing (1)    
troubleshooting (1)    
visual studio (1)    
visual studio team services (1)    
vmware (1)    
vsts (1)    
white papers (1)