For a long time, SQL Compare has been the industry standard for comparing and deploying SQL Server database schemas. Packed with features that can be used to maintain a history of deployments, it makes it possible to build up a record of which objects were changed, when a change was applied, who made it,... Read more
How difficult is it to program a user login function for an application? Novice developers think it's very easy. Experienced developers know better: it is the most sensitive process in your application. Errors in login screens can lead to serious security issues. In this article we take a look at how to store authentication... Read more
Continuous delivery brings big business benefits to application development – it’s time to give the database the same benefits, says Simon Galbraith, chief executive and co-founder of Redgate. Microsoft’s recent announcement that Windows 10 will be the last big-bang release for the operating system was a surprise to many. But what on Earth is... Read more
Over the years, our SQL in the City events have proved enormously popular in offering SQL Server training to hundreds of database professionals. Now in its fifth year, SQL in the City attracts Database Administrators and developers (as well as other professionals who work with SQL Server) who want to hear the world’s top SQL Server speakers... Read more
Many think that a database modeler’s only job is to create an entity relationship diagram (ERD). Little do they know that data modeling goes way beyond just drawing lines and boxes. In this article, I reflect on the real tasks of a data modeler. Read more
Continuing my series of articles on designing a database model for an online discussion forum, I will add some more advanced features to my initial concept. Firstly, I will enhance the user details which are stored in our model, adding not only some new personal data but also simple user’s roles and statuses. Then,... Read more
Even though Vertabelo doesn’t provide a direct conversion of a data model from one database engine to another, this can be easily done in a few simple steps. In this article we will show you how to migrate your Entity Relationship Diagram between two different database engines using the example of a data model... Read more
Trying to tame complexity Over the last few years my team (“DevOps” – the name’s not entirely accurate, but close enough) have been putting together a handful of charter-like documents that we can agree on and work to. This isn’t an especially new idea and we shamelessly cribbed the initial version from one of the other teams.... Read more
If you haven’t heard of DLM Dashboard, let me fill you in – it’s a new free tool for helping SQL Server DBAs and developers know what database schema is deployed where. One of the main ways DLM Dashboard does this is by sending an email notification as soon as it spots any unexpected... Read more
We’ve just finished the acquisition of ReadyRoll, a database migrations and deployment tool that makes it easy for software teams to develop SQL Server databases within Visual Studio. That’s the headline news, but why did we do it, and are our customers really ready for it? I’ll answer the second question first. Yes. With... Read more
