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.
2010-11-03
5,382 reads
David Ziffer
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.
2010-10-27
7,057 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.
2010-10-20
8,276 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.
2010-10-13
10,552 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.
2010-10-06
18,397 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.
2008-12-31
1,345 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
2008-11-05
18,143 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.
2006-08-02
19,021 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Lies You Should Believe - Anything is possible
Comments posted to this topic are about the item Lies You Should Believe -...
A Strange Query
Comments posted to this topic are about the item A Strange Query
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers