Archive for June, 2010

xkcd and Penny Arcade fixes for the day

Had a very long week, but nothing like some humor to end the week on a high note :)

penny arcade – girls dig RAM

by the way, the bigger girl geeks dig the Apple iPad and the macbook pros :)

sudo

xkcd – regex

this one’s for ya, @GFritchey – (ScaryDBA)

VN:F [1.9.22_1171]
Rating: 10.0/10 (3 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Just wanted to share some common “tips” or “tricks” I find myself using over and over again when creating reports.

I think I’ve had this draft for a while, and just never was able to publish it because things got so busy. Anyway, I will just publish in parts. Better late (and something) than never (and nothing!)

Common Report Tasks

Common page headers and footers

Report (reportname) generated by DOMAIN/User on 02/03/2010 4:51:03 PM
="Report (" & Globals!ReportName & ") generated by " & User!UserID & " on " & Globals.ExecutionTime"

Page X of Y
="Page " & Globals!PageNumber & " of " & Globals!TotalPages

If you have start and end date parameters, and want to display them in your header or footer, with date formatted as MMM dd, YYYY
="Report Details from " & Format(Parameters!StartDate.Value, "MMM dd, yyyy") & " to " & Format(Parameters!EndDate.Value, "MMM dd, yyyy")

Read the rest of this entry »

VN:F [1.9.22_1171]
Rating: 9.7/10 (23 votes cast)
VN:F [1.9.22_1171]
Rating: +5 (from 5 votes)

Just blogged on the Black Ninja Site:

Programmatically and Selectively Revoke SharePoint Item Level Permissions Using PowerShell

VN:F [1.9.22_1171]
Rating: 6.5/10 (6 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

I would like to say a huge and warm thank you to all who attended my sessions for SQLSaturday#43 in Redmond. It was such a great event, and I hope you enjoyed the sessions – and enjoyed the whole day with all the wonderful speakers.

sqlsat43 redmond sessions

As promised here are the files for my sessions:
Read the rest of this entry »

VN:F [1.9.22_1171]
Rating: 10.0/10 (8 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)
`