Redgate Blog

Posts by
Steve Jones

10 February 2017

SQL Clone and databases protected with TDE – part 1

Steve Jones proves that SQL Clone can create a clone from a SQL Server database that is protected by Transparent Data Encryption (TDE). Read more

30 January 2017

30 January 2017

Quick SQL Prompt tip – picking the columns you need for speedy results

One of the poor practices that I see so many people doing in code is using SELECT *. This is poor practice because it takes more time to complete for clients, it’s an unnecessary use of resources on the client, server and network, and it can fill the buffer cache… Read more

SQL Prompt

Steve Jones

26 January 2017

Steve Jones

26 January 2017

Quick SQL Prompt tip – script objects as ALTER in two clicks

Working in a large database can be difficult at times. While many of us might learn the meanings and definitions of most objects, it’s easy to forget the exact ways in which some objects work, or what the behavior is in certain calls. This is one place where having tools… Read more

SQL Prompt

Steve Jones

18 November 2016

Steve Jones

18 November 2016

Quick SQL Prompt tip – using the CDB snippet

SQL Prompt includes a number of snippets by default that can help you quickly write T-SQL code. These are templates of code that users use regularly. One of the more popular snippets is the ‘cdb’ snippet that helps with quickly creating a new database for development work. This can also… Read more

SQL Prompt

Steve Jones

27 September 2016

Steve Jones

27 September 2016

Quick SQL Prompt tip – using the ii snippet

SQL Prompt includes a number of snippets by default that can help you quickly write T-SQL code. These are templates of code that users use regularly. One of the more popular snippets is the “ii” snippet that helps with inserting data into a table. If I type “ii” and hit… Read more

SQL Prompt

Steve Jones

14 September 2016

Steve Jones

14 September 2016

Quick SQL Prompt tip – why you should expand the wildcard

One of the great things about SQL Prompt is that it quickly removes the need to use so many keystrokes. That’s helpful and handy, but to become a really efficient T-SQL coder, you’ll want to practice incorporating a few tricks into your routine. Here’s a good one. Often I run… Read more

SQL Prompt

Steve Jones

19 July 2016

Steve Jones

19 July 2016

Using SQL Compare with Row Level Security

As you test your row-level security in various environments, you can use SQL Compare to script out and deploy those changes to other databases. Read more

15 July 2016

15 July 2016

Using SQL Compare with Dynamic Data Masking

SQL Compare works with dynamic data masking, detecting the differences in masks across tables and generating the T-SQL you need to deploy your masking configuration to other databases. Read more

23 October 2015

23 October 2015

DLM S4 – Release Management

Deploying database changes to new environments is a very stressful activity. Many organizations and their employees dread migrating changes to a production database because of the potential for problems or downtime. There are ways to minimize the potential issues and build more reliable deployment processes. In fact, many organizations do… Read more

19 October 2015

19 October 2015

DLM S3 – Continuous Integration

In this post, we take a big step forward in engineering the database development process by looking at Continuous Integration (CI) for your database and the characteristics of a software pipeline that begins to implement a repeatable process. This is the S3 stage, named for, and characterized by, the use… Read more

continuous integration

DLM

Previous Next

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

Posts by
Steve Jones

SQL Clone and databases protected with TDE – part 1

Quick SQL Prompt tip – picking the columns you need for speedy results

Quick SQL Prompt tip – script objects as ALTER in two clicks

Quick SQL Prompt tip – using the CDB snippet

Quick SQL Prompt tip – using the ii snippet

Quick SQL Prompt tip – why you should expand the wildcard

Using SQL Compare with Row Level Security

Using SQL Compare with Dynamic Data Masking

DLM S4 – Release Management

DLM S3 – Continuous Integration

2025 Stand der Datenbank-Landschaft

Einführung in PostgreSQL für den Datenprofi

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Posts bySteve Jones

Cookies on red-gate.com

Posts by
Steve Jones