Vendors/3rd-party Products

Database Development with GitHub

  • Article

How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration testing, and using Redgate tools to automate tasks such as provisioning, database scripting, and testing.

2020-09-25

When SQL Server Performance Goes Bad: Implicit Conversions

  • Article

When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there are some programming habits that must be removed from the code, because they can cause unexpected performance problems. In this article, you'll learn how to detect and remove one such problem: reliance on implicit datatype conversions in your queries. We'll use a combination of plan cache queries, extended events, and SQL Monitor.

2020-09-11

Using Filters to Fine-tune Redgate Database Deployments

  • Article

Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools.

2020-09-02

Blogs

Accessibility in your PowerPoint slide deck

By

This post is part of the series I kicked off here. You can read...

Clustering SAP #ASCS and #ERS on #AWS using Windows Server Failover Clustering

By

When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...

Ethics in Modern Data at the Baton Rouge Analytics and Intelligence Network (BRAIN)

By

On July 27, Christine and I will present our joint presentation on Ethics in...

Read the latest Blogs

Forums

BulkCopy error

By Bruin

I'm trying to load a csv to SQL using the BULKCOPY, but running into...

Login failed: Password did not match that for the login provided.

By tom 69406

I just installed a new instance of SQL Developer Edition - All my apps...

SSIS Custom transform component connectin manager

By Donpi

Hi, I'am currently working on a custom SSIS transform component. I allways create an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers