Articles

External Article

Automated database deployment workshops

Redgate is offering a 1-day public workshop for anyone who’s interested in automated deployments for SQL Server databases. In the hands-on exercises, you’ll learn how to deploy with PowerShell and Octopus Deploy, work with NuGet packages, handle unexpected changes in your production database (database drift), test your changes with dry run releases, add review and rollback steps, check your deployments have worked, and how to fix things if your deployment fails. Find a workshop near you.

2015-05-01

6,632 reads

External Article

CONCAT and STUFF Functions in SQL Server 2012

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.

2015-05-01

9,908 reads

External Article

Microservices in Promise and Practice

Are microservices the cure for the ague of monolithic applications, or do they bring their own problems with them that monolithic architectures have circumvented? Are they capable of delivering applications that are easier to maintain and develop? How can they avoid the failings of service-oriented architectures? Once more, Robert Sheldon gets to the heart of the technical issues.

2015-04-30

7,853 reads

External Article

Automated database deployment workshop: London, UK

Join Redgate on May 20th for a 1-day public workshop in London. This event is for anyone who’s interested in automated deployments for SQL Server databases. You'll learn how to: Deploy databases using Redgate's DLM tools; Assess the different requirements of production and non-production deployments, and; Handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.

2015-04-29

5,744 reads

External Article

Disaster Recovery and Big Data

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?

2015-04-29

9,397 reads

External Article

Survey on SQL Server Monitoring

If looking after the health of SQL Server is part of your responsibility, Redgate would love to hear your views on monitoring server health through this 10 minute survey. Complete the survey by May 15th to be in with the chance to win one of three $50 Amazon vouchers.

2015-04-28

7,309 reads

Blogs

Advice I Like: Rewards from Work

By

The greatest rewards come from working on something that nobody has words for. If...

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

By

Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...

Why your data still can’t answer a simple question 

By

Every organization I talk to has the same problem dressed up in different clothes....

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

By Terry Jago

Comments posted to this topic are about the item The day-to-day pressures of a...

Don't Panic

By Grant Fritchey

Comments posted to this topic are about the item Don't Panic

Creating a Simple and Flexible Random Password Generator in SQL Server

By john.martin

Comments posted to this topic are about the item Creating a Simple and Flexible...

Visit the forum

Question of the Day

Identities and Sequences IV

When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?

See possible answers