PageBLOGS | Data Awareness Programme |

SQL Server Memory Issue

Every one running SQL Server has always had the same issue of memory. Whatever the extra memory is given to windows, it is all eaten by the SQL Server alone. No matter what the process is going on, the memory takes much resources for all related to SQL Server. How can we control the memory issue. Well there are some possibilities from SQL Server that we can restrict the server to occupy the server memory.

–To check for the existing memory usage

use master

EXEC sp_configure ‘max server memory (MB)’

By default the server won’t display the advance options to enable this service. So follow the steps below to view the memory usage.

–To display advance option

USE master

EXEC sp_configure ‘show advanced options’, 1 RECONFIGURE WITH OVERRIDE

After this you can run the below query to see the usage.

use master

EXEC sp_configure ‘max server memory (MB)’

Then use this to change the server memory.

–To change the maximum server memory

USE master

EXEC sp_configure ‘max server memory (MB)’, 6144 RECONFIGURE WITH OVERRIDE

Then again you can check the usage using the query which we have see earlier.

ByDr. SubraMANI Paramasivam

First Data Awareness Programme at Kadaladi Govt. Arts & Science College

This is the first Data Awareness Programme conducted in Kadaladi Government Arts & Science College in Ramanathapuram, which is based in Southern India on 14/04/2014. This programme was uniquely designed to deliver the importance of day to day data, that helped even a layman to better understand and analyse to help his/her life on a day to day basis. This program was mainly targeted college students, teachers & parents.

This awareness programme, includes any data related to personal, individual, education & social by Your SQL Man UK Ltd and was successfully delivered, by its CEO, Dr. Subramani Paramasivam and his team members. This awareness programme was first of its kind and helped school students, teachers in this very remote village Kadaladi.

Your SQL Man UK Ltd is a data based service company which is much passionate about Data Consultancy, Training, Services & Support. This Data Awareness Programme targets every individual, no matter whatever their industry, education, status is about, but this program definitely delivered the awareness required to better make every individual to realize, how effective the day to day data is and how they can convert and use easy to use tools to better analyse their information and make better decisions.

The audience were unbelievably surprised with the level of information provided about data and how to learn more about data and analyse and help themselves and their surroundings including friends, family, relations, and local people in and around. The attendees were amazed with the level of information that was provided for about 8 hours with easy to understand slides & related videos. Dr. Subramani Paramasivam who is also a Principal Consultant and Trainer, travels around the world to deliver, high quality training and consultancy to corporate clients and participates in worldwide technical events and decided to deliver the same International Standard for this Awareness Programme.

This awareness also included the introduction of Microsoft products, that will better help their day to day life and enlightened the opportunities provided by Microsoft for students. Unbelievably the school students were not aware of Microsoft and this became a good opportunity for Your SQL Man UK Ltd to better explain about the Microsoft products, certifications and awards at student level like MTA (Microsoft Technology Associate) & MSP (Microsoft Student Partner).

This program was delivered with fun and been given gifts to encourage the students to answer the Microsoft & Data related questions. Students & teachers bagged many gift items by answering the questions and left with hand full of gift items. The college principal and the school Head Master thanked for the enlightment that was brought into the students life which was the first kind of a program they attended.

Some of the areas within this programme were delivered with fun to ensure the attendees have better understanding of data. So used some of the movie entertainment video clips which speaks about realistic data, facts and gave enough props and examples to feed their mind with better understanding.

Speaking to the CEO of the company, Dr.Subramani Paramasivam mentioned that this was his dream to get the awareness of education, social through data and been working on it for a while and brought this Data Revolution a successful one. He also added that, many rural areas in and around the world are still not aware of the effectiveness of IT in particular Microsoft student partnership & certifications programme and using this awareness programme opportunity to enlighten them.

This is definitely a data revolution which can make every person even in rural areas to get educated and help others.

Kadaladi Arts & Science College Attendees with Teachers & Volunteers

Kadaladi Arts & Science College Teachers & Volunteers with Your SQL Man Ltd Team members

Attendees of the Data Awareness Programme

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Softskill sessions delivered by Your SQL Man Team members

Student Creativity Work during the awareness programme

This awareness programme enabled the students to interact during the sessions, which is also a success to this Awareness Programme.

Speech by one of the teachers

Speech by one of the main Volunteers

Additional appreciation given to students who answered right.

Appreciation given to teacher who provided support for the successful delivery of this DataAP programme.

Appreciation given to main volunteer, who provided support for the successful delivery of this DataAP programme.

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

Participation certificate issued to main Volunteer by Dr.Subramani Paramasivam

ByDr. SubraMANI Paramasivam

Data Awareness Programme at Kadaladi Government School

This Data Awareness Programme conducted in Kadaladi Government School in Ramanathapuram, which is based in Southern India on 15/04/2014. This programme was uniquely designed to deliver the importance of day to day data, that can help school students to better understand, analyse and help his/her school & personal activities on a day to day basis. This program was mainly targeted towards school students (standard 9, 10, 11, 12), teachers & parents no matter whatever their industries were.

Microsoft Products

Fun & Gifts

This program was delivered with fun and been given gifts to encourage the students to answer the Microsoft & Data related questions. Students & teachers bagged many gift items by answering the questions and left with hand full of gift items. The college principal and the school Head Master thanked for the enlightenment that was brought into the students life which was the first kind of a program they attended.

This is definitely a data revolution which can make every person even in rural areas to get educated and help others.