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

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