SEARCH RESULTS
 
Showing 1-10 of 65 records
 
Expand article

Create DDL table in SQL Server 2005 to audit DDL trigger activity

2008-05-06 10:18:43 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
Each time DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. It's possible to log these events with an audit table and custom-made DDL trigger. In this tip, SQL Server expert Robert Sheldon walks you through designing the audit table, defining the DDL trigger and then...
 
Tags: ddl trigger, table, custom-made ddl trigger, audit table, ddl trigger fires, sql server, time ddl statements, commands, event
 
 
 
 
Expand article

NatWest bank heads phishing league table in the U.K.

2008-01-22 00:00:00 by HASH0x8b3a240 in Network World on Security
 
Antispam outfit ClearMyMail has published a league table of the U.K.'s most 'phished' brands, with the NatWest bank way out in front as the most targeted name
 
Tags: league table, antispam outfit clearmymail, bank, front, brands
 
 
 
 
Expand article

Simplify queries with SQL Server 2005 common table expressions (CTEs)

2008-02-15 12:03:37 by Abbey M. Weintraub in WhatIs: Enterprise IT tips and expert advice
 
Common table expressions (CTEs) are a handy alternative to using derived tables and views in SQL Server 2005 for retrieving data. There's no need to repeat complex code because CTEs separate code into unique units and they're self-referencing within your query. Here's a CTE how-to with examples, including details for one of its most valuable...
 
Tags: common table expressions, ctes, repeat complex code, code, sql server, recursive query, query, unique units, cte how-to
 
 
 
 
Expand article

Querying system catalog tables to determine table alias

2008-07-18 14:24:36 by Kent Milligan in WhatIs: Enterprise IT tips and expert advice
 
In order to determine the alias of a table in DB2 on i, you can query the system catalog tables. AS/400 expert Kent Milligan shares how
 
Tags: system catalog tables, table, determine, alias, db2, query
 
 
 
 
Expand article

Malware Serving Online Casinos

The Article has images
2007-11-29 16:37:13 by HASH0x8968208 in Dancho Danchev's Blog - Mind Streams of Information Security Knowledge
...table part two. The following three online casinos are currently serving embedded malware in the form of IFRAMES and the average javascript obfuscation The first one is poker.gagnantscasino.com (213.186.33.4) with current obfuscation loading statistics-gdf.cn/ad/index.php (116.0.103.133) where another obfuscation loads, deobfuscated attempts...
 
Tags: obfuscation, current obfuscation, obfuscation loads, play poker, poker, internal url statistics-gdf, statistics-gdf, average javascript obfuscation, php
 
 
 
 
Expand article

How to maintain SQL Server indexes for query optimization

2008-03-19 11:33:36 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
Maintain your SQL Server indexes with these techniques for page splits, table partitions, statistics updates and for limiting fragmented indexes. You'll also learn why query optimizer might choose to ignore your non-clustered index and instead opt for a table scan
 
Tags: sql server indexes, indexes, query optimizer, maintain, page splits, table partitions, table scan, statistics, opt
 
 
 
 
Expand article

Virtual Environments will be more secure than their physical counter parts by 2010

The Article has images
2008-03-22 18:29:17 by John Peterson in Security In The Virtual World
...table is not only cost savings for server consolidation, power consumption and datacenter space but the ability to do all of those things for parts of your security infrastructure as well Imagine instead of having to deploy engineers to install 20 firewalls across your datacenter, you could sit from a single workstation with a couple of guys...
 
Tags: security concerns, application security concerns, virtual, concerns, server, virtual server, virtual appliances, security infrastructure due, lift
 
 
 
 
Expand article

Making a file with an automatic key in iSeries with DDS keyword

2008-05-09 12:42:32 by Kent Milligan in WhatIs: Enterprise IT tips and expert advice
 
If you want to create an automatic key using a DDS keyword on AS/400, Kent Milligan explains that any native writes performed against an SQL table created with an identity table will result in DB2 generating identity values
 
Tags: dds keyword, automatic key, kent milligan explains, native writes, sql table, identity table, identity values, db2, as400
 
 
 
 
Expand article

Virtual Environments will be more secure than their physical counter parts by 2010

The Article has images
2008-03-22 18:29:17 by John Peterson in Security In The Virtual World
...table is not only cost savings for server consolidation, power consumption and datacenter space but the ability to do all of those things for parts of your security infrastructure as well Imagine instead of having to deploy engineers to install 20 firewalls across your datacenter, you could sit from a single workstation with a couple of guys...
 
Tags: security concerns, application security concerns, virtual, concerns, server, virtual server, virtual appliances, security infrastructure due, lift