Posts

SQL Queries

1.FIND THE EMPLOYEES WHO BELONG TO THE SAME CITY AS PRAKASH   SELECT * FROM EMPLOYEES WHERE CITY=(SELECT CITY FROM EMPLOYEES WHERE TITLE='SALES MANAGER') 2.FIND THE EMPLOYEES WHO JOINED THE SAME DAY AS PREM SELECT * FROM EMPLOYEES WHERE BIRTHDATE=(SELECT BIRTHDATE FROM EMPLOYEES WHERE EMPLOYEEID=9)   3.FINDING THE EMPLOYEES WHERE INNER JOIN IS RETURNING MORE THAN ONE ROW SELECT * FROM EMPLOYEES WHERE CITY IN(SELECT CITY FROM EMPLOYEES WHERE TITLE='SALES REPRESENTATIVE') 4.CORELLATED SUBQUERY SELECT EMP_NO, NAME, HIRE_DATE, MGR_NO FROM EMPLOYEES SUBORDINATES WHERE HIRE_DATE < (SELECT HIRE_DATE FROM EMPLOYEES BOSSES WHERE BOSSES.EMP_NO = SUBORDINATES.MGR_NO)   5.Left and Right outer join SELECT titles.title_id,  titles.title,  publishers.pub_name FROM titles right OUTER JOIN publishers ON titles.pub_id  = publishers.pub_id Right join -- All rows in the second-named table (the "right" table, which appears rightmost in the J...

SharePoint - When to Timerjob rather than Workflow

When to use an timer job rather than a Workflow Timer jobs can be used instead of so called "system" workflow ( that automate processes  that interact with the content and data stored in SharePoint). The major differences between timer job and system workflow:  - Timer jobs can be activated and managed by farm administrators only;  - End users can't control execution; So rule of thumb: If the end users do not need to control the process, then choose timer jobs; otherwise, choose system workflow Does any user interaction occur? Will the process run for a long time (more than a second or two)? Will the process need to pause to wait for another process to complete a task? Will the process be run many times (more than 25 or 30) concurrently? If the answer is "Yes" for any of these questions, you should build a workflow; if "No" for all, consider an event receiver. There are certainly some exceptions, but in general ...

SharePoint Objects, SharePoint site access issue to all users

1. SharePoint objects often get confused SPSite object is meant for SiteCollection SPWeb object is meant for Site 2. IMPOTANT Learning from production deployment Publish all pages will resolve the – Access Denied issue à This is very important irrespective of pages/images/css/js files

SharePoint 2013 and REST API EndPoints

SharePoint 2013 REST Interface     SharePoint 2013 provides a Representational State Transfer (REST) interface that opens the SharePoint 2013 development platform to standard Web technologies and languages. SharePoint capabilities have long been available to Web applications through the client object model, but those APIs are available only to .NET applications and languages. The extensive REST interface in SharePoint 2013 makes it possible to access most SharePoint capabilities and entities with standard Web languages such as JavaScript or PHP, and any technology stack or language that supports REST. Because the REST interface doesn’t require referencing client assemblies, it also allows you to limit the footprint of your Web applications—an especially important consideration for mobile applications. REST has obvious benefits for mobile applications that are written for non-Microsoft platforms, such as iOS and Android devices, but it’s also a useful resource for Win...

Provider App Host Model Evaluation explained

http://blogs.technet.com/b/meamcs/archive/2013/02/24/sharepoint-provider-hosted-app-walkthrough-part-1-preparation.aspx

SharePoint 2013 Performance Improvement - (Caching - Blob Caching, Page output Caching, Object Caching and anonymous search result caching)

SharePoint Server 2013 provides four types of caches that help improve the speed at which web pages load in the browser: the BLOB cache, the page output cache, the object cache, and the anonymous search results cache. The BLOB cache is enabled and configured in the Web.config file in the web application to which you want to apply the cache. The page output cache and object cache are usually configured in the user interface at the site collection level. Certain settings for these caches can also be configured at the web application level. The changes that you make to the Web.config file will be applied to all site collections and sites within the web application, and will supersede any configuration made at the site collection level or below.      BLOB cache SharePoint Server 2013 provides a disk-based cache that stores files that are used by web pages to help them load quickly in the browser, and reduces the load on the database server when it uses those fil...

Power BI Dashboard and Power BI Designer – Office 365

Connect with Online SharePoint List -           Create designer (pbix) file using Power BI Designer by connecting with SharPoint List -           Now go to Power BI Dashboard and click Get Date -           Import the file from local saved “My Computer” location and customize the columns you want to display in the report -           Schedule “Autorefresh” using “Power BI Personal Gateway” http://blogs.msdn.com/b/powerbi/archive/2015/07/07/refresh-for-on-premises-sources-is-here.aspx -           User who installs “Power BI Personal Gateway” should have admin rights, because Power Bi Gateway will be running with this account in the computer/laptop -           Now schedule auto refresh and while doing s...