Wednesday, June 26, 2013
Friday, August 26, 2011
Sometimes we may need to know the number of days in a given month. For example, in calculating the number of days in a month or last day of the month or any other scenario.
Here is a small script that will give you the number of days for a month. For example, I'll pick month from the current date.
declare @numberOfDaysInMonth int;
set @numberOfDaysInMonth = DAY(DATEADD (m, 1, DATEADD (d, 1 - DAY(getdate()), getdate())) - 1);
When working with reports, is that every time I'm looking for. Everyone gives the report date as input, and wants to show the month name in the report instead of the monthly index [1-12]. So how?
DateName(month, convert( datetime, '2007-' + cast(month(getdate()) as varchar(2)) + '-01', 120))
Here month(getdate()) returns the current month index from getdate() function. Hope this helps...
I asked some people how to do this, many people have offered the use of the matrix. However, my data is the data simple and has 14 columns like name, surname, state, city, zip code, Q1, Q2, Q3, H1, H2, H3, etc...
Here are the steps i followed to make it work.
No Matrix, no other,. i am done with tables only.
Just a small trick
1. Select all the columns that you want to make expandable, collapsible.
2. Hit F4 [Properties window] –> Select Visibility, and in that, set these values, Hidden = true and ToggleItem = ID of the textbox [Where you want to show the Expand[+], Collpse[-] symbols that text box id. in other words parent text box id.]
3. Done, Here we go.
Sunday, July 31, 2011
For front-end servers, RAM – 4GB for development, 8GB for production.
For Database servers, RAM – 8GB for small deployment, 16GB for medium deployments.
80GB of hard disk
64-bit Windows Server 2008 R2 or 64-bit Windows Server 2008 SP2.
For development environments, we can use either Windows 7 or Windows Vista. But, it is highly recommended that we should not use these OS for production environments.
64-bit SQL Server 2008 R2 or 64-bit SQL Server 2008 with SP1 and CU2 only or 64-bit SQL Server 2005 SP3.
Remember, to install SharePoint 2010, it checks for all prerequisites required and if it didn’t find any then it starts downloading them from Microsoft site and install them in your server. Below are the listed modules which installs by the preparation tool.
Web Server (IIS) role
Application Server role
Microsoft .NET Framework version 3.5 SP1
SQL Server 2008 Express with SP1
Microsoft Sync Framework Runtime v1.0 (x64)
Microsoft Filter Pack 2.0
Microsoft Chart Controls for the Microsoft .NET Framework 3.5
Windows PowerShell 2.0
SQL Server 2008 Native Client
Microsoft SQL Server 2008 Analysis Services ADOMD.NET
ADO.NET Data Services Update for .NET Framework 3.5 SP1
A hotfix for the .NET Framework 3.5 SP1 that provides a method to support token authentication without transport security or message encryption in WCF.
Windows Identity Foundation (WIF)
more information http://technet.microsoft.com/en-us/library/cc262485.aspx
That's the question I received from many people. Although they do not work in Microsoft related technologies, they like to work with SharePoint 2010 [only because the demand and the functions it has]. So, to learn what SharePoint 2010 technologies you need to know or what are the key concepts you need to be strong, that's what we'll discuss in this post.
ASP.NET/C#: SharePoint 2010 is completely built on ASP.NET 3.5 whereas SharePoint 2007 is built upon ASP.NET 2.0. So, if you know basic ASP.NET 3.5 features then you get better ideas in implementing SharePoint 2010 coding and better understand concepts.
SQL Server: This is very important to know as SharePoint A-Z stores in database only.
Windows Workflow Foundation: There are workflows in SharePoint which is useful to solve business process problems. To create the workflows either in SharePoint designer or custom workflows you should have idea of WWF.
XML/XSLT: I can say everything in SharePoint is XML. So, if you are strong in XML then you rock. XSLT is applying styles for XML.
AJAX/Java script: AJAX is a generic concept and in ASP.NET the implementation is a bit different and you may need to know the general concept on how it works. Along with that you have to know java script.
Windows Communication Foundation: WCF is very popular these days as it has very good features. SharePoint 2010 is using WCF Services instead of Web Services. So, to work with them you have to know it. [For SharePoint 2007 it is not needed]
Silverlight: There are modules in SharePoint 2010 developed in Silverlight. And the integration of Silverlight code to SharePoint is also very easy now. [For SharePoint 2007 it may not be needed, but you can create custom Silverlight module and deploy to SharePoint 2007]
Internet Information Services: You have to know what is IIS and how it works.
The technologies/concepts you have to know as an Administrator:
So these are things that everyone should preliminary set before learning about SharePoint 2010. No need to know all too deep, but you have complete idea of what it is and how they work. Therefore, it can take a month to learn about these concepts and begin to learn SharePoint 2010. If you try to learn directly from SharePoint 2010 without knowing that these concepts can succeed in making content management, workflow, SharePoint Designer, customize appearance, etc, but do not know what is going on inside and how work. You cannot do coding, etc. So be sure to spend plenty of time to learn this information before you leap. Hope this helps.