Parts databases for the electronics industry may be the best way to find parts and to get details about them, but they're also remarkably incomplete, or just plain wrong. Even at 95 percent ...

When is a database not a database? When it is a spreadsheet. What do spreadsheets have to do with databases do you ask? Spreadsheets are actually very rudimentary databases and, while not advisable, ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

It’s tempting just to replicate all databases in the cloud, but it’s a much better approach to get your data house in order as part of the move. Last week I discussed database normalization as a best ...

Welcome to the first of a two-part series. In this first part, I'll talk about the physical infrastructure that Microsoft uses to ensure availability and provide a high degree of uptime for the Azure ...

Here are the details to two versions of Product Tables, one for Access 2000/97 and one for SQL Server 7. Not all of these fields are necessary in one database. For example, with Size and color you can ...

Finding the JLCPCB component parts library frustrating to navigate, [Jan Mrázek] took matters into his own hands and made an open-source parametric search utility. We’ve all probably wasted time ...

In the second part of this series, Joey describes the methods that Microsoft uses to manage code rollouts, and how it detects hardware and software problems on Azure SQL. In Part 1 of this series, you ...