Other News

Editorials

Code Naming Conventions

Database Naming – One Last Time I had some good thoughts come through from a few readers today that I felt were helpful and touched on areas we haven’t really covered at this point. So, I’ll drop them in here without comment, and move on with the discussion about code naming conventions in the editorial section. Ken provides some thoughts […]

Uncategorized

Foreign Key Names

Foreign Key Names Today Thomas shares his thoughts on constraint names as well as indexes: For Foreign keys I use FK_PARENTTABLE_parentcol1_parentcol2_CHILDTABLE_childcolum1_childcolumn2 Currently, we don’t have any keys more complex than 2 columns and we are well under the 128 character limit. Our child column names are usually the same as their parent’s so I’ll probably resort to some kind of […]

Community

Transforming Event Log Data

(Chad Miller) Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module audits all security administration activity to a custom Windows Event log. In this blog post, I’ll described a process to transform and incrementally