Wednesday, January 27, 2016

Responsive Image generator

Have you ever wondered how to create one image and then generate images for different devices?

We can use is pretty awesome. Generates all the images required and spits out the picture code

Tuesday, January 26, 2016

Encryption in SQL Server


Encryption hierarchy is marked by three-level security. These three levels provide different mechanisms for securing data across networks and local servers. 

Monday, January 25, 2016

Data conversion in SSIS package

When we create a SSIS package and run the package after mapping the columns we might receive error saying "Cannot Convert between Unicode and Non Unicode String Data Type

This can be resolved using Data conversion

Solution for SSIS Error code 0xC0209303

When we try to load data from MS-Access to SQL server using SSIS we can get an error with code "0xC0209303"

SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered


Wednesday, January 20, 2016

Add active class to HTML in ASP.Net MVC

When we use bootstrap nav-bar in MVC,  we need to dynamically update the selected item class as active. By default this feature is not available in ASP.Net Mvc. 

       <ul class="nav navbar-nav">
             <li class="active">@Html.ActionLink("Home", "Index", "Home")</li>
             <li>@Html.ActionLink("About", "About", "Home")</li>
             <li>@Html.ActionLink("Contact", "Contact", "Home")</li>

Monday, January 11, 2016

SQL-RD Data driven schedule

Automation Schedule

  •  Business process automation arm of SQL-RD
  •  Enable to run multitude of different task
  •  These task can be scheduled before and after a report schedule
 Ex we can print a document before sending Reports

SQL-RD Dynamic schedule

To run SSRS reports against multiple recipients or each individual needs to get a unique flavor of the same report

Note: We do not have to use subscription for each individuals

Resolve issue with session timeout with report viewer

Issue: session error in Iframes within report viewer as shown below.

SQL-RD Single and Package schedule

Single Schedule

 Scheduling SSRS reports for singe schedule delivery