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

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. 

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

 

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>

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