PASS Summit lands in Seattle from October 31 to November 3 this year, bringing with it the latest thinking and developments in the SQL Server world. Redgate is a Gold sponsor and we’ll be there, talking about database DevOps and other topics. Look out in particular for: How DevOps for the database helps with compliance... Read more
I have a lot of experience working in financial services and I’ve recently been talking to Database Administrators (DBAs) who work in the sector. Unsurprisingly, perhaps, deploying database changes is the most taxing part of their job. They’re often required to review thousands of lines of script and it can take days, depending on... Read more
SQL Server 2017 officially landed today and is now on general release. The latest version of the heavyweight platform is more than the sum of its parts, however, because it doesn’t just deliver new functionality. Alongside the list of extra features, it also changes two important ways we think about the platform itself. Time... Read more
DevOps is gaining ground everywhere. By offering a route to releasing software faster, with fewer errors, it can give companies which adopt it an immediate advantage. Unfortunately, it’s not something you can just buy or decide to do tomorrow. Instead, it’s a shift that needs the right guidance to become reality. But while there... Read more
When SQL Server 2017 launched, Microsoft proudly announced that it was the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. In the future, database servers running its software won’t just be able to store, query, and analyse data. Instead, they’ll also be able to perform machine learning, natural language, and neural... Read more
Updated November 2018 You’ve no doubt heard at least something about the GDPR, the EU’s new privacy and Data Management law with its greatly increased maximum fines for non-compliance and tighter definitions for acceptable use of personal information. It came into effect in May 2018. If you’ve continued reading past paragraph one of any... Read more
We’re excited to be part of Microsoft Ignite this year, in sunny Orlando, Florida. In Microsoft’s own words, this is the event where ‘The community of IT professionals comes together to transform your businesses’. It’s the perfect opportunity to learn about breaking announcements and plans, see the latest technology in action, and ask questions... Read more
DevOps has come a long way since it was first showcased in Flickr’s seminal ’10 deploys per day’ Velocity presentation in 2009. Just eight years later, it is being rapidly adopted and, as the 2017 State of DevOps Report from DORA and Puppet shows, there are big advantages for companies and organizations which embrace... Read more
If you’re doing DevOps differently for your database and the rest of your system, there’s something wrong. There shouldn’t be a separate conversation about it, says Microsoft’s Donovan Brown. When DevOps was first talked about in Flickr’s seminal ’10 deploys per day’ Velocity presentation in 2009, it was regarded by some as strange and... Read more
The download count of the tSQLt unit testing framework is surprisingly low, yet this outstanding open source software can revolutionize your SQL Server development process. Hopefully, this post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. This simple technique can have a profound effect... Read more