As part of a recent Redgate Summit which focused on data modernization, Grant Fritchey interviewed Pramod Sadalage, a Director at Thoughtworks. They discussed data and DevOps, and the typical challenges organizations come across in their digital transformation efforts. Grant Fritchey shares this Q&A.
The post What are the biggest challenges organizations face in their digital transformation efforts? appeared first on SQLServerCentral.

Database DevOps has come of age. Now seen as a key technical practice which can contribute to the successful implementation of DevOps, it stops the database being a bottleneck and makes releases faster and easier.
To implement it successfully, there are ten areas which teams should focus on.
The post The ten habits for highly successful compliant database DevOps appeared first on SQLServerCentral.

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Sign up to receive the latest updates in your inbox.
The post PASS Data Community Summit 2023 registrations are open! appeared first on SQLServerCentral.

For many businesses, database performance and availability are crucial elements. A database crash or a lengthy transaction can cause a lot of downtime and have a negative effect on business operations. However, with the introduction of Accelerated Database Recovery (ADR), Microsoft SQL Server has added a potent new feature that greatly enhances database availability and […]
The post Improving SQL Server Performance and Availability with Accelerated Database Recovery appeared first on SQLServerCentral.

The CASE expression is one of the most valuable tools in your T-SQL toolbox. I use it in almost every query I write. However, there isn't a direct equivalent of CASE in DAX. Since it's a different language entirely, I don't expect it. As my grandmother used to say, I am not surprised, just disappointed. If you don't know, DAX (Data Analysis Expressions) is a language for creating custom calculations and aggregations in Power Pivot, Power BI, and other data analysis tools. Two functions in DAX come close to replicating the functionality but come with limitations. Which one of these functions should you use? Please stay tuned.
The post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral.

Database monitoring should be as simple as possible, and yet still allow the users to drill into sufficient detail to be able to recommend a fix to the problem. The trick is to adopt a layered or 'tiered' approach.
The post Improving the Quality of your Database Monitoring appeared first on SQLServerCentral.

When working with Snowflake, it is important to understand the different types of tables available and when to use each one. In this tutorial, we will compare Snowflake temporary and transient tables, highlight their similarities and differences, and provide examples of when to use each type of table.
The post Snowflake Temporary Tables vs. Transient Tables appeared first on SQLServerCentral.

Learn how you can shrink your transaction log files serially, one by one.
The post Shrink Database Log Files One by One appeared first on SQLServerCentral.