We use logshipping as a Disaster Recovery for our production databases to a server in different location. We would need to monitor the synchronisation status of the logshipping secondary databases. We did not like to use the default monitoring job Read more…
I covered about Python basics in my previous post and now lets move on to understand how to do exploratory data analysis using Python. As mentioned in my earlier post, the power of Python comes from its libraries. Below I Read more…
Python is an open source multipurpose programming language used for many different applications. There is a huge community backing which made this open source language very popular. The power of its capabilities comes from the number of libraries it supports Read more…
How often have we not encountered this situation as a DBA. Troubleshooting performance problems is often the critical challenge a DBA has to face. When you see High CPU condition in your environment, you would need a to-do action checklist Read more…
Extended events have been around since SQL Server 2008 version. This was created by Microsoft as a light weight way of tracking and monitoring SQL Server. As DBA, I was traditionally used to using SQL profiler and tracing for performance Read more…
As SQL Server Database Administrator or Developer you might have noticed different types of error messages logged in SQL Server Error Log. Usually most of the SQL errors are in the below format: Error: <number> : Severity: <number>; State: <number> Read more…
Continuation of Part-2 Mean: The average or central value Mean Absolute Error: As the name says it is Mean of Absolute Error. Absolute Error is the difference between forecasted value and actual value. So MAE is the mean of those Read more…
Continuation from Part-1 Part-2: Decision trees: These are type of machine learning algorithms which is very good tool to choose between several courses of actions. It is choosing by expected outcomes from the given data. They are shown as inverted trees Read more…
There are some commonly used terms in the learning path of Data Science. I have made my list of few such terms and try to briefly explain them in as simply terms as possible. Do not take them as definitions Read more…
Splitting single large data file into multiple files I had come across a situation to split one large data file in one filegroup into multiple data files. We had a data file of one database which is 1.8TB. Similarly, we Read more…