Starting and Stopping a Remote Service with PowerShell

A recent project I was working on required me to move folders from a staging location to a processing location....

Execute Permissions

Written by David Postlethwaite
Security of the SQL database is becoming more and more important these days yet I’m finding that...

SQL Server Backup – Inadvertent Striping

When I started working with SQL Server I got bit in the rear one day while I was testing backups....

Manic Monday......Notes from the field, Playing catchup

It's the beginning of the new work week, and as they say, it's Just Another Manic Monday....[Bangles]. 
I have a...

Presenting Upserts to PASS AppDev VC

Hopefully this crowd knows a little about what they're getting into!  John Jakubowski (blog|twitter) has graciously asked me to present...

End Of Month Function in Denali CTP 3

While playing around with Denali, I came across a function that I believe should have been included in SQL for...

Custom folders SSMS Add-In slightly delayed

I am desperately trying to finalize this add-in and it is very very close. I was performing another testing on...

SQL Injection is still actual :)

Here are two samples showing that SQL Injection is still here and dangerous !!!

source:xkcd.com

This use case is especially insidious

SQL Server 2008 R2 Developers Training Kit

If your looking for presentations, demos, hands-on labs and videos to help you better understand SQL Server 2008 R2, then...

My first PowerShell Script to Move Folders

I just had my first encounter with having to write a PowerShell script.  The request seemed pretty harmless when I...