Sahil Malik - blah.winsmarts.com

Method Chaining in CSOM

Sahil Malik — Wed, 08 May 2013 02:52:53 GMT

SharePoint Training: more information

The golden rule about client side code (or any distributed application for that matter), your communication should be chunky, not chatty. JavaScript CSOM (Client Side Object model) in SharePoint 2013, has a construct called as method chaining that allows us to tersely specify all the stuff we would like to get in one shot. Here is how,

Read full article ....

Firewall settings for SQL Server

Sahil Malik — Mon, 06 May 2013 16:00:40 GMT

SharePoint Training: more information

A while ago, I had blogged a quick fix for the SQL Server firewall warning when setting up SharePoint. Firewall settings for SQL Server is a very complex topic. The specific firewall settings you may need to do, really depend on the feature set, configuration, and even your network topology. Here is some high level description though. To add to that, all these ports are configurable, especially once you consider the multitude of security devices in a real environment. A lot of these apply to SharePoint. For the basic database engine, you need, Feature Port Comments SQL Server default instance running over TCP TCP port 1433

Read full article ....

Registry keys to administer Office 365 in your Organization

Sahil Malik — Sat, 04 May 2013 12:46:39 GMT

SharePoint Training: more information

If a user in your organization attempts to access an Office 365 resource, from their office client, you as an administrator have a lot of control on the user experience. This is tweaked mostly using certain registry keys as follows, 1. HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\SignIn\SignInOptions allows you to tweak what ID types to offer the user at logon,

Read full article ....

SharePoint 2013 - JavaScript & jQuery big booboo to watch out for.

Sahil Malik — Fri, 03 May 2013 04:22:42 GMT

SharePoint Training: more information

So everyone likes jQuery right? Even Microsoft likes it, even the SharePoint team likes it. Unfortunately, 99.999% of the code you see out there using jQuery makes a big huge mistake. And that is, to load the $ variable in the global namespace. This can cause issues especially as newer versions of jQuery are released. Many of these changes are breaking changes. Why is this a problem, because lets say in a SharePoint project, your designers used jQuery 1.9, and your app uses jQuery 2.0, you are at risk in all of the following breaking changes… (I’ll see you at the end) ..

Read full article ....

Know thy indexes

Sahil Malik — Fri, 03 May 2013 03:13:38 GMT

SharePoint Training: more information

Okay so here’s another bak2basics kinda post – Know thy indexes. (If u got more stuff to add, please do :-)) What are indexes? Well indexes are exactly what you’d think they are – like at the back of a book? They are a logical arrangement of your data, so you can find the data easily. So SQL Server has two kinds of indexes, Clustered and Non-Clustered. 1. Both clustered and non-clustered indexes are implemented using a variant of B-Tree, but a clustered index reorganizes the data pages of the indexed table, whereas a non-clustered index is created in seperate data pages. 2. Clustered indexes are usually to support primary keys and should be used to index only narrow columns – thus making them a bad candidate for GUIDs. Thus, if you have GUIDs as your primary key, make sure it is non-clustered (by default your PK is clustered). Usually a clustered index key should column not exceed 16 bytes per row because the key column’s data

Read full article ....