Why is Dedicated Admin Connection a lifeline ? (SQL Server)

The Dedicated Admin Connection is a lifeline you may potentially use if you have a serious performance issue and are
Read More
Why is Dedicated Admin Connection a lifeline ? (SQL Server)

Steps to Success

Steps to success: I always found that planning/organisation is always the key element to succeed. Having short and long-term goals.
Read More
Steps to Success

SQL Server Always Availability Group

Ensure all perquisites are completed prior to commencing, as this blog is only focused on configuration steps. Step 1; On both SQL
Read More
SQL Server Always Availability Group

Enabling & Disabling all SQL Agent Jobs

As a DBA you may sometime be asked to disable all jobs on SQL server due to upgrade etc… Thus, how
Read More
Enabling & Disabling all SQL Agent Jobs

Shrink Shrink! NO Stop! Killing performance!

Non-Technical perspective: Think of your savings jar, example: large coca cola savings jar... if the jar got full you will
Read More
Shrink Shrink! NO Stop! Killing performance!

Turning auto update statistics to False?

Should auto update statistics be turned off, and instead running nightly statistics update job to improve performance? Well let’s discuss on
Read More
Turning auto update statistics to False?

SQL Server DELETE! Does it permanently delete?

With General Data Protection Regulation (GDPR) coming into full force, it’s ever so more important we comply in lines with
Read More
SQL Server DELETE! Does it permanently delete?

Azure IaaS vs PaaS vs SaaS

Curry as a Service (IaaS,PaaS, SaaS) Within the fast pace growth of technology, the word ‘Cloud’ is something we more regularly
Read More
Azure IaaS vs PaaS vs SaaS

PowerShell Basics for SQL Server

Summary PowerShell has a lot to offer with its capabilities as a shell (for doing things) and a scripting language (for
Read More
PowerShell Basics for SQL Server

Virtual Machine Setup

Building Virtual SQL Server Environment Please note this virtual SQL Server environment is created for practice only, the specification of this
Read More
Virtual Machine Setup

Testimonials

Testimonial Five

May I take this opportunity to pass on my praise for Dharam Patel – Dharam has been really efficient and effective with comms to myself and the customer

Anonymous
Service Manager / Anonymous

Testimonial Four

Just wanted to drop you a note with regard to your team, and their work this afternoon.As I have said before, you are one of the best suppliers I have ever dealt with, but it is really refreshing when engineers (Dharam) take the initiative and use a bit of common sense to progress urgent tickets, like performing a partial restore of our DB to get us back up and running asap and just getting on and doing it. It feels from my perspective that your guys understand the impact to our business when these sorts of things happen and do all they can to get things sorted as quickly and efficiently as possible. It not often in the IT world that you get to give good feedback to this level!

Anonymous
IT Manager

Testimonial Three

Dharam has a strong and professional work ethic and is a very capable and DBA who is always ready to step in and help out where required. He has consistently taken a lead on live service issues as well as the integration of databases into the managed service of Node4. Dharam was a popular member of DBA team and always went into his work with great enthusiasm, commitment, and determination. Dharam is a great team player and a pleasure to work with and I would recommend him without hesitation.

Grahame Dyce
Senior Database Consultant / Onomi, Node4 (N4Stack)

Testimonial Two

I have known Dharam for almost three years at Onomi/Node4. During this period, he has demonstrated high-level skills in SQL Server, Oracle, and Couchbase. Dharam is doing an excellent job in his current role and is asset to the Node4 organization. He has excellent written and verbal communications skills, extremely organized, can work independently and is able to effectively multi-task to ensure all project are completed in a timely manner.

Amar Ali
NoSQL/RDBMS Database Consultant / Onomi

Testimonial One

Dharam is a dedicated, diligent and enthusiastic individual, who is not deterred by complexity of any task. Determined to achieve the end goal, he is always keen to learn and develop, whilst progressing towards success. His “can-do” attitude, ability to work on his own or within a team, and communication skills at all levels ensures projects are delivered on time. With his fun-loving personality, Dharam would easily fit in any organisation.

Pankaj Manek
Senior SQL Server Consultant / Onomi

Education/Careers

Latest From Blog

Why is Dedicated Admin Connection a lifeline ? (SQL Server)

Why is Dedicated Admin Connection a lifeline ? (SQL Server)

The Dedicated Admin Connection is a lifeline you may potentially use if you have a serious performance issue and are
Read More
Steps to Success

Steps to Success

Steps to success: I always found that planning/organisation is always the key element to succeed. Having short and long-term goals.
Read More
SQL Server Always Availability Group

SQL Server Always Availability Group

Ensure all perquisites are completed prior to commencing, as this blog is only focused on configuration steps. Step 1; On both SQL
Read More
Enabling & Disabling all SQL Agent Jobs

Enabling & Disabling all SQL Agent Jobs

As a DBA you may sometime be asked to disable all jobs on SQL server due to upgrade etc… Thus, how
Read More
Shrink Shrink! NO Stop! Killing performance!

Shrink Shrink! NO Stop! Killing performance!

Non-Technical perspective: Think of your savings jar, example: large coca cola savings jar... if the jar got full you will
Read More
Turning auto update statistics to False?

Turning auto update statistics to False?

Should auto update statistics be turned off, and instead running nightly statistics update job to improve performance? Well let’s discuss on
Read More
SQL Server DELETE! Does it permanently delete?

SQL Server DELETE! Does it permanently delete?

With General Data Protection Regulation (GDPR) coming into full force, it’s ever so more important we comply in lines with
Read More
Azure IaaS vs PaaS vs SaaS

Azure IaaS vs PaaS vs SaaS

Curry as a Service (IaaS,PaaS, SaaS) Within the fast pace growth of technology, the word ‘Cloud’ is something we more regularly
Read More
PowerShell Basics for SQL Server

PowerShell Basics for SQL Server

Summary PowerShell has a lot to offer with its capabilities as a shell (for doing things) and a scripting language (for
Read More
Virtual Machine Setup

Virtual Machine Setup

Building Virtual SQL Server Environment Please note this virtual SQL Server environment is created for practice only, the specification of this
Read More