SQL Server Index Maintenance

After working on a problem where the transaction logs for a large database were filling to sizes larger then the actual database every night it turned out to be a server maintenance plan that rebuilt and reorganized indexes every night.  While working on designing a custom plan that would only rebuild or reorganize when actually…

2

Sending Encrypted E-Mails in C#

So I was faced with the problem of sending an encrypted email to a group of people.  Not really thinking, I responded with sure we can do that no problem. Getting back to my desk I started working on the project to find out that it turns out to be more difficult then I had…

3

Using certificates from the Windows certificate store

I recently had to setup some web services that used certificates to communicate back and forth and one thing I found is that pretty much every site I found references on was using a file on the file system to access the client certificate.  What we wanted to do was access the certificates directly from…

2

Downloading files from the internet in PowerShell (with progress)

Ok, so the easiest way (that I know of) to download files in powershell from the internet is to use the .net WebClient.  The simple way I started with was the two liner: $client = New-Object “System.Net.WebClient”$client.DownloadFile(“http://somesite.com/largefile.zip”,”c:\temp\largefile.zip” However I was working on a script that required some pretty large files to be downloaded, and using…

5

Importing a File Share into Document Library via PowerShell

So today I was asked for a way to automate importing files from a file share into a document library.  For this, ACL’s were not an issue, however using PS’s Get-ACL function can get you that as well to match the insert. Here is what I came up with as a quick and dirty response. …

1

Web Parts the Simple Way – Use User Controls

One of the first questions I usually get about SharePoint development is how to make the WebPart development process simpler.  My answer to that is use UserControls.  There is a very good solution on CodePlex called Smart Parts http://www.codeplex.com/smartpart  However I have found in some environments the customer does not want to add a third…

1