tag:blogger.com,1999:blog-40996629640354202162024-03-13T13:53:37.476+05:30Sarav's Scribbling Pad for Microsoft TechnologiesHere you can find wide variety of things about me. A small description about me, a computer programming obsessed guy thinking one day would come up like gates.Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-4099662964035420216.post-39998380709445523422015-05-17T20:07:00.000+05:302015-05-17T20:07:32.001+05:30Dynamically Hide/Show columns in SSRS ReportI was developing a SSRS report that fetches data from table that has 2 billion rows. Report had around 80+ columns displaying data. On the verge of acceptance testing client came up with a concern that the report is too big and he needs an option to control the number of columns that gets displayed in report for better viewing and exporting capabilities.
SSRS doesn't provide this feature out of Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-72158578288805555012015-05-17T19:44:00.000+05:302015-05-17T19:44:23.989+05:30Account Mining
Acquiring business and sustaining is the oxygen for every
organization out there.
A research states that most of the business (80%) comes in
from existing customers (provided your performance was on par with expectations
at least if not above).
Some of the learnings I gathered from the industry suggest
following ways can help Account managers (AM) to mine new business.
<!--[if !supportListsSarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-28439900218523842732015-05-17T19:03:00.000+05:302015-05-17T19:03:02.523+05:30Situational Leadership
I am pursuing a course in Courseera about "Fundamentals
of Management" and when I came across content on Situational Leadership
became much interested.
In todays’ more agile world, Leaders need to possess
multiple personalities (both bad and good) to strive and keep producing
results. Most important one is “Emotional Intelligence (EI)”, defined as ability
to manage ourselves and our Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-86856606147726002412014-07-06T01:41:00.000+05:302014-07-06T01:41:36.424+05:30Windows 2012 installation issue in VM playerWhen you tried to create a new VM using VM player 6.0.2 with Windows 2012 as the guest OS, you may get error while guest OS installation.
The error will tell "Microsfoft Terms not able find..." and installation can not continue.
Follow below steps:
1. When you create VM by clicking on "New VM" option in player., Uncheck the install OS from drive or USB option and select install OS later option.
Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-2906223476656722192014-07-06T01:31:00.002+05:302014-07-06T01:31:52.772+05:30Sharepoint 2013 InstallationHave been eager to work with Sharepoint since MOSS 2007. But just last week got a chance to start working..
I personally have heard lot of ghost stories about Sharepoint installations ever since 2007.. So I wanted to try it out my self.
I tried installing and configuring it in two server platforms.. One with Windows 2008 R2 Standard edition and another in Windows 2012 Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-24041695341219616632014-01-17T00:26:00.001+05:302014-07-06T00:41:26.276+05:30Enterprise Library 6 Changes - Exception Handling and Logging Application blocks configurationI was developing a framework services project for my new assignment .. (getting hands dirty after a while .. :) ).. Seems that there is a change in the way we configure our helper classes to log and handle exception
For Logging:
common approach to create a log entry using the following code-
LogEntry entry = new LogEntry();
entry.Message = "I am logging";
Logger.Write(entry);
Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-51501837531876371642011-06-08T00:44:00.001+05:302011-06-08T00:46:31.528+05:30Some useful SQL Queries on Date functionsTO Calculate first day of monthselect DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)First Day of Yearselect DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)First Day of the Quarterselect DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)Last day of Prior monthselect dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate() ), 0))Last Day of Prior Yearselect dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate() ), 0))Last day of Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-83447551434614366502011-01-10T02:38:00.001+05:302011-01-10T02:41:44.219+05:30Web Application Performance Best PracticesSome of the thumb rules to flare better perfomance in web applications§Appropriate usage of Caching§Minimize HTTP Requests§Minification§Removed unwanted HTML / JS / CSS§Remove White Spaces§Place CSS at Top of the page§Move JS reference to the bottom of the page§Reduce Image Size§Cache Static content (Images / CSS / JS)§Enable HTTP Compression§Remove Duplicate Scripts •Use a Content Delivery Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-1345319051902756322011-01-10T02:30:00.001+05:302011-01-10T02:32:04.876+05:30Analysis Services 101Here is intro course to BI Analytics...1. Facts(Measures) is a summable numeric value2. Only events tracking in Fact table known as fasctless fact tables, in that case add column with value 1 to track them.3. Grain is the lowest possible level of information in fact, make it as lowest as possible. Atomic level.4. Facts are verb in Business process where as Dimesnions are nouns.5. Dimension Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-67119231213116701552011-01-10T02:23:00.003+05:302011-01-10T02:28:48.279+05:30DB Normalization in simpleThis is one of the most frequently used question..lot times we know the thing have difficulty in expressing it...thot would write a simple post for it...First Normal Form (1NF) Eliminate duplicative columns from the same table. Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key). Second Normal Form (2NF)Meet all the Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-6878929954409479962011-01-10T02:03:00.003+05:302011-01-10T02:08:14.795+05:30Review your ArchitectureLast week I bumped in to a book "Enterprise Application Arch 2ed". I read abot reviewing S/W arch by some proven methodlogies..thot would blog for starters.. good read...Scenario-based evaluations are a powerful method for reviewing an architecture design. In a scenario-based evaluation, the focus is on the scenarios that are most important from the business perspective, and which have the Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-88037279669141626912010-02-20T00:32:00.003+05:302010-02-20T00:42:43.940+05:30Iterating over JSON object (string ) with jqueryWe had a scenario where in we need to search for particular object in collection. Whenever the user changes something in dropdown in ASP.NET we need to show some value in a label. If we take the drop down value to server it would take time.... so what we thot is we searialized the object using JavascriptSerializer in ASP.NET and converted to JSON string.. passsed to a javascript function to Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-88660137748739848862010-01-16T00:21:00.002+05:302010-01-16T00:29:46.995+05:30ASP.NET Dynamic User controlsToday after long time...I moved to an assignment to work in ASP.NET after the gap of almost nealry 5 years. I started working on an Intranet Portal for a financial institution.We wanted to generate certain UIs dynamically, we chose different user controls will be loaded based on the user requirement. One thing I learned today is "Dynamic Controls Should be Loaded on Each PostBack" On every Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-49423475025554191642009-12-21T23:11:00.006+05:302009-12-21T23:29:30.183+05:30Some Interesting Websites.LINQ Toolshttp://www.thinqlinq.com/Post.aspx/Title/LINQ-Tools.NET 3.5, ASP.NET interview questions.http://dotnet2008interviewquestions.blogspot.com/WCF 4.0 Introduction from MSDNhttp://msdn.microsoft.com/en-us/library/ee354381.aspxSharepoint Beginner videos.http://dotnetguts.blogspot.com/2009/03/sharepoint-videos-for-beginner-step-by.htmlOOPS Conceptshttp://dng-oops.blogspot.com/Cool Tools for .Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com2tag:blogger.com,1999:blog-4099662964035420216.post-48059121890411057582009-01-05T14:36:00.002+05:302009-01-05T14:40:57.649+05:30Meta Data Queries in SQL Server 2000-- Query to Find All User TablesSELECT * FROM SYSOBJECTS SOWHERE SO.XTYPE = 'U' ORDER BY SO.NAME-- Query to Find All User ViewsSELECT SO.NAME FROM SYSOBJECTS SOWHERE SO.XTYPE = 'V' ORDER BY SO.NAME--Query to Find all Procedures in the DBSELECT SO.NAME FROM SYSOBJECTS SOWHERE SO.XTYPE = 'P' ORDER BY SO.NAME--Query to Find all Triggers in the DBSELECT SO.NAME FROM SYSOBJECTS SOWHERE SO.XTYPE = 'TR'Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-69055260019064541092008-12-02T15:03:00.003+05:302008-12-02T15:09:44.682+05:30SSIS - Script Component - Variables Access ErrorI was developing an SSIS package and I encountered the following problem.I had a OLE DB source that is providing me data from a SQL table in my data flow task. I had a script component following it. I am trying to concanctenate my one of the string column to a variable and trying to use it in other task.So I had my code like this in my inputprocessrow method.--------------------------------------Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-78088083140419335632008-07-10T11:45:00.001+05:302008-07-10T11:48:17.881+05:30SQL Injection TipHope everyone is aware of SQL Injection attacks. For people who are new, it is something about intruding in to your SQL Server (DB) by passing some commands through a request. If the following (0x73656C656374206E616D652066726F6D207379732E6461746162617365733B) value is passed to the SQL Query, it will list all the DBs on the server. Something interesting. So whenever you get a request, check for Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-8172147149229852702008-06-17T23:29:00.005+05:302008-06-17T23:35:22.203+05:30Service Broker - An Alternate to Messaging MS SQL Server1. Enable Service Broker in the DB. Use Master; Go ALTER DATABASE AdventureWorks SET ENABLE_BROKER; go2. Create Endpoint to send / receive messages from outside of SQL Server Instance. - Create Endpoint with Port number and authentication level Use Master; go CREATE ENDPOINT ExampleEndPoint STATE = STARTED AS TCP ( LISTENER_PORT = 3133) FOR SERVICE_BROKER (AUTHENTICATION = WINDOWSSarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-82187035327764016432008-04-29T13:53:00.006+05:302008-08-27T16:40:05.466+05:30Interesting SQL QueriesQuery to find Procedures that contains a particular string in MS SQL 2005select O.name from sysComments C join sysObjects O on O.id = C.id where O.xtype = 'P' and C.text like '%string%'Query to find all the user-defined tables in a specified databaseUSE db;GOSELECT *FROM sys.tables;GOQuery to find find all the tables and indexes that are partitionedUSE db;GOSELECT SCHEMA_NAME(o.schema_id) AS Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-25783961531216166842008-01-20T02:06:00.000+05:302008-01-20T07:13:54.474+05:30Reporting Services 2005 ProblemsI was creating some SSRS reports (both in Server and local mode) as part of my project work and i need to admit that i had some tough times for some of the issues.First of all I had issues in installing SSRS 2005 in my Windows Vista Premium OS and after googling it for some time, I came across a fact that IT IS NOT POSSIBLE TO INSTALL SSRS IN WINDOWS VISTA HOME PREMIUM edition. Refer following Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-39063444457103335592008-01-20T01:09:00.000+05:302008-01-20T01:20:08.001+05:30Message Maintanance Architecture.Here is my article I wrote some timc back about Message Maintanance Architecture for Web Application. Have a glance and let me know about any short falls or enhancements. I would like to have some comments on this.http://www.codeproject.com/KB/cs/messagehandling.aspxSarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0tag:blogger.com,1999:blog-4099662964035420216.post-7481720608401699782008-01-20T00:04:00.000+05:302008-01-20T00:09:53.401+05:30Microsoft - Tech Mela - Jan 2008Visit following link to have a look at latest Microsoft Tech Mela Presentations and Videos.http://msdn2.microsoft.com/hi-in/bb735929.aspxSome of the videos are below par addressing very low level issues. For example, Peroframance and security video on web applications. Expected more than the content. Anyways, good refresher course.Sarranhttp://www.blogger.com/profile/08231798855424840991noreply@blogger.com0