How to Sign in as a Different User in SharePoint 2013

SharePoint used to have a menu option called “Sign in as Different User” in the top-right corner of every page. It was a handy tool for developers and IT professionals in SharePoint 2007 and 2010, which allowed them to login with another account to test their solutions or customizations. Microsoft removed the option in SharePoint 2013, but you can still do it with workarounds or a one-click bookmarklet.

Navigate to the Close Connection Page

http://<site URL>/_layouts/closeConnection.aspx?loginasanotheruser=true

Reference: http://blog.credera.com/technology-insights/microsoft-solutions/how-to-sign-in-as-a-different-user-in-sharepoint-2013/

SharePoint 2013: How to hide All Day Event, Recurrence and Category fields from Calendar New Item form

Using Content Editor Web part and JQuery, you can easily hide the unwanted fields like All Day Event, Recurrence, Category fields from SharePoint Calendar new item form.

• Navigate to the SharePoint Calendar in SharePoint site where you need to remove the fields.
• From ribbon, Click on Calendar tab
• In Customize list section of Calendar ribbon, click on arrow besides Form Web Part. You will see three forms named Default New form, Default Display form and Default Edit form. Click on Default New form.
• In Default New form edit page, click on Add a Web Part and select the Content Editor Web part.
• From Content Editor Web part, Click on Click here to add new Content
• Now select Edit Source from ribbon and add java script to HTML Source editor to hide the fields from calendar form and click OK. To hide exact field, you can start count of TR from Title field as 0 and update the number in java script.

you can also use following scripts to hide fields:

 <script src="//code.jquery.com/jquery-1.11.0.min.js"></script>
 <script type="text/javascript">
 $(document).ready(function()
 {
 $('nobr:contains("All Day Event")').closest('tr').hide();
 $('nobr:contains("Recurrence")').closest('tr').hide();
 });
 </script>

Reference: https://hpatel.wordpress.com/2014/06/05/sharepoint-2013-how-to-hide-all-day-event-recurrence-and-category-fields-from-calendar-new-item-form/

Change the default tile size/tumbnails view in image library in Sharepoint 2013

Using a CSS only approach, add the following CSS inside the content editor webpart or add it to your custom css.

<style type="text/css">
            div.ms-promlink-body {
                height: 130px;
            }
            div.ms-tileview-tile-root {
                height: 150px !important;
                width: 150px !important;
            }
            div.ms-tileview-tile-content, div.ms-tileview-tile-detailsBox,  div.ms-tileview-tile-content > a > div > span {
                height: 140px !important;
                width: 140px !important;
            }
            div.ms-tileview-tile-content > a > div > img {
                max-width: 100%;
                width: 100% !important;
            }

            ul.ms-tileview-tile-detailsListMedium {
                height: 100px;
                padding: 0;
            }
            li.ms-tileview-tile-descriptionMedium {
                font-size: 11px;
                line-height: 16px;
            }
            div.ms-tileview-tile-titleTextMediumExpanded, div.ms-tileview-tile-titleTextLargeCollapsed, div.ms-tileview-tile-titleTextLargeExpanded {
                padding: 3px;
            }
             div.ms-tileview-tile-titleTextMediumCollapsed {
                font-size: 12px; !important;
                padding-left: 6px; !important;
            }
             li.ms-tileview-tile-descriptionMedium {
                font-size: 11px;
                line-height: 14px;
                padding: 3px;
            }
           
</style>

Clearing remembered / default login for SQL Server Management Studio

Removing the remembered login and password list in SQL Management Studio

SQL Server Management Studio 2014 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin

SQL Server Management Studio 2012 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin

SQL Server Management Studio 2008 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

Or find SqlStudio.bin at C using window explorer and delete the file.

Replace SQL Server Profiler with ExpressProfiler (aka SqlExpress Profiler)

Download at https://expressprofiler.codeplex.com/

ExpressProfiler (aka SqlExpress Profiler) is a simple and fast replacement for SQL Server Profiler with basic GUI and integration with Red Gate Ecosystem project.

Can be used with both Express and non-Express editions of SQL Server 2005/2008/2008r2/2012/2014 (including LocalDB)
Distribution package contains both standalone version of ExpressProfiler (can be used without installation) and installation package.


Make sure to grant the "Alter trace" permission to the selected user.

Combining 2 SQL queries and getting result set in one

You can aliasing both query and Selecting them in the select query SELECT x.a, y.b FROM (SELECT * from a) as x, (SELECT * FROM b) as y

SharePoint 2013 - Change URL of document library

When you create a document library, it ask you the name for the DL. Once you give it, it will create library with same name and URL. You can change the name of the library any time but cannot change the url. Here are the things i followed to create url accroding to my needs:

1. Just go to a library trough 'Site Content'
2. When inside the library choose on the ribbon 'Library' tab.
3. Then select 'Open with Explorer'.That will open your SharePoint's library in Windows Explorer window.
4. Navigate one folder up and you will see list of your libraries as folders.
5. Rename required library's folder name as you want the URL to look like.
6. Close the windows and refresh the browser or go back to home page and browse the library again.

Reference:
http://sharepoint.stackexchange.com/questions/111524/sharepoint-2013-change-url-of-document-library
http://stackoverflow.com/questions/12904944/change-sharepoint-library-url