Attack surface management (ASM) is a growing focus for security teams and many C-Level executives with a stake in data management and security such...
![How Attack Surface Management Enhances Database Security](https://blog.idera.com/wp-content/uploads/2022/07/Pic-for-SQL-Secure-052421-2-1080x675.jpg)
Attack surface management (ASM) is a growing focus for security teams and many C-Level executives with a stake in data management and security such...
SQL statement optimization and database performance optimization more broadly, are some of the most important activities for modern database...
Considering the value of data to the modern enterprise, developing a database recovery plan is crucial. The majority of SQL Server database...
Dedicated monitoring solutions for specific platforms can provide enhanced levels of functionality over general-purpose monitors. When...
Ensuring that an enterprise SQL Server environment remains healthy is the responsibility of an organization’s database administrators...
With the right database monitoring solution, organizations are better placed to maintain database performance. Maintaining acceptable...
SQL Server Management Studio capabilities can be supplemented by a range of third-party tools. SQL Server Management Studio (SSMS) is an...
Service level agreements (SLAs) are commonly used to document customer expectations when entering into a contract with an information technology...
Bare metal to cloud hosted virtual machines Non-Uniform Memory Access (NUMA) is a four-letter word in every sense, well beyond simply the number of...
Through better data lake management, organizations can prevent highly disorganized data lakes from becoming data swamps. Data lakes offer...
Organizations are finding that the most effective way to use public cloud resources is by employing a hybrid cloud model. Team productivity and...
Increasingly, organizations are evaluating the benefits of consolidating relational database monitoring tools. When organizations grow, their...
Perhaps you just read the title and thought, “Disable indexes…say what?” Stay with me here, and I'll show you how this...
For data-driven organizations, the benefits of software vendor consolidation for database tools can provide a competitive edge. Vendor...
Server performance monitoring is a practice designed to maintain high levels of database performance and availability. It allows organizations...
For data-driven organizations, there are many benefits of what-if analysis to take advantage of. A method of evaluating the outcome of certain...
Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with...
SQL Server database index fragmentation is a problem faced by many database administrators (DBAs). It is an issue that can seriously impact database...
Introduction During a recent SQL Server Performance Tuning consultation, I was asked a fascinating question by a Senior DBA working with me from the...
A career as a database administrator (DBA) should appeal to individuals interested in a job that involves a diverse range of duties and technical...
Do you like hammering nails with screwdrivers? Me neither, but all too often we take this kind of approach when writing our SQL queries. We use the...
Many different types of malware are floating around out there. Some of the variants are purely destructive and are designed to simply delete data....
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Introduction I have now warned several times against the mindset that suggests indexing is a silver bullet for SQL Server performance. In the...