Posts belonging to Category SQL Server

Developer Download: Access-SQL Server Optimization

The Best of Both Worlds: Access-SQL Server Optimization http://www.jstreettech.com/files/Best-of-Both-Worlds.zip Access can be used to build great front-end applications for SQL Server databases, as long as you know how to optimize for performance. This slide deck shows you the basics of using Access as a client-server application so that you can leverage the full power of […]

J Street Case Study: Bellevue Botanical Garden

We design and create a LOT of databases for a variety of clients and we end up with some really interesting projects! One of these is the database for Bellevue Botanical Garden.  We built a custom database allows everyone to search and explore their garden online!  Check out the Case Study here.

Developer Download: The Best of Both Worlds: Access-SQL Server Optimization

The Best of Both Worlds: Access-SQL Server Optimization: http://www.jstreettech.com/files/Best-of-Both-Worlds.zip Access can be used to build great front-end applications for SQL Server databases, as long as you know how to optimize for performance. This slide deck shows you the basics of using Access as a client-server application so that you can leverage the full power of […]

Case Study: Alaska Cruise Quotes

A detailed look at the custom development of Alaska Cruise Quotes.

Case Study: Teck Resources

We love that we get to work with a vast array of clients on projects of all types!  Here is a case study on the SiteLine project that we built for Teck Resources.

J Street SQL Tools

Have you ever wanted a simple way to modify part of a SQL Statement in your VBA code? With these J Street functions, you can easily replace the Where and Order By clauses of any SQL Statement. This enables you to reuse query definitions, manipulate rowsource properties, and use passthrough queries with more flexibility. Leave […]