My primary responsibility is to help people with SQL Server Performance Tuning and Optimization, and I believe there are three important challenges any DBA faces. Today we will discuss why I prefer to use Spotlight to identify SQL Server Performance issues and their resolutions.
Oracle to SQL Server Data Migration and Replication – Budget and ROI
My primary job is to help various organizations design scalable architecture which can provide robust performance all the time. I love my job very much when I have complete freedom to make the decisions to build elaborate infrastructure. However, not every time I am allowed to do what I want to do because every CEO and CTO are concerned about one thing – “Budget and ROI (Return of investment).”
Detect and Diagnose SQL Server Performance Issues with Spotlight Cloud
The number one challenge for any DBA with their SQL Server is the performance. Every user wants their applications to run faster. When DBAs and Developers start building an application, it usually runs faster as there is no real workload running over it. Often DBAs and Developers do stress testing with the third party tools or by simulating the workload. However, honestly, when an application goes live, the entire scenario is very much different. It is near impossible to predict the usage pattern and workload distribution in any application once it starts to grow. Today we will discuss how we can detect and diagnose SQL Server Performance Issues with Spotlight Cloud.
Scalability and Availability Challenges and Shareplex Solutions
If you ask any DBA in the world about their wildest dream, they will always say that want to manage a huge database platform which is scalable whenever it needs to and available always. If you are a DBA, you will agree with the statement. Every DBA who is going home after a day-long work only dreams that a) he does not have to wake up mid-night and b) the first task next day is not to worry about the capacity of the server. Let us learn about Scalability and Availability Challenges and Shareplex Solutions.
New Trends and Challenges in Database Administration
In the previous blog posts, we discussed the evolution of the DBA along with the challenges, changes and their upcoming trends. Data is the most critical part of any application. The changing nature of the data always brings new challenges to DBAs. New age DBAs now have to do many different tasks than before. Along with running the system at the most optimal settings, DBAs now have to get their hands dirty with development, DevOps, NoSQL technology as well as help organizations to migrate to the cloud.
The Evolution of the DBA – Challenges, Changes and Upcoming Trends
What scares the DBA most besides the Text at midnight with word downtime? Well, the answer to this question is pretty simple – The changing work profile for DBA. I am fortunate that during my job as a Data Consultant, I get to visit different organizations across the world and get to meet some finest Data Professionals and Business Leaders. I get the first-hand experience of the evolution of the DBAs in the constant changing and challenging world. It is extremely important for DBAs to get updated with the current trends to stay relevant to their job. Let us see today a quick story of Evolution of the DBA!
Avoiding Database Downtime via Replication – SharePlex
The scariest word for any DBA is – Database Downtime. Every DBA who is going off duty for the day or going away on vacation for a month is always worried about Database Downtime. I totally sympathize with everyone who is constantly worried about their database’s downtime. In the real world, we all know when our database does down, it means that our business is stopped. There is no other analogy we can give.