Redgate is hosting a 1 day public workshop on April 22, 2015. This workshop will teach you how to put a database in source control, deploy a database from source control, and monitor database changes across development, testing, and production environments.
In order to automate the delivery of an application together with its database, you probably just need the extra database tools that allow you to continue with your current source control system and release management system by integrating the database into it. If you're using the Microsoft stack, then Redgate's tools can help with some of the difficult database parts of the process, as Jason Crease demonstrates.
Today we have a guest editorial from Andy Warren where he looks back at how things have changed.
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
Steve Jones runs the SQL Cop tests against the SQLServerCentral database and looks at the results.
What are the SQL Server Reporting Services Document Map and Bookmark properties? How can they be used? Do they work for all rendering formats? Scott Murry answers these questions and more.
In this article, Robin Shahan explains what Blob Leases are and how to use them, including code samples for calling the different methods available for managing Blob Leases.
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
R is an interesting language and one that might become more important to data professionals in the future. Microsoft is also making an investment here.
Database Design is one of those tasks where you have to carefully get all the major aspects right. If you mess-up just one of these, it can all go horribly wrong. So what are these aspects that can ruin database design, and how can you get them right? Robert Sheldon explains.
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Hi as shown below a replication target requires a primary key. if we want...
Comments posted to this topic are about the item Local Agents
Comments posted to this topic are about the item Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers