Summary Occasionally, when you’re making a lot of design changes to a Microsoft Access database, Access might start crashing when you’re working with that specific database file or when trying to enter the VBA environment with ALT-F11. This leaves you unable to investigate the issue or make further changes. It can be a sign that there are errors within the project’s…
All posts in Database Design
Coming in October – MySQL Explained (updated)
My newest book, MySQL Explained, is due to be published this month! You can check out the LeanPub page to show your support and to sign up for notifications of when it’s published. See the description of the book below. UPDATE 10/24/2015 – MySQL Explained is now available in both EPUB and MOBI (Kindle) formats…
SQL Server for Beginners: Part V – Using SQL Server 2012 LocalDB
In a previous chapter, I described the installation process for SQL Server 2012 Express which included all the bells and whistles of the advanced services package. While it’s great to have all the tools at your disposal to learn from, some people might not want such a large installation on a particular machine or the…
SQL Server for Beginners: Part IV – The AdventureWorks Database
In the last part of this series I wrote about SQL Server Management Studio (SSMS), the interface that enables you to work with SQL Server objects such as databases and tables. The program enables you to do quite a bit with a SQL Server installation. You can create entire databases and manipulate all the objects…
SQL Server for Beginners: Part III – SQL Server Management Studio
Once you have SQL Server and all the necessary updates installed, the next step is to learn how to create databases and work with them. The easiest interface available to the beginner is Microsoft SQL Server Management Studio (SSMS), a graphical environment where you can view and manipulate all of the databases and other objects…
SQL Server for Beginners: Part II – Installing SQL Server Express
Just like with any software, SQL Server uses a standard installation program to install its components on your system. Depending on the edition that you’re using, you will be installing it from media that you purchased or from the free install packages that you can download from Microsoft’s website. Unlike other installs, the SQL Server…
SQL Server for Beginners: Part I – From Desktop to Network
In an earlier series of articles, I wrote about getting started with Microsoft Access, which is one of the foremost desktop database packages available and an excellent tool for small to mid-size database projects. While it was not the first database software that I used, it was the one that took me from novice to…
What You Need to Know About Database Technology
In the modern world, our daily activities follow and leave a rich trail of electronic data from e-mail and text messages to credit card transactions and medical records. At its simplest, the data could be an address book or contact list stored in a text file while more complex information such as a store’s inventory…
Installing SQL Server 2012 Express on Windows 8
Doing this tonight. Found out that the .Net 3.5 framework needs to be disabled by turning it off under the System Programs and Features. Otherwise, the installation is still trying to install the setup files after more than an hour. One of Windows 8’s little quirks. See this link for more … http://social.msdn.microsoft.com/Forums/sqlserver/en-US/18f60327-d4ce-407d-ace8-9fc98e52c37c/sql-server-2012-express-is-not-compatible-with-windows-8?forum=sqlsetupandupgrade
‘Your First Guide to Database Design’ – Now available in Adobe PDF!
My latest book is now available on Scribd.com in Adobe PDF format. That means that even if you don’t have a Kindle or a Nook, you can STILL learn how to organize any kind of information and create your own database applications. In a world so completely dependent on the flow of information, this is…