dba
SQL 102 – DENY
Alright, at this point you should know how to GRANT permission to a database object, but do you know how to DENY permission to an object? DENY uses a syntax
Latest
SQL301
Intro to XML, Part The Second
Last time I gave you a short introduction into XML. I covered the very beginning of what it is, what you use it for, and I even showed you an example file. This
SQL301
XML, in as Few Posts as Possible
Ok, I know I have a few groups of posts started, so you won't mind me starting another one, right? Right, so this collection of posts will be all about XML. If
microsoft sql
New DATETIME Data Types in 2008
We all know that in previous versions of SQL Server 2008 we have just one data type for storing date and time data, DATETIME. The problem is sometimes we only
Energy Independence and Robin Hayes
The following is a letter I sent Congressman Robin Hayes today. He sent out a letter assuring his constituents that he “felt our pain at the pumps”. I highly doubt that, considering the $75,250 he received from “Energy Concerns” for his 2006 election. — Dear Robin Hayes: While we need...
SSAS
Business Intelligence Concepts
The phrase business intelligence is pretty old, 1958. In the early 90's the term came to refer to the "concepts and methods to improve business decision making
career development
SQL Session – Automating Perfmon & Trace
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
microsoft sql
Killer Feature Reporting Services 2008
Reporting Services in SQL server 2005 does amazing things. But it has one drawback. To make it fly you have to be using Visual Studio. That's fine for us, the
career development
SQL Session – Transactional Replication for Beginners
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
Posted in: Microsoft SQL
Another Cover Story
I’ve contributed another story to ficlets. This time I added a sequel to another author’s work. Russell Ruffino created an interesting start with “Day 44″. I followed up with “Another Cover Story“. I’ve included it here —– “We rounded up another 34 today sir…” The young lieutenant reported matter of
Judicial Execution
The following post is actually from my ficlets account. It’s a site for short fiction, very short… 1024 characters is the maximum space you get to tell your story. Feel free to comment here, or at http://ficlets.com/stories/21152 about this story. I plan on releasing a new chapter each week. —–...
Posted in: Personal
New Photos at DeviantArt!
I’ve added a few photos from my trip to Raleigh, NC last December. I took the backroads to get there. I wasn’t interested in making good time. I was more interested in seeing what had changed in the last decade. You see, back in 1995 I was a up and...