Profile cover photo
Profile photo
Redgate Software
1,317 followers -
At Redgate, we make ingeniously simple tools for data professionals working with SQL Server, .NET, and Oracle.
At Redgate, we make ingeniously simple tools for data professionals working with SQL Server, .NET, and Oracle.

1,317 followers
About
Posts

Post has attachment
CONTACTING REDGATE

If you need to contact Redgate then you can find us:
- On Facebook:
www.facebook.com/RedGateSoftwareTools
- On Twitter:
www.twitter.com/redgate, or
- Via our website:
www.red-gate.com/our-company/about/contact

Thanks!
Add a comment...

Post has attachment
ANTS Memory Profiler 8.5 has been released with a range of bug fixes. Download it today, and find out more in the release notes!
Add a comment...

Post has attachment
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...
Add a comment...

Post has attachment
Cambridgeshire folk - the Cambridge .NET User Group is born! The next meetup is Monday 13th April, get signed up today.
Add a comment...

Post has attachment
Given advances in #nosql databases and tools like @3TSoftwareLabs, David Pond discuses what the future might hold.
Read more...
Add a comment...

Post has attachment

Post has attachment
NEW! SQL Prompt 6.5 Beta
We’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

Download the beta here: http://rd.gt/1ANXSPv 
Add a comment...

Post has attachment
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?

Give it a read here:
http://blog.aitgmbh.de/2015/02/13/introduction-to-database-lifecycle-management-and-why-it-is-important-for-alm/
Add a comment...

Post has attachment
New Custom Metric for SQL Monitor
'Tempdb allocation contention' by Fabiano Amorim

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.

Download it now.
Add a comment...

Post has attachment
DLM – solving the database deployment problem with Database Lifecycle Management. Free whitepaper from Redgate.
Add a comment...
Wait while more posts are being loaded