With the right tools, it is possible to rapidly deploy upgraded databases. By deploying early in development, it's easier to iron out any potential problems that the new deployment could cause in production long before it's time to actually release the software. Tony Davis explains.… Read more
If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.… Read more
When developing software, it makes sense to 'fail early, fail often'; to become aware of mistakes quickly and to learn from them. This means being able to deliver software as early in development as possible. This makes it easier to gather opinions and promote discussions with the people who would want to use the application; and then respond to the feedback. … Read more
The sale of a favourite software company can be disheartening for users, creating concern that the tools and team you love will vanish. Red Gate's Luke Jefferson and Matt Dickens, and Cerebrata's Gaurav Mantri, discuss how they plan to avoid acquisition pitfalls.… Read more
A lot of the buzz around the DBA in Space campaign has centered on the hosts of the snazzy, 60s space-noir webisodes created by Red Gate and The Mill. Simple-Talk sent intrepid reporter Bob Cramblitt to the Rodenberry Launch Center to interview the two hosts, Brad McGehee and the fetching Miss Friday.… Read more
Despite being, for some time, a keen user of SmartAssembly for the .NET components that he produces, Matteo hadn't discovered the Automated Error Reporting feature until recently. As he reports, it has enabled him to be much quicker and more effective in dealing with any problems that one of his users might experience, and it keeps his customers happy too … Read more
One of the greatest pain-points in developing a database-driven application happens when the application is in source control,but the database isn't. When the development database is shared, the pain increases, and it is not alleviated by source control alone. Troy Hunt spells out why each database developer must have their own version of the database.
… Read more
Grant Fritchey, The Scary DBA, has now taken the leap from being a Simple-Talk author and FoRG(Friend of Red Gate) to being employed by Red Gate as 'product evangelist'. As Bob Cramblitt finds out, it means that Grant gets more time to do what he enjoys doing; talking and writing about SQL Server topics that fascinate him, such as query tuning, execution plans, performance monitoring and backups.
… Read more
Bad things tend to happen to developments where the scripts for the database layer are left out of source control. Now that we have the means to do it properly, there are many reasons to make the database an equal partner in the development process. Troy discusses some of those reasons.
… Read more
SQL Storage Compress does just that, and encrypts as well, allowing the files associated with a live database to take much less file-space, and securing them from unauthorised access. Why would this be useful, and is it really a free lunch? Brad puts it to the test to find out.
… Read more
As a dedicated 'twitcher', Michael's eye is caught by a 'tweet' from Red Jungle. In this case, it was not an exotic species, but a user of SQL Source Control who was pleased with the way that it had saved them considerable time in the development process. Out of curiosity, Michael contacted them to find out more.
… Read more
PST Importing has always been a bit messy. With Exchange 2010's Personal Archiving feature, it's become more pertinent, yet still comes with pit-falls, gotchas, and inexplicable errors. James Allison has done some research, and presents an easy way to smoothly tackle the whole problem.… Read more
It might seem a hopeless task to reduce the time an application takes to do a task from three minutes to a second. However, after getting hold of a tool that showed him precisely what was taking the time, Jonathan Evans gained a renewed fascination with performance that led to him shaving what he terms the "banana seconds" off the execution time down to that last second. … Read more
In the first of a series of in-depth software reviews, Brad investigates a newcomer, SQL Virtual Restore. What does it aim to do? How does it achieve it? Why is it safe to use? What are the benefits? Brad aims to answer a range of questions fairly and squarely.… Read more
John Rummell had a problem that is shared by most database developers. How can one use SQL Server Management Studio to put source control files into a source control system such as SubVersion? The processes he tried were all error-prone and awkward to use. And then he found a solution.… Read more
If you could design an Exchange email archiver from scratch, what would you do differently and how would you bring it to maturity? Bob Cramblitt talks with three principals from the new Exchange Server Archiver 3.0 development team and gets the inside story on the soul of a new archiver.… Read more
Sean Duffy, always keen to be on the cutting edge of making his job as a production SysAdmin as painless as possible, puts V3.0 of Red Gate's Exchange Server Archiver through its paces. His verdict: an impressive and transparent tool for managing your Exchange environment.… Read more
Bart tackles all the commonly asked questions about .NET Reflector. Each answer is done as a separate blog post so that your comments, contributions and or supplementary questions can be put as comments to the various blog posts.… Read more