SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance...
IDERA
Announcing the Release of SQL Defrag Manager 3.7
We’re excited to announce the release of SQL Defrag Manager 3.7 SQL Defrag Manager is an industry leading automated performance solution that...
Lessons Learned From 3 Years in the Trenches with AWS
Since the time of our founding, IDERA has been using Amazon Web Services (AWS). It was critical to us to use cloud technologies to build our...
Making Time Using Temporal Data
SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what...
Normalization Heuristics
Heuristics and normalization are the goals of all databases. Heuristics refers to a trial-and-error method of problem-solving used when an...
All Skewed Up
Data can be skewed by its nature. How can you tell if you have skewed data in your database? And if you do, how do you handle it when writing...
Relational Division
Dr. Codd’s original relational algebra had eight basic operations. Since relational database management systems are based on set theory, the...
How can you handle the complexities of analytics for big data for healthcare?
Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...
What are the real benefits of database automation?
Many of the administrative tasks required to keep databases operating efficiently need to be performed regularly. While in some respects, these...
What do you need to consider when moving databases out of the cloud during cloud repatriation?
The promise inherent in new paradigms can often be the impetus for making major decisions in the business world. Companies want to take advantage of...
Is your organization ready for the Internet of Things (IoT)?
The Internet of Things (IoT) is the term used to describe the connection of network-capable devices to the Internet and other connected devices. The...
Learn about advanced database performance tuning for SQL Server and Azure SQL Database.
The roles of database professionals are always evolving. However, their tuning skills should remain sharp. Tuning proficiency is still one of the...
IDERA Newsletter August 2020 (Database Administrator edition)
Product Release SQL Diagnostic Manager for SQL Server 10.6 We are delighted to announce that the latest release of SQL Diagnostic Manager is...
IDERA Newsletter August 2020 (Database Developer edition)
Product Release New! Aqua Data Studio 20.6 We are delighted to announce that the latest release of Aqua Data Studio is now available....
How do you ensure the security of personally identifiable information (PII) within U.S. federal government agencies?
Safeguarding personally identifiable information (PII) in the government's possession and preventing incidents and breaches are essential to...
How can you better manage a large number of SQL Server agent jobs?
Managing a large number of SQL Server agent jobs across a large enterprise environment can be difficult and frustrating. Database administrators are...
How can you properly set up permissions and security?
Being in the computer industry is one of the most challenging things anyone can get into. When upgrading one’s knowledge to keep the data...
What is big data and what are its benefits for your organization?
The term big data is familiar to anyone with even a passing interest in the world of information technology (IT). Big data is not a new concept....
What are best practices for security practices for SQL Server?
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...
How can you achieve predictable business intelligence (BI) performance with unpredictable queries?
SQL Server database administration is difficult; queries and indexes require tuning in response to application changes. For many database...
What are the complications of cybersecurity in the cloud?
Cloud computing services offer many advantages for companies or organizations that make use of them. There are often financial incentives involved...
Why will your SQL Server service not start?
The executable process that is the SQL Server Database Engine is called the Database Engine service. The Database Engine service is an executable...
What are the top cluster setup mistakes for SQL Server?
Windows Failover Clustering can keep your SQL Server databases online and your customers happy when hardware or operating system problems strike....
How can you prevent SQL Server intrusions?
Understanding how SQL Server can be infiltrated is the key to understanding how to prevent intrusions. The consequences for inadequate permissions...