I will be in Connecticut next week participating in two events, first up: Connecticut Access Users Group - Thursday February 27th 6 PM I'll be presenting on "Building Access Dashboards with SQL Server", where we will discuss leveraging the power of SQL Server to harness many queries in one procedure [...]
This winter Microsoft provided all MVPs at the annual summit with a heavily discounted Microsoft Surface RT second generation. It promptly got sequestered by my wife, but I was intrigued enough to go out and purchase a Surface Pro 2 and give up my cherished IPad Mini in the process. I would use the [...]
This is part two of our two-part series on working with XML data with a SQL Server backend. Part one can be found here. In part one, we showed how much simpler and effective it was to manipulate XML data by doing it directly in the SQL Server layer as opposed to front-end or middle-layer code. The i [...]
This is part one of a two-part series that discusses working with XML data with an SQL Server backend. Part two is discussed here. I've personally found XML files to be something of a bugbear. They're going to require some kind of transformation to get it in a format that's useful for importing or e [...]
In part one, Juan talked about the sequence of events fired when loading a form with a number of subforms in Access and how one can reduce the cascading effects of events being re-fired due to operations performed during the load. We will talk about how we can delay loading the subforms. By putting [...]
We use subforms in Access a lot around here. Sometimes, we may have upwards of 5 or 6 subforms per form. Adding that many can be a real drag on performance if you're not careful. This is part one of two posts on the topic. Ben will talk about disabling the loading of subforms on startup in our next [...]
Check out the SQL Stairway Series for some great training on SQL Server: http://www.sqlservercentral.com/stairway/ Enjoy! [...]
As I'm writing this I'm seated next to Ben on the Microsoft campus during our yearly pilgrimage to Redmond. (I call it getting re-charged at the mother ship). What is the future? We are hearing about it this week. One of the advantages of being an Access MVP is the ability to meet and share with the [...]
We talked about concatenating multiple records into a single string using FOR XML PATH and we also talked about EXISTS clause. Here's a practical example that incorporates both. In one of our projects, we have an archive database that contains historical data of select tables from the production dat [...]
UPDATE: Had a great turnout at the event, thanks for all who came out! Update: Here is a trailer for the presentation: Starting your own consulting practice - Trailer from Juan Soto on Vimeo. [...]
We are specialists in creating Access to the cloud solutions using SQL Server. We therefore maintain a number of databases and our clients are constantly asking us for improvements. Of course, we require that those go through a full cycle of testing and deployment: We copy an existing database using [...]
