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

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

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

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

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

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

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

Bad Admins: Stealing An Account

Yesterday I posted about manipulating group membership to get access to a SQL Server. Today comes attack vector #2: stealing an...

Effective Permissions on a Database

written by David Postlethwaite
Ever wondered who has what access to your database or a particular object within? With the ever...

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