The information for this year’s Baton Rouge SQL Saturday & Tech Day came online this past week. It’s scheduled for August 4, 2012.
Free SQL Server, SharePoint and .NET training! Chance to win great prizes! What more could an IT Professional ask for? If this sounds good to you, then don’t miss your opportunity to attend SQL Saturday #150 and TECH Day, the largest FREE training event in Louisiana dedicated exclusively to SQL Server, .NET, Development, SharePoint and Business Intelligence. This is a COMMUNITY driven event!
For more information visit the official website at: http://sqlsaturday.com/150/eventhome.aspx
The following script is what we’ve been using to create site collections with their own database in SharePoint 2010.
Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue
## Configure the script
$databaseName = "SP_Content_Database_Name"
$webApplicationUrl = "http://localhost"
$siteCollectionUrl = "http://localhost/sites/siteName"
$siteCollectionName = "Site Collection Name"
$siteCollectionOwner1 = "DOMAIN\user1"
$siteCollectionOwner2 = "DOMAIN\user2"
$siteCollectionTemplate = "STS#1"
## Create the database
New-SPContentDatabase -Name $databaseName -WebApplication $webApplicationUrl
## Create the site collection
New-SPSite -URL $siteCollectionUrl -OwnerAlias $siteCollectionOwner1 -SecondaryOwnerAlias $siteCollectionOwner2 -ContentDatabase $databaseName -Name $siteCollectionName -Template $siteCollectionTemplate
Download the above code at: https://gist.github.com/4488619
If you need a list of site templates available on the machine you can run:
Get-SPWebTemplate | Sort-Object "Title"
The materials (code and PowerPoint deck) from my presentation at SharePoint Saturday New Orleans 2011 can be downloaded using the following links: