SQL Diagnostic Manager 10.4 will be available soon and it currently available for our beta customers at...
SQL Diagnostic Manager 10.4 Preview
read more
blog
Methods for Handling Big Data for Healthcare
Healthcare organizations need methods to overcome challenges to achieve the data-driven financial and clinical objectives. Such approaches include...
What has happened with GDPR in the last 9 months?
Largest Fine To Date Google recently made the news with a $57M (50M Euro) fine imposed by the French Regulatory building, CNIL. The case against...
How to Manage Complex Database Environments
Every year, data becomes increasingly critical to the organization. And data becomes even more complicated to manage and keep secure. The growth in...
Properties of Big Data for Healthcare
Healthcare organizations must consider the essential properties of the analytics for big data that when commencing significant projects for...
Handling 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...
Monitor the performance of SQL Server in the hybrid cloud
As organizations migrate their databases to the cloud, database administrators need to consistently manage databases on-premise and in the cloud...
Resolutions for your Data Management Strategy
As 2019 has just begun, it’s a good time to assess what you accomplished last year and what goals to set for the new year. It's also a great...
Using SQL Secure to monitor SQL Instances and Databases running on Azure
As companies migrate more and more applications and data to the cloud using services like Azure and Amazon, it is important to ensure that the SQL...
How to troubleshoot locking problems in SQL Server with Dynamic Management Views
Database professionals are often called upon to investigate performance problems related to locking, but most investigations into locking rarely go...
Precise for Sybase monitoring & performance
Precise for Sybase builds a history of activity showing resource consumers. SQL statements are correlated to stored producers, logins, and...
What to do when the SQL Server service does 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...
Data Proximity for Data Warehousing Performance
Data Warehousing DBAs usually work with huge tables, often possessing hundreds of millions or even billions of rows. And occasionally, these DBAs...
Top metrics to monitor in your MySQL databases
As tables increase in size and more users come online, it becomes increasingly necessary to fine-tune your MySQL database server from time to time....
Business Value Metrics for Data Governance
As data professionals, we recognize and understand the need for data governance, focusing on data quality in particular. We have made some progress...
What are visual SQL tuning diagrams?
SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important...
SQL Performance, Part 4: Additional Considerations
Today’s blog post concludes our four-part look into SQL performance and optimization. Part one introduced and explained relational...
Is GDPR a Grinch?
Most people know that GDPR went into effect in May of 2018. For those of you who don't know, GDPR was put in place to protect people's PII...
Surprises in 2018 and Predictions for 2019
Recently I was asked to contribute my thoughts on what things in database technology were a surprise in 2018 along with what trends and topics would...
What are the top 4 performance makers and breakers for SQL Server?
Successful solutions are successful solely because systems, users, and organizations have come to depend upon them. Such solutions are not...
SQL Performance, Part 3: Multiple Table Access Methods
In part one of our overview of SQL performance we examined relational optimization; part two took a look at query analysis and introduced...
Six SQL Server performance boosters with your existing hardware
Nearly all successful applications can benefit from the performance-driven strategies outlined in this whitepaper. Many of the categories and items...
Why your Always On solution is not always on
Microsoft markets a variety of SQL Server availability technologies under the umbrella term Always On. Always On is a broad term covers many...
SQL Performance, Part 2: Query Analysis and Access Path Formulation
In part one of our overview of SQL performance we examined relational optimization and the things that impact it. In today’s blog post, we...