The Assumption I assume you already have a Hyper-V basic configuration on your system, be it a laptop, server or “other” with at least 1 client/guest VM running. Whatever you have it running on, you are going to need to take a few additional, and very simple, steps to get your host and guest machines talking to each other. I …
SQL Server’s TIMESTAMP Is Not What You May Think It Is.
TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL Server is not what you may think it is. I know right? The general consensus seems to lean towards it just being a bad naming decision by someone at Microsoft. The TIMESTAMP in SQL Server is actually a row version that is automatically generated and, if used properly, …
The Poor Man’s SQL Backup Encryption
Well, that was interesting While playing around with demos to use in my newer session, Hacking Exposé Too (See it at Summit 2015 or during the 24HOP Summit Preview next week!), I stumbled across a fun demo that one could call the poor man’s encryption for backups. It was quite simple to do, and if you are running a version …
Checking for Excessive Permissions in SQL Server
Who can do what? One of the key things that a DBA should know in their database is what can users actually do. In this post I want to focus on one of the many checks performed in the sp_WOxCompliant script I have available for download here. This script has been modified so you can run it on its own …
The Problem With AshleyMadison
What is the real problem with the AshleyMadison data breach? Well, let me start with what problems I do not have with the whole debacle. First off, it is not what the purpose of the site was. If you feel you must do what the site was promoting and enabling, that is your choice. Until it starts to affect me …
Sneak Preview – Episode 014
Let’s Play A Game! So, just to tickle your fancy, here is a sneak preview of the podcast interview coming up this Friday! [divider] [powerpress] [divider] See if you can figure out who it is before the episode airs and you can win pride in having figured it out. No seriously. That’s it. Well, maybe you can feature in one …