As developers, we try to write efficient code - but efficient in what? Development time or overall performance?In this article, Jon Smith describes how to investigate and understand performance so that you can decide how to balance these two goals.Check it out...﻿

NEW! SQL Prompt 6.5 BetaWe’ve just released a beta of SQL Prompt 6.5 which includes:• Tab coloring improvements • GROUP BY and ORDER BY suggestions improvements • Import/export all options • SQLCMD mode support • Improvements to closing parentheses behavior • Format actions • Full suggestions for cross-database queries • Temporary tables and their columns can now be renamed with F2• Useful keywords are promoted to the top of the suggestions. For example, SELECT is shown above SAVE

The SQL Prompt beta includes: Tab coloring improvements (UserVoice and experimental feature feedback); GROUP BY and ORDER BY suggestions improvements (UserVoice, UserVoice and UserVoice); Import/export all options (UserVoice); SQLCMD mode support (UserVoice and UserVoice); Improvements to ...

Why is 'DLM' important?While Microsoft gives us the SQL Server Data Tools (SSDT) as a good tooling for developing databases and the ability to store them into Team Foundation Server Version Control, it is only a entry point into the whole DLM (database lifecycle management) process.

This is an interview between Stefan Mieth (ALM Consultant) & Stephanie Herr (DLM expert at Redgate), introducing DLM as a concept to a German ALM audience. They talk about:• what DLM means• why DLM is important to an ALM audience• diving a little bit into Redgate's tool SQL Source Control• some suggestions about some simple things readers can do right away to improve their ALM / DLM processes• how can TFS and SSMS work together?• can database development be agile?

The Cambridge .NET User Group, a new .NET technical community is born in Cambridge, UK. On 10th February, 2015 we held the inaugural event Envisioning the Cambridge .NET User Group and this post want to be a summary for the p...

If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Tempdb is shared by all databases and is used for many operations in a SQL Server instance, so it is common for tempdb to cause performance problems.

This metric returns the current number of pagelatch waits on the tempdb database. Any tempdb page allocation/deallocation or any space changing operations (such as INSERT) acquires a latch on PFS, SGAM or GAM pages to update the space tracking information. Since most temporary objects are heaps and are less than 64KB, a large number of such operations can cause excessive waits when acquiring latches.

SQL Monitor Metric: Number of Unused IndexesUse this metric with SQL Monitor to monitor the number of indexes per database that haven't been used for the last month. Indexes that aren't in use should be removed because they can degrade INSERT, UPDATE and DELETE performance, and they use storage space.Download the metric now...﻿

At Red Gate, we’re passionate about making ingeniously simple tools for SQL Server, .NET, and Oracle.

Introduction

Hello, and welcome to the official Red Gate G+ page.

Red Gate is an internationally recognised software
development company, which specializes in making ingeniously simple tools for
development and data management. Over 620,000 users (and counting) rely on our tools to deploy
their databases, manage their data, and improve their code.

Currently, there are 260 ‘Red Gaters’ working in our head
office (and development center) in Cambridge, UK, with a further 30 people
working in our US office in Pasadena, CA and in our East Asia office in
Singapore..

Founded in 1999 by Simon Galbraith and Neil Davidson, Red
Gate has rapidly grown over the past 13 years, building on our flagship tools SQL
Compare, ANTS
Profilerand SQL Prompt.
We now offer a wide range of tools, focussing on the areas of delivery, data
services, and development.