Ideas I think the SQL Server team could use to build some future products. These most have to do with SQL Server Management Studio tools improvements that would be leveraged (in time) into Visual Studio.
Figure out how to incorporate business metadata into the design and the database. User-defined properties/policies to be incorporated into table definitions. This includes (but is not limited to) Min, Max, Mask, default, caption, font, date created, date updated etc.
Figure out how to build user-interface and business rule -based validation from the database metadata. Data-driven application development would follow so the TableAdapter classes would be more than just “type safe”—they would permit generation of code to do data validation at the root level—where the invalid data is generated and can be corrected.
Figure out how to rebuild generated code in Visual Studio when schema changes. This is a critical aspect that we’ve been asking for since 1995.
Functional blocks: Sales might change 5 or 55 tables via SPs. Think about creating ways to represent and manage/execute a series of related stored procedures. Leverage the work done by SQL Server Service Broker.
Expose “application” registration to track application/object dependencies—even manually.
Manage user rights over objects graphically. Permit Visual Studio to create “run-as” persona impersonations to debug the application as these users.
Leave a comment