Ten tips for attracting and retaining DevOps talent
DevOps can help organizations become more agile and responsive to their customers, but it’s only as effective as the individuals who participate on the DevOps teams. Getting the right people in place is paramount to a successful DevOps implementa …
Feature branches and pull requests with Git to manage conflicts
I’ve recently fielded two questions from different customers regarding how to best work as a team committing database changes to Git. While there are a wide variety of branching models which work well for databases with Git — Release Flow, …
Steps for Installing AlwaysOn Availability Groups – SQL 2019
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installin …
Export SQL Server Data to Multiple Excel Worksheets with C#
The post Export SQL Server Data to Multiple Excel Worksheets with C# appeared first on SQLServerCentral.
Optimize SQL Server estate monitoring with Redgate’s SQL Monitor
The post Optimize SQL Server estate monitoring with Redgate’s SQL Monitor appeared first on SQLServerCentral.
Autoparameterized Trivial Queries May Not Get Partition Elimination
How’s that for a niche topic? You’re probably never going to know this, but since I had to figure it out the hard way, I’m writing this down so I don’t forget it: queries that get trivial optimization may not get partition elimi …
Rules in PostgreSQL
We sometimes need to perform a different/alternative actions during database queries. We need it for data protection or data abstraction. The PostgreSQL rule system allows to define an alternative action on insert, update or delete. A rule generates an …
Why you should include the database in your 2021 IT strategy
The post Why you should include the database in your 2021 IT strategy appeared first on SQLServerCentral.
Configure SQL Server Database Mail on Amazon RDS
The post Configure SQL Server Database Mail on Amazon RDS appeared first on SQLServerCentral.
Join us for this year’s final Redgate Summit
The post Join us for this year’s final Redgate Summit appeared first on SQLServerCentral.
How to Execute SSIS Packages from SQL Server Agent
The post How to Execute SSIS Packages from SQL Server Agent appeared first on SQLServerCentral.
Have your say in the 2021 State of Database DevOps survey
The post Have your say in the 2021 State of Database DevOps survey appeared first on SQLServerCentral.
Deep Learning with GPU Acceleration
Deep Learning is the most sought-after field of machine learning today due to its ability to produce amazing, jaw-dropping results. However, it was not always the case, and there was a time around 10 years back when deep learning was not a field consid …
Are your Oracle archived log files much too small?
Have you ever noticed that your archived redo logs can be much smaller than the online redo logs and may display a wild variation in size? This difference is most likely to happen in systems with a very large SGA (system global area), and the underlyin …
Today’s the Last Day of My Black Friday Sale.
Every year, I get an avalanche of emails after the sale is over, going, “I forgot about the sale! I didn’t get my boss’s approval in time!” So here it is, folks: your last day to get in. Here are the special bundles: Level 1: Fu …