fortified-data-logo
Schedule a Consultation
Contact Us

Category: Technical

SQL Server Database Ownership: A Complete DBA SQL Server Guide for 2019 and Beyond

Managing database ownership is a critical task for any database administrator (DBA), especially in enterprise environments spanning multiple versions of SQL Server, including SQL Server 2019. This SQL Server guide is designed to help you not only understand but also effectively query, audit, and optimize database ownership, including how to get all databases and owners […]

How to Build a Proactive Database Health Strategy

Database performance and reliability are critical to business success. Even if you are not currently ready to engage in database management, having a proactive database health strategy is something that is key for company growth. Downtime, slow queries, or security breaches can cost companies significant time and money. But a proactive database health strategy can help you […]

Saving client $800,000 during migration to Amazon RDS: Part 2 

B In our previous post, we shared an exciting success story about migrating a client’s SQL Server environment from Amazon EC2 to Amazon RDS. Migrating over 600 databases presented a significant challenge, and while AWS Database Migration Service (DMS) was initially considered, technical roadblocks led us to take a different approach. By leveraging a backup/restore […]

Demystifying Data Governance: Practical Information for Technical Teams

Organizations are increasingly recognizing the importance of robust data governance to ensure data quality, security, and usability throughout its lifecycle. Despite its apparent simplicity, many organizations struggle to implement effective data governance strategies into their business processes. What is Data Governance? If you look up the term in Wikipedia, it states, “Data management principles that […]

Configure PostgreSQL Data Sources with Prometheus Setup on Windows Server

Database monitoring is a cornerstone of maintaining high-performing and reliable systems. For PostgreSQL databases, combining Prometheus with Postgres Exporter creates a powerful monitoring solution. This guide provides detailed instructions on setting up PostgreSQL as a data source in Prometheus on a Windows server, with configurations using auth_modules or Windows environment variables. The goal is to […]

Database Security: What Is It & How to Keep Your Database Secure

Databases are the backbone of virtually every organization, storing vast amounts of sensitive information ranging from customer data to proprietary business insights. As the volume and value of data continues to grow, so does the importance of safeguarding these critical assets. Database security has become a one of the biggest concerns for businesses, governments, and […]

Database Subsetting: Optimizing Application Testing

In today’s fast-paced digital world, quality assurance and efficient testing methodologies are crucial elements of any successful software development project. A cornerstone technique for developers and database administrators (DBAs) alike is database subsetting. This strategy not only minimizes the overhead of testing environments but also preserves the quality and integrity of the testing process. What […]

Embracing Efficiency and Creativity in the Modern Development Era

Remember the good old days when we had to code on ancient 386 or 486 desktops? Those machines had a mere 1 CPU and a paltry 128MB of memory. It’s fascinating to reflect on how far we’ve come. Nowadays, each developer is equipped with a shiny new laptop boasting 4 to 8 vCPUs, 8GB or […]

Ways Business Intelligence Consulting Can Grow Your Business

Today’s business climate is fast-paced and competitive. Data has become a valuable asset for businesses of all sizes and it is essential for success. Data is consistently growing at exponential rates, and many businesses are not fully tapping into the power of all their data. It can be overwhelming for businesses to leverage each piece […]