Connect to Remote Powershell $UserCredential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection Import-PSSession $Session Create a new move request (with an existing remote powershell open) $OPCred = Get-Credential ### use CORP\user.name.1 New-MoveRequest -Remote -RemoteHostName mrs.onpremdomain.com -RemoteCredential $OPCred -TargetDeliveryDomain tenant.onmicrosoft.com -SuspendWhenReadyToComplete -Identity [email protected] -BadItemLimit
One of my favorite recent discoveries in my SQL Server work recently, is the awesome T-SQL “CASE…WHEN…THEN” statement. I can’t describe how much I love this thing. It’s pretty simple really: SELECT CASE WHEN fruit = ‘apples’ THEN ‘not oranges’ WHEN fruit = ‘oranges’ THEN ‘not apples’ ELSE ‘neither apples
The ultimate lazy backup script. I wasn’t feeling to selective about which databases to backup, and I figured, it’d be best to back them all up, even that testing database I occasionally use for data import/export. Never know when I might need it again… This sits inside a SQL Server
I left the homeland, Australia, in early January. My employer proposed an opportunity of a lifetime, and alas, here I am now in Seattle, the capital of IT for those Microsoft-ies among us. One of the things I am passionate about, is photography, and it is on that note of
You’re designing a new SQL Server infrastructure for a client, but can’t remember if that high availability solution topology requires shared storage or not, and need to quickly look it up without searching through TechNet. How? With this application! Some genius has combined all of Microsoft’s server architecture posters into
Today, Microsoft launched Windows 8 to the masses. And I’m frustrated. Over the past year, I have had the opportunity to play with Windows 8, blowing away my daily work laptop and installing the new operating system at each release – beta, release preview, consumer preview, and RTM. Yes. A