Table Expand Collapse Demo : With JQuery Images and Checkboxes

Hello

FYI, here are some examples I have used/seen in past, showing the look and feel of expand / collapse Table columns, this comes in handy when there are allot of columns on a page or users would like to show or hide horizontally

Demos

Expand Collapse Columns using Images

http://jsfiddle.net/flasponge/txq9w9wy/embedded/result/

Show Hide Columns using PopUp CheckBoxes

http://jsfiddle.net/flasponge/0vLtcw0v/embedded/result/

Click the arrow to expand and collapse

View Fiddle Source:

Expand Collapse Columns using Images

Show Hide Columns using PopUp CheckBoxes

Basic Show / hide columns using CheckBoxes JQ

SQL Server SUPER FAST Generate Script 1.0 : Instead of using SSMS use a script to save heaps of time!

SQL Server SUPER FAST Generate Script 1.0

How many times have you had to get a bunch of sprocs, udf's and views from one DB and need to generate Alter scripts for each only to realize that perusing thru SSMS one at a time or via the Object explorer details even with multi-select can be tedious?

 Well there is an option or 2 that can help!

 Pre Reqs, 

 1. sp_LongPrint.sql You will need the following sproc that prints varchar(max) to the PRINT, else long content is truncated, See attachment

 Option 1: 

Open GetSprocs.Basic.sql, Super Simple, gets sprocs and udfs using INFORMATION_SCHEMA.Routines, Just set the DB to your DB and criteria and boom, it spits out the DDL: ... SELECT r.Routine_Definition, routine_name FROM INFORMATION_SCHEMA.Routines r where ... ... exec master..[sp_LongPrint] @txt ...

 Option 2: 

1. Get vw_DBAObjects.sql run that view to create on target DB,
2. Now open GetSprocs.Advanced.sql, set your DB and criteria, voila u can get VIEWS, Sprocs, UDFS, TVF's DDLs with one click. You can print out 50 views in 1 second!
3. Yay.


 See attached zip for source, uses DB AdventureWorksDW2012 by default Download the Source Here

Speed Up Visual Studio 2012 + Build Performance,

Here are 2 recent options that imporved Build (MSBuild) performance: 1): Go to OPTIONS>ENVIRONMENT..under Visual Experience, untick “Use Hardware Graphics Acceleration If Available” for some weird reason your dev environment should loosen / speed straight up. Works on all or our laptops. If you have any doubt if yours is on go slow, op 2) Goto Tools>Options>Environment>Add In Security You will see a checkbox with “allow add in components to load” .Just uncheck it. Restart the IDE and check the lightning speed of the IDE now…

IIS Bindings HTTP and HTTPS, SharePoint 2010 Alternate Access Mapping and SSL

Example binding exposing server to intranet and un-trusted domains in same network, with http and https, Used MS self signing certificate for Dev purposes, Used for reference : This shows IIS8 bindings with various binding to expose a dev server to intranet , also showing corresponding SharePoint 2010 Alternate Access Mappings for bindings to support ssl, and ssl storage of self signed cert and IIS config for SSL cert. In this case using self signed ssl cert for dev / demo purpose only. 1. IIS 8 Bindings

2. SharePoint 2010 Alternate Access Mappings

3. SSL certmgr.msc

4. IIS SSL Config

Code Search Engine : Code.OpenHub

One of the coolest Ive seen in a while Black Duck Open HUB @ http://code.openhub.net/ makes it a breeze to find hard to find code samples, the results are displayed quickly with an intuitive preview interface for quickly checking out result, Break out of the GooglGulag come over to http://code.openhub.net/, Example Search for sharepoint 2010 sandbox solutions yields this:

Use Jquery to hide all elements except one

I need to hide everything, except the table with id = divShowOnly
View JS Fiddle Source Here

Code:

// hide all elements except a few
//hideAllExcept('#ctl00_PlaceHolderMain_gvSummary')
function hideAllExcept(selectrId) {
//$('body > :not(#ctl00_PlaceHolderMain_gvSummary)').hide();
    //$('[id*=gvSummary]').appendTo('body');
   
    $('body > :not(' + selectrId + ')').hide();
    $('[id*=' + selectrId + ']').show(); //or  appendTo('body');
   
}

JS JQuery to loop thru Table TRs to swap img src from one image to another

See fiddle here

View Demo Here