SQLServerCentral - Guest Columnist: David Ziffer

Use Excel to DIFF Your Query Outputs

Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel. Read more...

By David Ziffer 2008/12/31 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Discuss |

Briefcase | 1,055 reads

Build Great Looking Excel Spreadsheets

Exporting data from your database and building reports is easy with Reporting Services, but sometimes you need to use other sources Read more...

By David Ziffer 2008/11/05 | Source: SQLServerCentral.com | Category: Excel

Rating:

|

Discuss |

Briefcase | 17,243 reads

Creating a generic audit trigger with SQL 2005 CLR

Auditing is becoming more important all the time for DBAs as regulations and requirements increase. Building auditing into your systems can be done a number of ways, but with SQL Server 2005, you have a new option. New author David Ziffer brings us a generic auditing CLR trigger. Read more...

By David Ziffer 2006/08/02 | Source: SQLServerCentral.com | Category: SS2K5 - CLR Integration

Rating:

|

Discuss |

Briefcase | 16,179 reads