Danny Lesandrini

One Microsoft Access developer’s search for an exit path from Access into .Net development led him to Microsoft Silverlight and MVC2. If you’re serious about adding technologies to your toolkit, are looking for a web solution or just something new, Silverlight or MVC2 might be it. My February 2010 article about how Microsoft Access still […]

SQL Server Management Studio has some neat tools for keeping database objects in source control, but they only work if everyone is on board. Red Gate SQL Source Control is a simple and elegant solution that doesn’t depend on other developers using the snap-in… and it works. I’ve been using Red Gate products since the […]

Danny Lesandrini scopes out a bundle of newly released books geared towards getting you up to speed quickly with Microsoft Access 2010. Back in August of 2009 I wrote about my experience with the Micorosoft Access 2010 beta. I concluded that this was the most exciting release of Access I’ve seen in some time and […]

Learn one database developer’s top reasons for attending developer conferences, if they’re worth the money and will he attend again. This particular article offers the authors opinions on the recent Developer Connection Visual Studio 2010 Launch Event. I’ve been to a number of conferences over the last ten years but this is the first time […]

The ‘Excel Analyst’s Guide to Access’ is especially good for Excel users who need an introductory but aggressive tutorial into the world of Microsoft Access. Read on to find out why Danny Lesandrini decided to keep this particular book in his own personal library. When you have a hammer, everything looks like a nail. Since […]

Backup and recovery solutions for Microsoft Access abound. Danny Lesandrini shares some of the utilities he has collected over the years and what he finds practical to use on a daily basis. Download for Article: Maint_Scripts.zip At first, I wondered if there was enough information on the subject of file maintenance for Access MDBs but […]

Microsoft Access Small Business Solutions, published by Wiley, proves that Microsoft Access can be used to create valuable business solutions in theory and in practice by providing both the reasoning for the database design and the databases themselves in the CD that accompanies the book. So much of our information comes from online sources these […]

In this economy IT professionals have to make smart choices when it comes to spending money on developer tools. Does the new Intellisense feature of SQL Server 2008 Management Studio make third party intelligent code completion tools like Red Gate SQL Prompt obsolete? I’ve been a big fan of Red Gate tools for SQL Server […]

If you need to migrate your Access application to SQL Server, don’t count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you’ll have to rewrite them in T-SQL. I was […]

Microsoft Access is fun, but it’s also powerful and more importantly, it has a place in the development community and in the real world of production applications. What follows are the top 10 reasons why Danny Lesandrini believes this is still true. When this 20-something programmer-kid who reports to me happened to notice the title […]

Preparing this book review, I felt a little like George Costanza from Seinfeld. Remember that episode where George had to read the book Breakfast at Tiffany’s for a book club he had joined. He went to great pains to find and watch the movie because he was too lazy to read the book. This book […]

I chose this topic because it sounded fun but I know it’s the kind of thing that could start a holy war among developers and DBAs. After all, who am I to tell anyone how they should name tables and fields? Actually, I’m not the worst choice for advice on naming schemas. It’s something I’ve […]