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 responsivebreakpoints.com is pretty awesome. Generates all the images required and spits out the picture code




Tuesday, January 26, 2016

Encryption in SQL Server

Encryption


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 asp.net 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>
       </ul>

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


Need
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 ASP.net session timeout with report viewer

Issue: asp.net 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