SharePoint and TFS Integration

http://blogs.msdn.com/b/teams_wit_tools/archive/2009/06/01/sharepoint-integration-in-tfs-2010-beta1.aspx

Create Table Script in Sql Server

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TableName](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[ColumnName] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO

....Creates a table with ID as Primary Key with an increment 1 starting with 1

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TableName](
[ID] [bigint] IDENTITY(0,1) NOT NULL,
[ColumnName] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO

....Create a table with ID as Primary Key with an increment 1 starting with 0

Alter Table Sql Server 2008

The Alter Column statement can modify the data type and the Nullable attribute of a column. The syntax is the same for SQL Server 2005 and SQL Server 2008 except 2008 allows the sparse attribute to be changed.

For the example below, we will begin by creating a sample table, then we will modify the columns.

CREATE TABLE dbo.Employee

(

EmployeeID INT IDENTITY (1,1) NOT NULL

,FirstName VARCHAR(50) NULL

,MiddleName VARCHAR(50) NULL

,LastName VARCHAR(50) NULL

,DateHired datetime NOT NULL

)



-- Change the datatype to support 100 characters and make NOT NULL

ALTER TABLE dbo.Employee

ALTER COLUMN FirstName VARCHAR(100) NOT NULL



-- Change datatype and allow NULLs for DateHired

ALTER TABLE dbo.Employee

ALTER COLUMN DateHired SMALLDATETIME NULL



-- Set SPARSE columns for Middle Name (sql server 2008 only)

ALTER TABLE dbo.Employee

ALTER COLUMN MiddleName VARCHAR(100) SPARSE NULL
Columns can be altered in place using alter column statement.

•Only the datatype, sparse attribute (2008) and the Nullable attribute of a column can be changed.
•You cannot add a NOT NULL specification if NULL values exist.
•In order to change or add a default value of a column, you need to use Add/Drop Constraint.
•In order to rename a column, you must use sp_rename.

For Primary Key and Foreign Key Constraints:

Alter table dbo.TableName add primary key (ID);

Alter table dbo.Table Name Add constraint columnname_id_refs Foreign key ("columnname") References dbo.TableNamewithPrimaryKey ("PrimaryKeyColumnName");

Database backup File Location

\\Server\d$\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup

OfCourse you can change, but this is default one to go.

NOte: regarding the error when taking back up saying, media is supported with 2 families ..
The above path is teh culprit..take out that one and add new one ...it wont complain...if you keep this one and change the other one..it will complain like..access denied or media support...bla blah

Popup in SharePoint using LyteBox

1. Download the Lytebox files from http://www.dolem.com/lytebox/lytebox_v3.22.zip
2. Create a Document Library
3. Create images folder inside the Document Library
4. Upload files and Upload image files in Images folder respectively.
5. Go to any page you wanna use this feature.
6. Edit the page and add content editor web part.
7. In source view add
<script type="text/javascript" language="javascript" src="NameofLib/lytebox.js"></script>
<link rel="stylesheet" href="NameofLib/lytebox.css" type="text/css" media="screen" />
8. Add Another Content Editor Webpart
9. In Souce View Add
<A href="www.google.com" rel="lyteframe" title="My Page" rev="width: 600px; height: 700px; scrolling: no">Google</A>
10. Exit the Edit Mode

Note: Twaeking the Point 7 may require when stylesheet is not getting referenced.
Like using "../NameofLib/lytebox.js"

Version Build Numbers LookUp

http://www.sharepointgally.com/2010/03/moss-2007-windows-sharepoint-services.html