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

SQL Server “Denali”: Installing SSAS Multidimensional vs Tabular Mode

As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since...

Android Game: Slice-It

The eternal challenge with games, and free/cheap software in general, is knowing what’s out there, especially since you don’t always...

Re-blog – July 8-July 14

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

Tracking table changes seamlessly with Change Data Capture (CDC)

I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...