Author Archives: Dr. SubraMANI Paramasivam

ByDr. SubraMANI Paramasivam

Full Database Backup

This post is to cover some of the backup options that we have. You can try this in your local system and for this demo, I am using AdventureWorksDW2008R2 database. You can download this from this link.

In the below image, you can see the database backup options that are available by navigating to the Database and then right click and choose Tasks => Back Up…

FullDatabaseBackup_01

Following this, a new pop-up appears which gives much options to choose the available backup options. In here, I have highlighted “Backup type” and you see “Full” is selected. If you click on the other options you will then see options for other types of backups to be chosen.

FullDatabaseBackup_02

Then I have highlighted “Backup set”, which means I am giving a name for it. And then at last choosing the “Destination”, where the backup file will be placed. In here you also have options to Add new location, remove the provided default location.

You can also use below T-SQL Scripts to do the same manually instead of using GUI screens.

 

–Syntax for Full Database Backup
BACKUP DATABASE databasename
TO backup_device [ ,…n ] –Device and Location
[ WITH with_options [ ,…o ] ] ;

–Simple Script to take Full Database Backup
BACKUP DATABASE [AdventureWorksDW2008R2]
TO DISK = ‘F:\AdventureBackup.bak’
GO

–Craete a Full database backup by using WITH FORMAT to overwrite any exisiting backups and Create a new media set
BACKUP DATABASE [AdventureWorksDW2008R2]
TO DISK = ‘F:\\AdventureWorksSimpleRM.bak’
WITH FORMAT;
GO

Happy going.

ByDr. SubraMANI Paramasivam

Data Awareness Programme @ Stamford College

Following the success of Data Awareness Programmes conducted in India, took a huge step in conducting the same program in Kuala Lumpur – Malaysia at Stamford College on 21/04/2014.

This included a mixed variety of Students from various degrees with in Information Technology. This programme provided the analytical solution based on the data collected within Malaysia. This helped better understand the students to learn and visualize based on their already known information.

This session also included students, teachers & non-teaching staff to enlighten data & bring awareness related to personal, individual, education & social and this was again successfully delivered, by Dr. Subramani Paramasivam and his Malaysian based team members.

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.

This programme was specifically targetted to the attendees by providing more information about Microsoft SQL Server Products, Microsoft Releases, Microsoft SQL Server Editions, Database Development, Database Administration and other Microsoft related database & BI related products.

The demos were mainly based on Power Map, Power Pivot, Power BI and the visualization technology on power map really amazed every single attendee in the auditorium.

This was also 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).

Students were very much looking forward for further awareness programmes in Malaysia and thrilled.

Stamford College Attendees

Stamford College Attendees

Stamford College Attendees

Stamford College Attendees

Stamford College Attendees

Stamford College Attendees

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Introduction by Dr.Janet Lourds Rani

Introduction by Dr.Janet Lourds Rani

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Data Awareness Programme Session delivery by Dr.Subramani Paramasivam

Speech by Dr.Janet Lourds Rani

Speech by Dr.Janet Lourds Rani

Speech by Dr.Janet Lourds Rani

Speech by Dr.Janet Lourds Rani

A slide in Data Awareness Programme sponsored by Your SQL Man Ltd

A slide in Data Awareness Programme sponsored by Your SQL Man Ltd

Sponsor Gift

Sponsor Gift

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

Interaction by Stamford College Students at Data Awareness Programme.

YSM_Banner_01

YSM Malaysia team in Stamford College

YSM Malaysia team in Stamford College

YSM Malaysia team in Stamford College

YSM Malaysia team in Stamford College

A Creativity session for one of the Students at Stamford College

A Creativity session for one of the Students at Stamford College

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Student doing HANDS-ON lab Session

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Stamford College Students enroling for Data Awareness Programme

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Catchup with Dr.Janet Lourds Rani with Dr.Subramani Paramasivam and YSM Malaysia Team

Catchup with Dr.Janet Lourds Rani with Dr.Subramani Paramasivam and YSM Malaysia Team

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Dr. Subramani Paramasivam and Dr.Janet Lourds Rani

Clarifications provided to Stamford College Student

Clarifications provided to Stamford College Student

Clarifications provided to Stamford College Student

Clarifications provided to Stamford College Student

Attendees

Attendees

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Student by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

ByDr. SubraMANI Paramasivam

Volunteer

Being a DataAP volunteer, you will be proud in serving every community people, who really need your time and expertise. A BIG THANK YOU for all volunteers who volunteered in the past and for all current and future volunteers.

Get to know more about volunteering by sending an email to info@dataap.org

DataAP Fundraising Volunteers:

DataAP fundraising volunteers, are the key people, who make Data Awareness Programme a successful one.

“You don’t just raise money, but improve the quality of every individual on this earth”.

Volunteer your time:

Your esteemed time is the indestructible investment that any individual can do. Join your hands with us to help delivering the Data Awareness Programme a successful one.

Volunteer by giving a Speech:

Your can utilize this opportunity to start speaking in events and improve your communication & delivery skills. Also you receive a recognition of “DataAP Speaker”.

ByDr. SubraMANI Paramasivam

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 Attendees with Teachers & Volunteers

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

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

Attendees of the Data Awareness Programme

Attendees of the Data Awareness Programme

Attendees of the Data Awareness Programme

Attendees of the Data Awareness Programme

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

Data Awareness Programme session delivery by Dr.Subramani Paramasivam

 

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

Softskill sessions delivered by Your SQL Man Team members

 

Student Creativity Work during the awareness programme

Student Creativity Work during the awareness programme

Student Creativity Work during the awareness programme

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

This awareness programme enabled the students to interact during the sessions, which is also a success to this 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 teachers

Speech by one of the teachers

Speech by one of the teachers

Speech by one of the main Volunteers

Speech by one of the main Volunteers

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

Additional appreciation given to students who answered right.

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 teacher who provided support for the successful delivery of this DataAP programme.

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

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.

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 Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Students by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

Participation certificate issued to Teacher by Dr.Subramani Paramasivam

Participation certificate issued to main Volunteer 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.

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.

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.

Microsoft Products

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).

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.

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.

Your SQL Man Ltd team members with the attendees of School students, Volunteers, Head Master & Teachers.

Your SQL Man Ltd team members with the attendees of School students, Head master & teachers.

 

 

 

 

 

 

 

 

 

 

Session_Delivery_01

Delivery of Data Awareness Programme by Dr.SubraMANI PARAMASIVAM

Session_Delivery_02

Delivery of Data Awareness Programme by Dr.SubraMANI PARAMASIVAM

Session_Delivery_03

Delivery of Data Awareness Programme by Dr.SubraMANI PARAMASIVAM

Session_Delivery_04

Delivery of Data Awareness Programme by Dr.SubraMANI PARAMASIVAM

Session_Delivery_06

Delivery of Data Awareness Programme by Dr.SubraMANI PARAMASIVAM

Session_Delivery_05

Delivery of Data Awareness Programme by Dr.SubraMANI PARAMASIVAM

Session_Delivery_07

Delivery of Data Awareness Programme by Dr.SubraMANI PARAMASIVAM

Session_Delivery_08

Delivery of Data Awareness Programme by Dr.SubraMANI PARAMASIVAM

 

 

 

 

 

 

 

Audience_01

Kadaladi Government School Audience with Volunteers, Teachers & Head Master

Audience_02

Kadaladi Government School Audience

Audience_03

Kadaladi Government School Audience with Volunteers, Teachers & Head Master

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Softskill session by Your SQL Man Ltd Team Members

Softskill session by Your SQL Man Ltd Team Members

 

 

 

 

 

 

 

 

 

 

 

 

Speech by Head Master Mr.Subhanandha Raj

Speech by Head Master Mr.Subhanandha Raj

Speech by Head Master Mr.Subhanandha Raj

Speech by Head Master Mr.Subhanandha Raj

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

Best Performer Gift during the session questionnaire.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Participation Certificates for Teachers at Kadaladi School

Participation Certificates for Teachers at Kadaladi School

Participation Certificates for Teachers at Kadaladi School

Participation Certificates for Teachers at Kadaladi School

 

 

 

 

 

 

 

 

 

 

 

 

 

 

A creative & interactive practical session with Advanced computing to Kadaladi School Student.

A creative & interactive practical session with Advanced computing to Kadaladi School Student.

A creative & interactive practical session with Advanced computing to Kadaladi School Student.

A creative & interactive practical session with Advanced computing to Kadaladi School Student.

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Interaction by Students

Speech by one of the main Volunteers

Speech by one of the main Volunteers

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Appreciation_Volunteer_HM_02

Appreciation for Head Master Mr.Subhanandha Raj’s contribution & support

Appreciation_Volunteer_HM_01

Appreciation for Head Master Mr.Subhanandha Raj’s contribution & support

Appreciation_Volunteer_12

Appreciation for one of the Organizers at Kadaladi Village based in Southern INDIA.

Appreciation_Volunteer_05

Appreciation for the main Volunteer

Appreciation_Volunteer_04

Appreciation for the Kadaladi Government School Teacher

Appreciation_Volunteer_03

Appreciation for the Kadaladi Government School Teacher

Appreciation_Volunteer_02

Appreciation for the Kadaladi Government School Teacher

Appreciation

Appreciation for the Kadaladi Government School Teacher

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

Participation Certificates for Kadaladi School Students

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

A BIG THANK YOU FOR SCROLLING DOWN ALL THE WAY DOWN TO SEE THE SUCCESS OF DATA AWARENESS PROGRAMME AT KADALADI SCHOOL IN SOUTHERN INDIA.

 

 

ByDr. SubraMANI Paramasivam

Overview of Microsoft BI Components SQL 2000 Vs 2005 – I know pretty old!

The following table presents an overview of the components of a business intelligence system, and the corresponding Microsoft SQL Server 2000 and SQL Server 2005 components.

Component SQL Server 2000 SQL Server 2005
Extract, transformation, and load Data Transformation Services (DTS) SQL Server 2005 Integration Services
Relational data warehouse SQL Server 2000 relational database SQL Server 2005 relational database
Multidimensional database SQL Server 2000 Analysis Services SQL Server 2005 Analysis Services
Data mining SQL Server 2000 Analysis Services SQL Server 2005 Analysis Services
Managed reporting SQL Server 2000 Reporting Services SQL Server 2005 Reporting Services
Ad hoc reporting SQL Server 2005 Reporting Services
Ad hoc query and analysis Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)
Database development tools SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other SQL Server 2005 Business Intelligence Development Studio (New!)
Database management tools Enterprise Manager, Analysis Manager SQL Server 2005 SQL Server Management Studio (New!)

I will get back to you in my next post. All the best for your definition PLUS hunt.

ByDr. SubraMANI Paramasivam

Resource Governor for all users in a group

It was a hard part initially to make use of balancing the resources for all users with different groups. We can make use of IS_MEMBER() function, but the Function Classifier need to be derived accordingly. Also this is not an 100% workout to get the ideal result. I have recently come out with good work around to sort out this issue.


To give a scenario, I have 3 sets of SQL users. Moreover I also have replication stuff going on.
1. Business Team with developers knowledge
2. Business team with basic knowledge + pivot table manipulators in excel
3. IT team

I need to balance the users login on one side & the replication on the other.

I have used 3 Workload groups & Resouce pools on top of the server’s default & internal pools.

–**CREATE RESOURCE POOL **–
CREATE RESOURCE POOL SSUsers
WITH (MAX_CPU_PERCENT = 2, MAX_MEMORY_PERCENT = 2);
go

CREATE RESOURCE POOL DevUsers
WITH (MAX_CPU_PERCENT = 4, MAX_MEMORY_PERCENT = 4);
go

CREATE RESOURCE POOL Distribution
WITH (MIN_CPU_PERCENT = 15, MAX_CPU_PERCENT = 40, MIN_MEMORY_PERCENT = 40, MAX_MEMORY_PERCENT = 60);
go

–to reconfigure the created resource pools, i used the following
ALTER RESOURCE GOVERNOR RECONFIGURE;
go

–the below query displays the newly created resource pools with its ID.
SELECT * FROM sys.dm_resource_governor_resource_pools;
go

–**CREATE WORKLOAD GROUP **–
–create workload group to assign to the resource pools

CREATE WORKLOAD GROUP WG_SSUsers
USING SSUsers;
go

CREATE WORKLOAD GROUP WG_DevUsers
USING DevUsers;
go

CREATE WORKLOAD GROUP WG_Distribution
USING distribution;
GO

–to reconfigure the created resource pools, i used the following
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

–the below query displays the newly created workload groups with its ID.
SELECT * FROM sys.dm_resource_governor_workload_groups
I am going to write a classifier function that will distinguish the users and the replication database and allocated the workload groups accordingly.

Before creating the classifier function I need to have all the list of users underneath their group level. In our case, I had issue in using IS_MEMBER() function where it was able to allocate resource for the first set of rules defined in the classifier function. Then I came out with adding the list of user to a physical table with their permissions level in the master database. You can execute the following against your master database.

Use master
go

CREATE TABLE RG_Users_Group
(
RG_Name NVARCHAR(15) NULL,
Username NVARCHAR(25) NULL

)

INSERT INTO rg_users_group VALUES (‘SS_Users’, ‘AB01\user1′)
INSERT INTO rg_users_group VALUES (‘SS_Users’, ‘AB01\user2′)
INSERT INTO rg_users_group VALUES (‘SS_Users’, ‘AB01\user3′)
INSERT INTO rg_users_group VALUES (‘SS_Users’, ‘AB01\user4′)
INSERT INTO rg_users_group VALUES (‘Dev_Users’, ‘AB01\user5′)
INSERT INTO rg_users_group VALUES (‘Dev_Users’, ‘AB01\user6′)
This creates a list of all users with proper Resource Group name. The output of the table looks like this.
RG_Name Username
——————————
SS_Users AB01\user1
SS_Users AB01\user2
SS_Users AB01\user3
SS_Users AB01\user4
Dev_Users AB01\user5
Dev_Users AB01\user6
Once the table is created then I write my classifier function here.

–create the classifier function to assign the workload groups
IF OBJECT_ID ( ‘dbo.RGov_Classifier’) IS NOT NULL
DROP FUNCTION dbo.RGov_Classifier;
go
CREATE FUNCTION dbo.RGov_Classifier ()
RETURNS sysname WITH SCHEMABINDING
AS
BEGIN
RETURN
(
SELECT CASE WHEN SUSER_NAME() IN (SELECT username FROM dbo.rg_users_group WHERE RG_name = ‘SS_Users’)
THEN N’WG_SSUsers’
WHEN SUSER_NAME() IN (SELECT username FROM dbo.rg_users_group WHERE RG_name = ‘Dev_Users’)
THEN N’WG_DevUsers’
WHEN ORIGINAL_DB_NAME () = ‘distribution’
THEN N’WG_Distribution’
ELSE N’default’
END
);
END;
go
–register the classifier function to the RG.

ALTER RESOURCE GOVERNOR
WITH (CLASSIFIER_FUNCTION = dbo.RGov_Classifier);
GO
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

Now the creation of all resource pools, workload groups, table & classifier function is done. It is time to check how the resource group works. So I have the following query to check each resource pools & their average response in milliseconds.
USE MASTER;
GO
SELECT
RP.name as PoolName,
COALESCE(SUM(RG.total_request_count), 0)as Total_Request,
COALESCE(SUM(RG.total_cpu_usage_ms), 0)as Total_CPU_in_MS,
CASE
WHEN SUM(RG.total_request_count) > 0 THEN
SUM(RG.total_cpu_usage_ms) /SUM(RG.total_request_count)
ELSE
0
END as Avg_CPU_in_MS
FROM
sys.dm_resource_governor_resource_pools AS RP
LEFT OUTER JOIN
sys.dm_resource_governor_workload_groups AS RG
ON
RP.pool_id = RG.pool_id
GROUP BY
RP.name;

In the above query, I have used the DMV (Dynamic Management Views) to help in identifying the resources used for each pool.

PoolName Total_Request Total_CPU_in_MS Avg_CPU_in_MS
DevUsers 3644 13412519 3680
SSUsers 50 243846 4876
distribution 1340523 16428325 12
default 621057 822676774 1324
internal 0 3182271 0

In the above scenario, I made sure all the resource pool now works fine.

This is not an 100% solution, and still have some work around to better up the results. But still a good work around compared to the other scenario.

Let me know if you need any clarifications on this.