t-sql
Insert Triggers
An insert trigger is a Data Manipulation Language (DML) trigger that acts when a new record is added to the table. CREATE TRIGGER t_tableName_insert ON
Latest
SQL102
SQL 102 – REVOKE
Like I mentioned previously REVOKE is like an undo function for GRANT and DENY. If you have a developer and you work with him for a while, you may find that
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
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