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 on upsert strategies with SSIS.  What are "upserts"?  A...

Search Argument Case Study: WHERE the year was 2002…

Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...

Second Chances: PASS Community Choice Sessions

Recently I found out that my PASS presentation submission ‘Policy-Based Management’ has a second chance to be accepted for the...

SQL Server “Denali”: Details on the next version of SSIS

CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for...

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....

SQLServerCentral.com Track at SQL Server Connections This Fall in Las Vegas

As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...

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....

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...

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...

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