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,378 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,054 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,265 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,547 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,389 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,341 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,116 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
18,964 reads
Blogs
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Webinar – Microsoft Fabric for Dummies
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Forums
Looking for a Recommended Azure SQL Managed Instance Book
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
timeout in vs for ssas tabular deploy is 0 but i still timeout deploying
hi we run 2019 std but i'm testing this on 2016. following some old...
Table variable declared within cursor persists across loop iterations
If you run this code it creates a 2 row cursor loop. Within the...
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers