Latest Posts

  • Benefits of SQL Diagnostic Manager for database administrators

    As a database administrator, monitoring database systems for performance, corruption, and data issues is an ongoing task. It is also an overwhelming task depending on how large the database environment is and the number of resources there are to mana...
  • Improve your recovery for SQL Server backup

    Not having a good recovery process One big part of your backup process needs to include the recovery procedures. You should have a rehearsed recovery plan, so when you need to recover any of your databases, you know the exact steps to follow. Also, k...
  • Benefits of SQL Diagnostic Manager for developers

    Development is a big undertaking and most of the time it focuses on making sure all the features are in place and working. Once this is done, tuning for performance often occurs. But in order to make adjustments, developers need data to understand wh...
  • Trade-off between database security and database performance

    One can improve how secure databases are. However, that often degrades how well the database performs. The cost increases to improve database security while maintaining database performance. The trade-off comprises three axes: performance, security, ...
  • Database auditing essentials: Track who did what to which data when

    Stricter governmental and industry regulation coupled with the need for improving how secure the sensitive corporate data is has driven up the need to track who is accessing data in corporate databases. Organizations must be ever-vigilant to monitor ...
  • Adopt a compliance and auditing mindset

    It is easy and all too common to see the auditing team as adversaries. All the information they want takes time to gather. All the rules and procedures they want added just slow things down. And far too often, it feels like we are trying to pass the ...
  • Meet security benchmarks and compliance with SQL Server

    In the current IT landscape, we face meeting an ever-increasing number of laws, regulations, and industry standards. The good news is that most of these different requirements overlap with each other and we can configure our SQL Servers in accordance...
  • Improve your protection for SQL Server backup

    Not protecting physical backups You should think about the value of the data or the consequences of it getting into the wrong hands since a full database backup contains all data in your database. You will want to make sure you always protect this da...
  • Solutions to common methods of SQL Server intrusion

    To understand how malicious actors can infiltrate SQL Server is the key to understanding how to prevent intrusions. The consequences for inadequate permissions are tremendous. Organizations could incur data breaches, fines, loss of customers, a decre...
  • SQL Server security best practices

    There are several examples where data theft has brought organizations to a halt or resulted in a bad press that will leave a tarnished image. For example, in 2017, Equifax disclosed how malicious actors exposed the personal information of over 145 mi...
  • SQL Server security threats are closer than you think

    Today, business is about data. Database systems and the elements they store are the most valuable assets in any enterprise. Not only are business executives and Information Technology leaders responsible for doing what is right to protect the best in...
  • Top 5 SQL Server cluster setup mistakes

    Windows Server Failover Clustering (WSFC) provides infrastructure features that support the high-availability and disaster recovery scenarios of hosted server applications such as Microsoft SQL Server. If a cluster node or service fails, automaticall...
  • We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.2

    ER/Studio 19.2 delivers a whole new approach to modelling hierarchical structures such as document-based NoSQL platforms and file formats, with support for MongoDB and JSON instance and schema files. This allows ER/Studio clients to extend their ente...
  • Demystify tempdb performance and manageability

    Microsoft SQL Server stores a significant amount of data in the tempdb system database. Consequently, tempdb can fill up quickly when disk space is low, or the maximum size for database growth is small. Also, specific workloads may cause excessive sp...
  • Improve your planning for SQL Server backups

    Not understanding recovery needs The whole point of creating backups is to retrieve data in case data is lost or there is a failure. But to set up the proper backup and recovery plan, you need to understand what needs to be recovered to determine if ...
  • Learn about index fragmentation to improve SQL Server performance

    As the data in the database tables of Microsoft SQL Server changes, their indexes change. Over time these indexes become fragmented so that ordered data retrieval becomes less efficient. Consequently, the fragmentation adversely affects the performan...
  • How to become a database administrator for SQL Server

    Database administrators need to handle all facets of managing Microsoft SQL Server ranging from installation and patching to creating databases to managing permissions that allow users to use the databases. However, more than anything, they are respo...
  • Virtual machine snapshots versus database backups

    Virtual Machine Snapshots Virtual machines provide exciting possibilities concerning backup, recovery, and cloning of databases. Convenient mechanisms are available for obtaining consistent snapshots of data volumes in virtual machines. Correctly imp...
  • Five important features of SQL Diagnostic Manager

    SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for SQL Server. It proactively notifies of health, performance, and availability problems via a desktop console, a web console add-on, and mobile device...
  • Quickly deliver relevant data to the right people to improve DevOps

    Challenge As the number of projects for developing applications increases, organizations struggle with quality assurance, release management, and infrastructure support. Provisioning an instance of a production database for a development team can tak...
  • Top SQL Server backup mistakes and how to avoid them

    Backing up SQL Server databases is one of the most important tasks DBAs perform in their SQL Server environments every day. The backup process is so important it often requires well-defined processes, checklists, and multiple database administrators ...
  • How to monitor Always On availability groups

    Always On availability groups are part of an integrated solution with the goal of achieving the highest level of data availability and disaster recovery for organizations. Availability groups grant database administrators the ability to automatically...
  • How to monitor tempdb databases

    Introduction The tempdb system database is a workspace used to hold temporary user objects, results created through queries and sorts, and other objects created by the SQL Server Database Engine. Because of the significant amount of data stored ...
  • Deliver data-driven capabilities with data modeling

    Werner Enterprises is a transportation and logistics leader with more than 8,000 trucks, 24,000 trailers and nearly 13,000 employees. Today, 65 years since the company was founded, it is an asset-based logistics provider and one of the five largest t...