Friday, August 26, 2011

How to Know the Number of Days in a Month in T-SQL

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);


How Do You Know the Name of the Month in the Monthly Index of T-SQL?

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?

please use the below script to get the name of the month by month index.

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...


How to make columns collapsible, expandable in table Sql server reporting services.

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...

I need to show the columns Q1, Q2, Q3, H1, H2, H3, expandable and collapsible. By default, when you see the report, I show only the name, state, city, postal code, Q1, H1. But q1, H1, with the columns to expand, collapse icons.

When any one clicked to expand i need to show q2,q3, and same for h2, h3.

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

SharePoint 2010 initialization software and hardware requirements

Hardware requirements

64-bit processor

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

Software requirements:


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


What You Should Know Before Learning of SharePoint 2010

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.

The technologies/concepts you have to know as a Developer:

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:

SQL Server


Windows Server

SharePoint Designer

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.


Wednesday, July 27, 2011

SharePoint 2010?

If someone has asked this question there is no single answer to that. SharePoint is a very large and has many features. So if we start talking about them, then it may take weeks to cover all functions.

But in simple words "Microsoft SharePoint is a platform for enterprise collaboration and content management that allows users to connect with each other and share information across an organization. Indirect that solves problems in an organization share documents, security, business processes, maintenance of data, rich user interface and SharePoint 2010 so many features. "

1. Sites:You can create a website within seconds of the user interface. You can set the number of sites that you want as needed and set different permissions for each site. SharePoint 2010 comes with the rich user interface and numerous improvements to the HTML. They replaced all the tables in HTML [SharePoint 2007] with HTML div [SharePoint 2010]. It makes a big difference in the rendering of HTML browser, both in performance and time.

And the main thing is important in the tape. The film is the great revolution and all options are on the page itself. The property of the tape change dynamically / automatically depends on what context you are in. No need to leave the current page and do something. Everything on the page and do the necessary things. This rich user interface and support for the film, is very easy to create and manage content on the site.

SharePoint 2010 sites can be viewed on any browser. One limitation is that it is not compatible with IE6 [I think nobody is using IE6 again]. Therefore, we can say that it is multi-platform. It will be very good for developers and users have their own ideas on using the browser. I IE9 and Mozilla. Previous versions of SharePoint do not like other IE browsers. So this problem has been fixed in this release.

SharePoint 2010 is compatible with the cloud computing as well. Therefore, you can receive is the environment in general or the cloud to provide access to Internet users. This is also one of the main features included in SharePoint 2010.

2. Communities:It is more of Social connections. You can connect to employee [colleague] or users through user profiles, my sites and people search. This way you are connected with others and share information very easily. Another thing in communities section is "Informal Knowledge". This includes tagging, rating and feedback features. For example, many users are searching for a common document then what we could do is, tag that document with relative keywords. So that it will come up in top search results. These way users get whatever they want very easily. Another option is rating. You can give rating to particular document or item.

3. Content:As discussed in previous sections of this SharePoint 2010 for the creation or content management is very easy with the new rich user interface and ribbon. This is very easy to find content on the site administrators and to make changes. You may feel that this is the same change of MS Office files like Word, Power Point in your browser. SharePoint 2010 is dominated by a huge and complex collection of metadata throughout the site with ease.

4. Search: Huhh!!! It is a very big improvement in SharePoint 2010 compared to previous version. The way the search improved is unbelievable and gives the exact search results what user is looking for. There are many ways how they improved search. Here are the main things:

Improved relevancy: Once the user must enter a search word SharePoint detects that the user attempts to try and give accurate results they are looking for.

Refinement & Related Searches: For each search word given it searches for the related keywords as well and give in the result set. If you search for John then it gives search results which has John on top and then Jon, Don etc after it. Because Jon matches with 3 letters Don matches 2 letters etc.

Wildcard search: This is what already known thing and not really need any special explanation

5. Insights: This essentially covers the business processes of an organization. The implementation of the perfect workflow. Improvements SharePoint Designer workflow and added many activities for the 2007 business designer. With them, we can solve many problems without writing custom code. And writing custom code that you can easily create your own activities. With these there are improvements to Excel Services and graphics. In this version of SharePoint, Visio Services. You can create a workflow in Visio, and import them directly into SharePoint. It is one of the most amazing this new version. The biggest advantage is who is good in Visio [I believe that a common person] have the opportunity to do things that will be useful in SharePoint.

6. Composites: This concept comes from the Mash-Ups. Pulling information from different data sources and combining it single place. So, we can achieve this in 4 different ways:

SharePoint designer 2010

Infopath 2010

Business Connectivity Services [BCS]

Access Services

So, finally in simple words we can say SharePoint is:

Quickly create and manage content in your organization

Collaborate in new and easy ways through social capabilities

Search helps to find easy and relevant content

Streamline the business process in organization

Visualize the information or huge data

For complete idea please take a look at this nice video.

I believe you understood briefly What is SharePoint. Before we end this concept lastly I want to mention, SharePoint 2010 is only supports 64-bit. [There is no 32-bit anymore. ]So, all the infrastructure and the software like [Windows Server 2008, Sql Server etc] should be 64-bit.



Wednesday, April 13, 2011

The Advantages Of Article Source SharePoint Consulting

Microsoft SharePoint is one of the most popular platforms for cooperation between the organizations of labor and resources. It operates a web-based portal that allows users to create resources, such as a project extranet portals and team sites. It has helped millions of businesses around the world to improve workflow, increase productivity and improve cross-department communications.

If you are considering implementing Microsoft SharePoint MOSS or as we call it, then you have two options. You can operate the system on a server in-house or outsource to a supplier hosted SharePoint. Whatever option you choose, you'll be wise to seek advice from an experienced Microsoft SharePoint. The following article explains why.

lack of bias

SharePoint consultants are impartial and will be able to advise you on the best solution for your business, not the best solution provider. They take the time to get to know you and your personal situation that works with you to design a package that meets your needs. You will receive honest and impartial advice on all options available to you.


Most consulting firms Microsoft SharePoint only employ people who have passed a rigorous series of tests, which means they are well qualified and experienced in the latest developments.

SharePoint Architecture

SharePoint consultants will be able to help you install a custom SharePoint architecture that is tailored to your organization and its requirements

Cost Savings

A SharePoint consultant will be able to help you by seeking out the most cost effective solution for your business, whether this be in-house or outsourced.

The main reason most organizations outsource the pain of the SharePoint system has enormous costs involved in its execution. In addition, the initial cost of hardware, the server requires keeping the house for as long as the technician to manage it effectively. The cost of this can run into tens of thousands of pounds, which means that this is simply not viable for most companies.


Systems and data security is one of the biggest headaches for most companies. SharePoint consultants will be able to advice on all security options are available to you and help you find a safe house or external, or put in place measures to ensure that your house SharePoint server contains adequate security arrangements in place.


Sunday, April 10, 2011

Benefits Of Programming ASP Dot Net Over Java

On the one hand, Java has been used to make effective web development and secondly, ASP.Net allows programmers to create dynamic websites, web services and applications. But the issue is between the two which is better?

Both do not have any real comparison. Java is a computer language, where as ASP.Net is a web technology for generating web content. However, the biggest difference between the two is the basic philosophy behind the languages. Java is a programming language designed to be run on many different platforms, and so uses a common language which has to be compiled and run on different platforms (example: Windows, Mac and Linux). Microsoft, with their offering of ASP.Net, takes on a different approach, by allowing you to program in any language you choose, but has compilers for many different languages that generates a platform specific code (i.e. Microsoft or Windows)

Java to write programs for many different operating systems, and ASP.Net can be done in any programming language in the Windows program. This is all based on original design goals of the programming language, and has advantages and disadvantages over each other. Otherwise both are object-oriented programming language, their obvious differences in syntax.

It is to also important for us to know the advantages of ASP.Net programming over Java. One advantage is that you are not stuck with one language -a multi-language solution is easier to provide than with a java platform - you have the flexibility, for example, to libraries that were written in a different language from the one you are using. From my point of view, this is a theoretical advantage. It may also be an actual advantage, but you'll need someone with extensive experience to say for sure.

Another advantage is that it has the Visual Studio. Java main advantage is that you have the choice of third-party tools. Today, traditional business have emerged fully ecommerce business have great utility in the business sector. E-commerce solution for online auctions, online stores, classified ads, offers E, meetings, job boards, social networks and entertainment sites are created with the help of this program.

It is especially used for web designing whereas Java is used for designing both thick client windows desktop applications as well as wed applications. It is language independent. One might go on to suggest that the Java is "language independent" in the same way as ASP.Net is - however, the only difference is that it is not marketed as such i.e. there is no technical constraint that prevents this from occurring.

In this article, I am Sn reddy have clearly stated my thoughts when these two programming languages. Java and ASP dot net there is no real comparison, but certain advantages for ASP Dot Net Java demanding a solution for web developers.


Sunday, February 20, 2011

Updates to SQL Server SecuritySeparating schemas and users :

Microsoft has a whole new approach to security. In their own words: "We will reconsider our approach to security We will examine our code of vulnerabilities, we will release patches if necessary, we will disable most features by default to keep the low profile, if you need some ,.... thing turn it on. But if you do not need it, leave it sealed. This way, if vulnerability is discovered in a product that you do not, you will not be affected. "

Latest SQL servers have come with many additional security features of these features not only the database more secure, but also more comprehensible and easier to administer. Database applications can be developed by programmers, while operating privileges exact requirements, with new features added. This feature is called "principle of least privilege." A programmer is no longer necessary to function as an SA (system administrator) or DBA (Database Administrator).

Some key features have been added in the latest server version is:

Security for.NET

Combination of different SQL Server permissions. NET code security and privileges of Windows can be managed and run code the.NET. 3 different levels are used to decide which code can or cannot do outside and the inside of SQL Server.

The Password policies for the users of SQL Server : If you run SQL Server on a Windows 2003 Server and users are allowed to go through similar policies for integrated safety users.

To Map a SQL Server user to Windows credentials: Users of SQL Server have permission to use the Windows credentials when accessing external resources such as network shares and files.

Separating schemas and users : Schemas in SQL Server refer to the first-class objects that can be owned by a user, group, application roles or function. The fact that the definition of synonyms is allowed be it much easier to manage

Permissions grant : No need to login or users with certain roles to certain rights, are all granite table with the revocation to prohibit the grant, and verbs

Fresh security on the Server's metadata : You can not directly update the new metadata views, and only if a user has permissions to some metadata about individual objects, cannot list them.

Support of encryption keys and certificates : The latest security features allows the server to manage encryption keys and certificates, for use with Web Services SSL, with Service Broker, for new data encryption, and with code authentication.

The above are some of the many new security features in SQL join. But it will help give an idea of how Microsoft has tried to work hard to fix any shortcomings in earlier versions of SQL Server and how they did it much more secure than previous versions of this server.


Friday, February 18, 2011

ASP Programming Is Most Demanding Solution for Web Development Why?

Net ASP programming point used for developing dynamic web site development. Net ASP is a scripting language and a framework for web application. Net ASP programming is also useful in activities such as models, database management, frameworks, access to databases and other activities. As there are software programs available, but if we make a comparative analysis of the ASP programming Net programming is the most appropriate, affordable and safe for development. We can use different types of facilities.

ASP Dot Net development / programming is used for manufacturing various types of web applications. It can be used to develop software development of.NET and.NET desktop. This program is widely used in developing the variety of mobile applications for phone, Blackberry, etc. You can also support the migration of web applications and desktop to.NET ASP.Net AJAX / Atlas permission Web applications. Net ASP Programming is very useful in recruiting solutions. Provides shopping cart integration with various payment gateways. Also provides for the settlement of Hotel / Restaurant Management. This server provides database solutions for SQL Server 2000/2005/2008

ASP Dot Net development / programming has a very wide range of application development and web solution. It provides crystal-2008-Reporting. With a wide and extensive use in developing business to business (B2B) and business development for the application client (B2C) became the sponsor of choice.

Today, traditional business has emerged in business e-commerce ASP Dot Net development / programming has great value in the business sector. E-commerce solution for online auctions, online stores, classified ads, offers E, meetings, job boards, social networks and entertainment sites are created with the help of this dynamic programming. This application also provides options for many jobs.

This is one of a safe and secure platform for security, even if it is at the level of corporate data is to manage and store are using an ASP dot net development / programming. So you can rest assure that the programming and can sit comfortably and easily.


Programming ASP Net - Need for the Proposed Development and Changes

Tough ASP is not a programming language, but it is technology that is used to make development of web applications. Today, ASP net programming has become so famous because of its immense application and because of the amazing flexibility it has received, and this framework have been the first choice of contractors and developers themselves and play a major role in strengthening society. This technology is very useful for the company, employees, clients, customers and partners through the Internet.

Here are some list of preferred ASP dot network services are:

Asp.Net designing and developing
Creating B2B and B2C portal
E-commerce solutions
Web application development
Enhancement of existing application in. NET
Customization of existing application in. NET
Portal development

There are some other services which has got important web development services as well:

Programming service
Website Development service
Custom ASP Dot NET Development
Application Development

Net ASP point is very useful in activities such as design, database management and data access, etc. There are some other advantages of the ASP Dot Net programming, so the incredible platform for growth. Net ASP provides the most flexible platform to develop different applications and can download the entire dictionary to this.

ASP NET reduces development of codes so that it is fairly easy to develop, operates, and works of this great forum. Assuming programmers to develop outsourcing experienced developers in the country is highly recommended because it gives you high quality results as well as engaging and convenience with the lowest interest rate.

So the ASP network is the most fabulous platform if development is to support developers and professionals with a good company and reported.


Tuesday, February 15, 2011

The Search Capabilities of SharePoint

I was really wondering about the new search features in Microsoft SharePoint 2010. Is it really different from what is included in 2007? Well the answer is yes, or I think. Let me explain in detail.

First, SharePoint Search, you can get data of all types to both structured and unstructured. Structured data is your SQL Server objects and unstructured are your videos, pictures, etc. New in SharePoint 2010 are wikis and blogs. Yes, you guessed it! There are also stored in the SharePoint search.

Second, research can also be used as a people search. What I mean by that? Well, is John of the organization is a project manager. Wants to launch a project to its website for the customer. His first task is to find a designer. How will you do? Well, just go in search of SharePoint Designer and graph, what would the title of Kim. Perfect! He obtained his contact information and the arrow, the project is up and ready to go.

Thirdly, research is really smart. The organization's data can sometimes be very difficult to find. You have to go through tapes of the records. SharePoint search is actually smart enough to filter it. Using visual cues, which may allow users to see through many folders to individual files. You can then use these data files as needed.

SharePoint is really to help the organization function more efficiently. Using the enterprise search from your side, you can always get exactly what you want. Sometimes you may need a file and other times you may need a real person. Whatever your need is, the search is probably the answer.


Microsoft SharePoint 2010 Problems and Errors

I used SharePoint to manage my documents. Microsoft recently launched the SharePoint 2010. It has good features and exceptional. Microsoft has added new features, making installation easy. For ex. if you try to install SharePoint 2007, you must install several prerequisites before installing SharePoint 2007, but in the case of 2010, they have an installation program prior to automatically download and install all the prerequisites. Microsoft has tried their best to make a good product and in general they managed to do it, but as always, the product is released with many bugs as well.

I came across an error when installing strange conditions of SharePoint 2010. During installation, it has been downloaded assumptions, and I was surprised by strange errors. The total number of downloads of prerequisites was 24.59 MB. It took 30 minutes to reach this limit, and I hoped it would move to the next step. To my surprise, he kept on downloading and the counter began showing 24.59 of 25 MB downloaded. Although the counting time and the number of percentage shown 00:00:00 by remaining time and completed to 100%, respectively. The count went to the beat 36.9 MB 24.59 MB and then the next step. I think Microsoft can solve in the future

The product should be tested and many other mistakes or errors will be revealed. This is one of the errors I found while many experts have found numerous errors in the 2010 version of SharePoint recently.


SharePoint 2010 - Improved Top

With the release of Microsoft SharePoint 2010 has put the product in the year 2010 to their customers. After the completion and implementation of SharePoint 2007, Microsoft had thousands of companies to improve the next version, since all parts in SharePoint 2007 have met the expectations created by their marketing department. With SharePoint 2010 (formerly known as SharePoint 14) Microsoft provides a considerable upgrade of the product with many new and enhanced features.

SharePoint 2010 comes in different versions. SharePoint Foundation (formerly known as Windows SharePoint Services - WSS) and SharePoint Server (Microsoft Office SharePoint Server - MOSS) is renamed, but still the same as the difference between free and paid (server) edition. The server edition is available in Standard Edition or Enterprise and the (new) as compared to publishing Web sites.

With the new version of hardware and software, has changed. So now you can install SharePoint 2010 on 64 bit hardware with 64-bit and 64-bit operating systems and SQL Server 2005 or 2008. The implementation of SharePoint 2010 on new hardware with the new Windows Server 2008-OS is not really a problem, but the upgrade from SharePoint 2007 to Windows Server 2003 requires more time and resources.

When it comes to features SharePoint Server 2010 search or quick search to be mentioned. Research is now more scalable because you can use multiple servers to index the content that has not been possible in previous versions of SharePoint. In addition, you can use generic search and faceted browsing. With a new engine, including enhanced capabilities such as a pipeline of content processing, metadata extraction, visual search and advanced linguistics, you now have a better search experience with SharePoint 2010.

Be true for the use of reporting and registration is not something you would expect from the product of society, such as SharePoint 2007. When a new version becomes the new database is designed to support the use of reporting and recording. You have more information that could be treated in a way that you can use this information to optimize your site, or get information on how to use wireless users.

Have you ever met a SharePoint 2007 power user? Maybe not so much because SharePoint 2007 is required for a relatively high level of technical expertise. SharePoint 2010, you can now use standard tools like Visio to collaborate with colleagues, or create workflows. E 'can also view Visio diagrams in a browser (without the client application itself).

Speaking of enhanced collaboration features, you can now tag and rate content. You know social networking, but in an intranet by using SharePoint Server 2010 search results page is now created using scoring and marking. Content that has the right tags and a high score is most likely to be found and used. In addition, you can use a better editor to create content and blogs and wikis, to store or publish them.

SharePoint 2010 now supports a group of browser like Firefox. With XHTML 1.0 compliance and improving accessibility now, it's now more patch for Internet Explorer. By the way Internet Explorer 6 is no longer supported.