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

Articles with tag RedGate Rss

Search for any content tagged redgate

   Items 1 to 20 of 205    Older >>
 

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,050 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 | 1,705 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 | 4,074 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,161 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 | 2,859 reads

When to use the SELECT…INTO statement

SELECT…INTO is a good way of making a table-source temporarily persistent as part of a process, if you don’t care about constraints, indexes or special columns.  Read more...
By 2018/03/30 | Source: Redgate | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,366 reads

Driving up database coding standards using SQL Prompt

This article will demonstrate how a team can use SQL Prompt to establish and share coding standards, through code analysis rules, formatting styles and code snippets.  Read more...
By 2018/03/29 | Source: Redgate | Category: coding standards
Rating: (not yet rated)  Rate this |   Briefcase | 3,446 reads

Monitoring and Troubleshooting Deadlocks with SQL Monitor

This article will discuss why deadlocks occur, why they require immediate investigation by the DBA, and the diagnostic data required to troubleshoot them.  Read more...
By 2018/03/26 | Source: Redgate | Category: deadlocks
Rating: (not yet rated)  Rate this |   Briefcase | 3,560 reads

5 Minutes with Fritchey

For quick information on various aspects of the Microsoft Data Platform and Redgate software, look no further than Grant Fritchey's Youtube channel. In addition to all the technical content, he also editorializes on various aspects of data and all things IT.  Read more...
By 2018/03/22 | Category: video
Rating:  Rate this |   Briefcase | 3,421 reads

Registration is now open for Redgate's SQL Privacy Summit

The SQL Privacy Summit takes place on May 18, in London, and is an exclusive conference for senior IT data managers, responsible for data privacy and protection of SQL Server databases. You'll learn how Redgate's solutions help to ensure the ongoing protection of personally identifiable information (PII) in SQL Server, so that you can protect your business and comply with data privacy regulations such as the GDPR.   Read more...
By 2018/03/22 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,069 reads

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 | 3,184 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 | 2,904 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 | 2,095 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 | 6,550 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 | 5,355 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 | 2,090 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,436 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,439 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,543 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,146 reads
   Items 1 to 20 of 205    Older >>