Recently I was called into a shop that had a 4 terabyte database, who claimed they didn’t have anywhere near that much data. Upon investigation, they were correct. They had about 100 gig of data, and about 3.9 T of indexes. Is this too much? Well, in order to make that kind of judgement call […]
Scaling refers to increasing a company’s computing resources to manage the exponential growth of work. Simply put, it is the ability of a database to expand the output as load increases. Under heavy loads, the database can slow or even collapse, crippling business operations Scaling the database can be extremely challenging and demands a far […]
Like all previous versions, Microsoft SQL Server 2019 is packed with new features and capabilities. Let’s look at some of the most helpful features for database management systems (DBMS). Indexing One of the new capabilities is related to indexing. If indexing goes wrong, SQL Server 2019 gives DBAs the tools to deal with such situations. […]
Database failure could turn into an ordeal for CTOs and IT Managers. Making sure that database systems operate efficiently is a core requirement of modern IT management. Several tools can help database administrators monitor, maintain, and improve the performance of databases. But before considering the need for database performance software, it’s essential first to understand […]
According to techopedia.com, database activity monitoring (DAM) is a fairly established technology, existing over a decade, which is in charge of observing, identifying, and reporting a database’s activities. DAM tools use real-time security technology to provides alerts and reports to analyze configured activities independently. These tools also help detect irregular activities, whether internal or external, […]
Database auditing refers to tracking the use of records and authority. When auditing a database, each operation is monitored and logged to an audit trail, including when or which information on database object or data record that was used. Nonetheless, not all audit logs have the same value to the auditors, as they require logs […]
A data breach is a severe issue, and determining whether or not your business has been breached is one of the toughest tasks your company can face. Even though the likelihood is high, you can never really tell if your business is going to be hacked. In fact, 62% of small and medium-sized companies have […]
One of the most challenging tasks of the network administrator is to do network capacity planning. Capacity planning is a process that involves the correct sizing of all the links, equipment, and resources of a network, including permissions, software, and the people needed to operate and generate this network to support the essential business activities […]
Database Reports are created from data visualized for analysis, data discovery, and decision-making, and contains useful data for decision-making and analysis. Most business applications come with a built-in reporting tool, which is a front-end interface that calls back-end database queries. In order to extract data, a query should be run with several tools that call […]
A database view is a subset of a database that is based on a query that runs on one or more database tables. Database views are saved in the database as named queries and can be used to save complete queries that are frequently used. Static and Dynamic Views There are two types of database […]