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

SQL Saturday 89 Pre-Con

Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89...

How to move the TempDB Database

Note that TempDB is recreated every time SQL starts.  Why is this important?  It means we don’t have to move the...

SQL Server 2008 R2 Service Pack 1 Released

Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...