BLOGS

ByDr. SubraMANI Paramasivam

Snapshots in Microsoft Reporting Services

Snapshots is a great feature within Microsoft SQL Server Reporting services, to see any of your reports at that point in time. The same report cosmetics might have changed recently as part of the change request and the data will be changing everyday. How did the report looked in terms of look and feel and the data that was latest same time last year? For this question a simple answer is the snapshots. Another simple example is your photo that was taken today and comparing the same with your own photo that was taken 5 years ago. Now do you see the difference? Yes, this is an amazing option we have within Microsoft SQL Server Reporting services for your reports.

By running these snapshots of your reports, it reduces the load on the databases directly, but any amazing feature may have its own negative side as well. It is always recommended to keep less than 8 to 10 snapshots for a report in the SSRS and download the rest as a PDF and delete the previous snapshots as the data and the layout are storing in the Report Server DB and this will unnecessarily bloat your SSRS system databases. Below is also a screenshot that explains more on Snapshots. You can also view a quick demo on snapshots in this link.

SSRS_Snapshots

 

ByDr. SubraMANI Paramasivam

Issues & Limitations of using Stretch database in SQL Server 2016 CTP 3.0

As you can see from the below slide, these are the identified issues and limitations that we have with the Stretch database within SQL Server 2016 CTP 3.0 release. A table that has more than 1023 columns or 998 indexes is not eligible to stretch it to Azure. Also the constraints like Check, Foreign Key, Default are also a huge restrictions placed on OLTP schema systems. This Stretch database concept highly works with OLAP based systems and /or if any table that is been isolated without any relations to anyother table. You can also check this article to identify whether any tables within your database is qualified for stretch or not.

SQL2016CTP3_Issues

ByDr. SubraMANI Paramasivam

Running Stretch Database Advisor against AdventureWorks2014 OLTP database

This article gives a quick glimpse on how to run SQL Server 2016 Upgrade Advisor Preview 1.2 against AdventureWorks2014 OLTP database. Once you shoot the Upgrade Advisor, go to Scenarios and then select the first option “Run the Stretch Database Advisor”. Following this, you will get below screen and then click on Select Databases to Analyze. This will then shoot the blade option to select the databases but requires you to connect to which instance the database is located. In the below example I am connecting to my YSMLab01\SQL2016 instance.

RunStretch_01

After choosing the instance, I am selecting AdventureWorks2014 database and clicking on Run button.

RunStretch_02

Following the analyzed database of AdventureWorks2014, it has identified the database size and total number of tables being analyzed. By clicking on this result set it further displays the list of tables with status on eligibility to cloud or not. If it has errors then it gives out the reasons on why it is not selected in blade format.

RunStretch_03

In here, I am further trying to find the problem on why Person.Person was not selected and one of the reasons is because of Default Value Constraints on one or more columns cannot be part of stretch database.

RunStretch_04

You can see the same results when the stretch database advisor is run against AdventureWorksDW2008R2 OLAP database here.

ByDr. SubraMANI Paramasivam

Data Awareness Programme @ MacLearn International College

Following the success of Data Awareness Programmes conducted in India & Malaysia Stamford college, this new Data Awareness Programme was conducted again in Kuala Lumpur – Malaysia at Maclearn International College on 19/08/2015.

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

 

Appreciation Award to Tan Sri Datuk Seri M Kayveas

Appreciation Award to Tan Sri Datuk Seri M Kayveas

DataAP_Students_Teachers_Organizers_YSMCEO

DataAP Attendees, Teachers, Organizers with Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas.

DataAP_Students_Teachers_Volunteers_Organizers_YSMCEO

DataAP Attendees, Teachers, Organizers with Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas.

DataAP_Teachers_Organizers_YSM_team

Teachers, Organizers with Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas.

DataAP_YSMCEO_DATUKSRI_Discussion

Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas discussion during Data Awarness Programme

DataAP_YSMCEO_DATUKSRI_Discussion

Dr.Subramani Paramasivam and Tan Sri Datuk Seri M Kayveas discussion during Data Awarness Programme

DatukSri_CollegeHead_Chat_in_DataAP

DatukSri_CollegeHead_Chat_in_DataAP

DataAP_Lead_Students_Teachers_Volunteers_Organizers_YSMTeam

DataAP_Lead_Students_Teachers_Volunteers_Organizers_YSMTeam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Data Awareness Programme Delivery by Dr.Subramani Paramasivam

Tan Sri Datuk Seri M Kayveas Speach

Tan Seri Datuk Seri M Kayveas Speach

Tan Sri Datuk Seri M Kayveas Speach

Tan Sri Datuk Seri M Kayveas Speach

Tan Sri Datuk Seri M Kayveas Speach

Tan Sri Datuk Seri M Kayveas Speach

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

Fun filled Student Participation

DAGEOP Malaysia team supporting the delivery of Data Awareness Programme

DAGEOP Malaysia team supporting the delivery of Data Awareness Programme

 

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

Data Awareness Programme Attendees

 

 

ByDr. SubraMANI Paramasivam

What is XACT_ABORT in terms of implicit or explicit transactions?

When it comes to data modification statements for OLE DB systems, the XACT_ABORT option with ON and OFF functions helps the Developer/Administrator to decide based on the requirements from the business.

For example lets take a stored procedure that will complete fully, only if the UPDATE statements are completed. In this case the XACT_ABORT option should be set to ON like below.

SET XACT_ABORT ON;

GO

BEGIN TRANSACTION

By setting this XACT_ABORT option to ON, it does not affect trapping of any errors using TRY-CATCH, but it helps in a scenario where the commit or rollback was successful or not.

 

 

ByDr. SubraMANI Paramasivam

Report server modes

There are 2 types of report server modes and given in below screen with available options in SQL 2012. The 2 modes are Native & SharePoint. With native mode you get all the features available to operate your reporting services. But with SharePoint mode you get to manage the SSRS environment using your local SharePoint. By operating via sharepoint mode, you can enable all your intranet users to get to access to SSRS environment within the same application but it does have its own downside like it does not support linked reports, my reports, my subscriptions.

ReportServerModes

ByDr. SubraMANI Paramasivam

SSRS Report Subscriptions

Subscription option with SSRS Reporting tool enables a user to schedule a report to deliver to a mail box as an attachment or to a network shared drive on a regular interval like everyday at 9am or every Monday at 10am or every month, every quarter, etc., based on the business requirements. This subscription is a great feature which enables a user to still see the report and data on that specific date and time no matter if the report date falls on a public holiday or a week end. So we don’t need a manual intervention to run the report like a robot, but instead the subscription option deliver the robotic service.

As this is alternative to running reports on demand, this also gives a great option to execute and deliver a report dynamically based on a condition derived with Dynamic Subscription option, like if the data exists or if the user exists. Below picture explains some of the options available in subscription option. A quick demo on subscription and dynamic subscription is available here.

SSRS_Subscriptions