Author: Ben Taylor

Editorials

Passwords are Dead

I came to this topic from Eilenblogger’s comment on one way hashing. He reminds me that most systems using passwords have a number of requirements to make them more difficult to crack. You’ll see a lot of rules: The password must be so many characters long The password must have an upper case letter The password must have a lower […]

Editorials

One Way Hash

I’ve had the opportunity to work on private data once again. Every time this comes around we ask a few questions to help determine the best approach for handling sensitive data. We’re assuming that the data will be encrypted. But encryption has many options. How soon can we perform encryption? Is there a reasonable value that can be used for […]

Editorials

Protect Your Servers

Your server assets are essential to the performance of your business. Most businesses can’t afford to lose a server. It costs money, and the cost escalates as the time offline increases. This may not be true in all situations. I would estimate that the majority of us face real financial pain when our servers go offline. If the loss of […]

Editorials

High Volume Transaction SQL Tips – Indexes

Today I want to wrap up the discussion on high performance OLTP databases with the topic of indexing. The design of the schema is important. The syntax used is significant. But, if all of those things are aligned appropriately, and your indexes are off, you performance may still lag. Here is one way I have seen it happen. You put […]

Editorials

High Volume Transaction SQL Tips

One of the most effective techniques I have found to optimize transactions in high volume OLTP databases is to persist your data in sets. Once you have a set of data available in SQL Server, you need to process that set using efficient SQL Syntax. Regardless of how you pass a set of data to SQL Server, there are some […]

Editorials

TIPS for High Performing OLTP Databases – 2

Today we are continuing with tips for high volume transaction processing in an OLTP database. Yesterday we talked about preferring INSERT transactions over UPDATE or DELETE transactions. Today I want to talk about preferring SETS over multiple calls with single records. Sets are not always practical, or may not meet the business requirements. When sets are a valid options, then […]

Editorials

TIPS for High Performing OLTP Databases

There are some specific things you can do to optimize your OLTP database performance allowing it to scale with the ability to handle a large load of concurrent transactions. Today I’m going to start with some basic tips that work with just about any database engine. One of the most effective optimization techniques I know of is to prefer INSERT […]

Editorials

Policies and Procedures

If you’re not required by law to comply with external standards, does that mean you aren’t responsible for the risks of non-compliance. Sure, you may not have to prove compliance through some sort of audit, as you would if you were under PCI regulations, or some other standard. But, does that mean you don’t have to have the same diligence […]

Editorials

Data Types Matter for Key Columns

When considering data types and the desire to constrain the values to the minimum required, there is a tangent question you might consider. The question, “Is this column part of the primary key, or a foreign key?” Before we get into a heated battle regarding primary keys, and always having that key be a sequential integer, let me suggest that […]

Editorials

Detailed Table Design Questions

Today I want to talk about some very specific philosophical questions when it comes to defining tables. The choices we make have implications in both the short and long term. Let me start with a simple premise. I have been taught that when you create a table, for each column in the table, it should be constrained to allow only […]