Top 10 Concerns Keeping SQL Server DBAs Awake at Night
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Key Insights into Ensuring SQL Server Security with These Practices
There are several examples where data theft has halted businesses or resulted in bad press that will leave a tarnished image. For instance, in 2017, Equifax disclosed that the personal information of over 145 million people was exposed, including social security...
Improve SQL Server Usage Management and Efficiency
If your organization deals with a high volume of customer data, telemetry, or other metrics, it’s likely you'll have some substantial databases to manage. Many organizations start with modest data management requirements and then find that their early database schema...
Get French Holidays
I saw this blog post and I decided to publish this one for France. Here is a PowerShell function that gets all French holidays…
Compliance and Backup Strategy: A Closer Look at the Connection
The Intersection of Compliance and Digital Data Organizations of all sizes and shapes must comply with government and industry regulations. Some regulations are limited to public companies, while others are relevant only to specific verticals. Many regulations cut...
Macros – Using macros to create Data Vault objects
Some years ago, Sultan shared a post regarding Data Vault modeling with ER/Studio. I strongly recommend to read it before this one. The different Data…
Announcing the General Availability of IDERA SQL Compliance Manager 6.1
Introducing IDERA SQL Compliance Manager 6.1: The Latest Release of Our Leading SQL Server Auditing Solution SQL Compliance Manager is the leading SQL Server auditing solution in the industry, SQL Compliance Manager empowers companies to maintain database compliance...
Mastering the Complexities of Analytics for Big Data in Healthcare, Part 2
In Part 1, we discussed the properties of big data and how it affects the data gathered in the healthcare industry. Here we go over methods for handling big data and overcoming challenges to achieve data-driven financial and clinical objectives, starting with...
Announcing the General Availability of IDERA SQL Secure 4.3
We are excited to announce the general availability of IDERA SQL Secure 4.3. IDERA SQL Secure empowers users to identify vulnerabilities in SQL Server configurations and access, establish robust security policies and baselines, and receive alerts for potential risks....
Macros – Sample macros to import Logical and Physical Data Models from Microsoft Visio to ER/Studio Data Architect
Visio can draw charts, plans and diagrams. Some people have used Visio to create their Logical and/or Physical Data Models and they would like to…
Mastering the Complexities of Analytics for Big Data in Healthcare, Part 1
Analytics for big data has rapidly become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions include support for clinical decisions, predictive analytics for big data, management of revenue cycles, measurement of...
Announcing the General Availability of IDERA SQL SAFE Backup 9.2
Introducing IDERA SQL SAFE Backup 9.2: The Latest Release of Our Leading SQL Server Backup Solution IDERA SQL Safe Backup is a comprehensive solution for backing up and recovering SQL Server databases. With IDERA SQL Safe Backup, users can easily schedule and verify...
Migrating SQL Server to Azure SQL Database
Migrating SQL Server to Azure SQL Database provides essential benefits. Such advantages include the following: lower cost by shifting expenses from a capital expenditure model to an operational expenditure model improved security with encryption on by default plus...
Deploy and manage complex Azure environments
The data management professionals of today are finding their landscape changing. They have multiple database platforms to manage and need to control these complex configurations. Do you know how to build automation scripts, especially if you have little scripting...
How to Maintain Security Compliance to Prevent a Costly Breach
As businesses and government organizations shift a growing amount of their operations online, data security has become an increasingly important issue. In 2022, the number of major data breaches only grew. DoorDash experienced a breach that affected 4.9 million...
Visually compare data in MySQL
As with any database, there are many ways to compare the data within a MySQL database. We can compare data for: Accuracy: If we entered the data incorrectly, it will show up in the visual comparison. This can be an easy way to find errors that may have slipped through...
Learn more about database migrations
Many information technology professionals may not recognize it, but the bulk of their work has been and continues to be nothing more than database migrations. In the old days to share files across systems, then to move files into relational databases, then to load...
Monitor top metrics in MySQL databases
How MySQL databases perform can affect your organization. For example, if your site takes too long to load or has too many server errors, it can affect the reputation of your organization reputation and lead to lost transactions. As tables increase in size and more...
Tips for data warehouses and other extensive databases
Whether on-premises or in the cloud, organizations often ask database administrators to create and manage optimal database designs for data warehouses, data lakes, and many other extensive databases using relational database management systems. We will use these...
DBTA 100 2023: The Companies That Matter Most in Data
The need to balance data safety with new data initiatives, deliver business value, and change company culture around data tops this year’s list of data and analytics management challenges. The data landscape continues to increase in size and complexity and is more...
Become a SQL Server Management Studio Hero
The world is full of exciting challenges, and we are constantly running daily, chasing our dreams. Especially in the software ecosystem, it is not about literally our dreams but about the release scheduled in the next couple of months. We are constantly running daily,...