Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: David Ziffer

SQLServerCentral.com profile

   Items 1 to 8 of 8   
 

Writing Nearly Codeless Apps: Part 5

In this next installment of the series on writing codeless applications, David Ziffer looks at the querying of data from the database.  Read more...
By David Ziffer 2010/11/03 | Source: SQLServerCentral.com | Category: software development
Rating: |  Discuss |   Briefcase | 5,306 reads

Writing Nearly Codeless Apps: Part 4

Part four of this series on rapid application development looks at the CRUD routines that are needed for almost every application.  Read more...
By David Ziffer 2010/10/27 | Source: SQLServerCentral.com | Category: software development
Rating: |  Discuss |   Briefcase | 6,978 reads

Writing Nearly Codeless Apps: Part 3

As we continue in this series, see how auditing tables are used to track all changes that are made to the main data tables.  Read more...
By David Ziffer 2010/10/20 | Source: SQLServerCentral.com | Category: software development
Rating: |  Discuss |   Briefcase | 8,198 reads

Writing Nearly Codeless Apps: Part 2

In this article, learn why it makes sense to build a more standarized, more robust database based on rules and see how data modeling works in the RAP software.  Read more...
By David Ziffer 2010/10/13 | Source: SQLServerCentral.com | Category: software development
Rating: |  Discuss |   Briefcase | 10,441 reads

Writing Nearly Codeless Apps: Part 1

A new series from David Ziffer describes a way of building applications in a more standardized fashion, and it provides a basic review of some software that can help.  Read more...
By David Ziffer 2010/10/06 | Source: SQLServerCentral.com | Category: software development
Rating: |  Discuss |   Briefcase | 18,250 reads

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,310 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,977 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: sql clr
Rating: |  Discuss |   Briefcase | 18,367 reads
   Items 1 to 8 of 8