Archive

Archive for March, 2010

WSP Developing SharePoint Solutions in Visual Studio


SharePoint Solution
http://greggalipeau.com/2008/05/18/developing-sharepoint-solutions-in-visual-studio/
http://www.zimmergren.net/archive/2009/04/08/wspbuilder-walkthrough-of-the-visual-studio-add-in.aspx

http://geekswithblogs.net/evgenyblog/archive/2008/01/27/118966.aspx
===========================================================================================
http://msdn.microsoft.com/en-us/library/ms442108.aspx

SharePoint Feature
http://msdn.microsoft.com/en-us/library/ms414322.aspx

SharePoint Content Type
http://msdn.microsoft.com/en-us/library/ms463449.aspx

SharePoint Custom Field Type
http://msdn.microsoft.com/en-us/library/ms415141.aspx

Common Coding Issues When Using the SharePoint Object Model
http://msdn.microsoft.com/library/bb687949.aspx

SharePoint Development Best Practices – Checklist
http://itfootprint.wordpress.com/2008/08/19/sharepoint-development-best-practices-checklist/

Digging into Server-Side State Management
https://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032274890&EventCategory=3

SharePoint Dispose Checker Tool
http://code.msdn.microsoft.com/SPDisposeCheck

Sample code acceptance checklist for IT organizations
http://technet.microsoft.com/en-us/library/cc707802.aspx#Section2

Validating ASP.NET Server Controls
http://msdn.microsoft.com/library/aa479013.aspx

Improving Web Application Security: Threats and Countermeasures
http://msdn.microsoft.com/library/ms994921.aspx

Microsoft Anti-Cross Site Scripting Library V1.5: Protecting the Contoso Bookmark Page
http://msdn.microsoft.com/library/aa973813.aspx

http://www.devx.com/dotnet/Article/40007/1954
http://www.toddbaginski.com/blog/archive/0001/01/01/creating-a-custom-site-definition-in-wss-v3-moss.aspx
http://www.chrishines.com/techblog/default.aspx
http://greggalipeau.com/2008/05/18/developing-sharepoint-solutions-in-visual-studio/

http://bluesurftech.com/TechBlog/Lists/Posts/Post.aspx?List=f66fed30%2Da22a%2D43f6%2Da52b%2D5a2f3bedd6e7&ID=49
http://sharepointsolutions.blogspot.com/2006/10/anatomy-of-sharepoint-wss-v3-feature.html
http://www.devx.com/dotnet/Article/40007
http://yasirbutt.spaces.live.com/Blog/cns!A8677D5751E6B4DA!851.entry?sa=837172611
http://www.codeproject.com/KB/sharepoint/ExtendingSPS.aspx

http://www.sharepointforum.com/en-US/Wiki/Solution%20Package.aspx
http://wss.made4the.net/archive/2008/05/26/solution-development-in-sharepoint-2007.aspx

ADFS v2.
http://blogs.msdn.com/ekraus/

Custom Site Template
http://www.sharepointnutsandbolts.com/2007/08/creating-deploying-and-updating-custom.html

Webpart Silver light
http://blog.richfinn.net/blog/

Dotnet 4.0

Categories: ASP.NET, Microsoft

MSDN MOSS Videos

Categories: Microsoft, MOSS 2007

Deploying InfoPath forms from Development to Production

Categories: TFS

SharePoint 2010 Beta Virtual Machine

Categories: Sharepoint 2010

Backup-Restore MOSS 2007


Backup-Restore MOSS 2007

Open command Prompt navigate tothis path C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN> and type the below command

Backup
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsadm -o backup -url http://win2k364:8880/ -filename C:\8880bkp.dat

Restore

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsadm -o Restore -url http://win2k364:9090/ -filename C:\8880bkp.dat

Capture site content by using SharePoint Designer
=========================================
Back up a site by using SharePoint Designer
1. In Office SharePoint Designer 2007, on the File menu, click Open Site.
2. In the Open Site dialog box, browse to and click the Web site that you want to back up, and then click Open.
3. On the Site menu, point to Administration, and then click Backup Web Site.
4. In the Backup Web Site dialog box, to include all subsites of the current Web site in the backup, select the Include subsites in archive check box.
5. If the current Web site is low on available storage space, click Advanced, specify a new location, and then click OK.
Backing up a Web site requires a location to store temporary backup files. By default, Office SharePoint Designer 2007 uses the current Web site. You can use another site on the same server or a location on another server on the same network — for example, \\Server name\Share name.
6. In the Backup Web Site dialog box, click OK.
7. In the File Save dialog box, choose a location to store the .cmp file.
8. In the File name box, type the name for the file, and then click Save.
If the site that you are backing up or restoring is large, the process can take a long time.
Restore site content by using SharePoint Designer
This procedure can help you use Microsoft Office SharePoint Designer 2007 to restore a site.
Before you perform this procedure, confirm that you have read the topic Plan for backup and recovery (Windows SharePoint Services).
Restore a site by using SharePoint Designer
1. Create a new, empty Web site as a destination site
a. In Office SharePoint Designer 2007, on the File menu, click New.
b. In the New dialog box, on the Web Site tab, click General, and then click Empty Web Site.
c. In the Specify the location of the new Web site box, type or browse to the location to which you want to restore the backup site.
You can restore the site to a different server and you can restore it as either a new top-level site or a subsite under an existing top-level site.
d. Click OK.
2. Restore the backup file to the destination site
a. With the destination site open, on the Site menu, point to Administration, and then click Restore Web Site.
b. In the File Open dialog box, browse to and click the .cmp file that you want to restore, and then click Open.
c. In the Restore Web Site dialog box, click OK to confirm that you want to restore the .cmp file to the current empty Web site.
If the site that you are backing up or restoring is large, the process can take a long time.

 

Categories: Microsoft, MOSS 2007

SQl Date


Date Functions
—————-
select getdate() as currentDate,
dateadd(dd,1, getdate()) as nextdate,
dateadd(dd,-1,getdate()) as previousDate,
datepart(yyyy,getdate()) as currentyear, Year(getdate()) as currentyear1,
dateadd(yyyy,-1,getdate()) as previousyear,
dateadd(yyyy,1,getdate()) as nextyear,
datepart(mm,getdate()) as currentMonth, Month(getdate()) as currentMonth1,
dateadd(mm,-1,getdate()) as previousmonth,
dateadd(mm,1,getdate()) as nextmonth,
datename(mm,getdate()) as CurrentMonthName,
day(getdate()) as CurrentDay,
datename(dw,getdate()) as WeekDay,
datediff(dd,getdate(), ‘2008-12-31’) as daypendingfor_Newyear,
datediff(mm,getdate(), ‘2008-12-31’) as monthpendingfor_Newyear

*all date display style*/

select convert(varchar(20),getdate(),104) as ‘16.12.2008’
select convert(varchar(20),getdate(),105) as ’16-12-2008′
select convert(varchar(20),getdate(),106) as ’16 Dec 2008′
select convert(varchar(20),getdate(),107) as ‘Dec 16, 2008′
select convert(varchar(20),getdate(),108) as ’18:08:57’
select convert(varchar(20),getdate(),109) as ‘Dec 16 2008 6:09:08′
select convert(varchar(20),getdate(),110) as ’12-16-2008’
select convert(varchar(20),getdate(),111) as ‘2008/12/16’
select convert(varchar(20),getdate(),112) as ‘20081216’
select convert(varchar(20),getdate(),113) as ’16 Dec 2008 18:09:49′
select convert(varchar(20),getdate(),114) as ’18:10:03:357′
select convert(varchar(20),getdate(),103) as ’16/12/2008′
select convert(varchar(20),getdate(),102) as ‘2008.12.16’
select convert(varchar(20),getdate(),101) as ’12/16/2008′
select convert(varchar(20),getdate(),100) as ‘Dec 16 2008 6:10PM’

select @@DATEFIRST –give you value of first day of week 7 for sunday 1 for monday

–for example try it
declare @datefirst as int
set @datefirst = (select @@DATEFIRST )
SELECT @@DATEFIRST AS ‘1st Day’, DATEPART(dw, GETDATE()) AS ‘Today’
SET DATEFIRST 5
SELECT @@DATEFIRST AS ‘1st Day’, DATEPART(dw, GETDATE()) AS ‘Today’
SET DATEFIRST @datefirst

/*all varchar to datetime conversion format*/

select convert(datetime,’16.12.2008′,104) as date
select convert(datetime,’16-12-2008′,105) as date2
select convert(datetime,’16 Dec 2008′,106) as date3
select convert(datetime,’Dec 16, 2008′,107) as date4
select convert(datetime,’18:08:57′,108) as datetime1
select convert(datetime,’Dec 16 2008 6:09:08′,109) as datetime2
select convert(datetime,’12-16-2008′,110) as date5
select convert(datetime,’2008/12/16′,111) as date6
select convert(datetime,’20081216′,112) as date7
select convert(datetime,’16 Dec 2008 18:09:49′,113) as datetime3
select convert(datetime,’18:10:03:357′,114) as datetime4
select convert(datetime,’17/04/2008 00:00:000′,103) as date8
select convert(datetime,’2008.12.16′,102) as date9
select convert(datetime,’12/16/2008′,101) as date10
select convert(datetime,’Dec 16 2008 6:10PM’,100) as datetime5

Get Year
SELECT YEAR(’24 March 1964′)

Get Month
SELECT MONTH(’24 March 1964′)

Get Day
SELECT DAY(’24 March 1964′)

Getting Only the Date Part of a Date/Time Stamp in SQL Server
—————————————————————-
SELECT
— Get the full date/time stamp as a base.
(
GETDATE()
) AS date_time_part,

— Trying casting to a string then back to a date.
(
CAST(
(
STR( YEAR( GETDATE() ) ) + ‘/’ +
STR( MONTH( GETDATE() ) ) + ‘/’ +
STR( DAY( GETDATE() ) )
)
AS DATETIME
)
) AS date_only_part,

— Try casting to float, rounding, and back to date.
(
CAST(
FLOOR( CAST( GETDATE() AS FLOAT ) )
AS DATETIME
)
) AS date_only_part2,

— Try casting just to float to see what it looks like.
(
CAST( GETDATE() AS FLOAT )
) AS float_value,

— Try flooring to see the intermediary step.
(
FLOOR( CAST( GETDATE() AS FLOAT ) )
) AS int_value

Categories: SQL