A common database problem is the management of large amounts of data occurring and deprecated over time. For example, we often have data we maintain for a period of days, weeks, months, years, etc. When the data becomes obsolete we want to remove it quickly. When we start a new time segment for data, we want to generate that quickly, […]

I received a response to my editorial last week about the skills of individuals applying for software developer positions. Because the email came through a non-traditional source I don’t have the name of the author for attribution. Our email reads: I agree that Unit Testing and maybe even testing in general has suffered as we migrate into a new generation […]

Recently I have been working with and interviewing a lot of young developers. One thing they all have had in common is that they do not know how to Unit Test. This experience prompts me to ask a few questions. I’d like to see what you think as well, so your comments will be appreciated. Am I out of touch […]

There are extensions to the GROUP BY clause available in TSQL allowing you to do some really cool stuff. This capability is often forgotten, because we tend to think of doing these kinds of functions in a Data Warehouse, instead of in traditional SQL statements. Those extensions are CUBE, ROLLUP, and GROUPING SETS. There is a good explanation of these […]

I received a tweet today pointing me to a really cool EBook written by David Klee and James Green. Together they wrote “The Gorilla Guide to Modern Storage Strategies for SQL Server. The EBook is only 78 pages long. In that limited space they do an amazing job defining and demonstrating the different technologies and processes that bring together a […]

How many times have you had to make software, or architecture decisions, based on the currently acceptable configuration of your servers and networks? What about being limited to the personal experience of key decision makers or influencers? For some clarification, let me share some situations I have experienced in the last few years? You can’t use NoSQL (specifically Mongo) because […]

Recently I was talking with a colleague about long running processes in IIS. This is considered a bad practice for a number of reasons. IIS is made to serve many different requests concurrently, often of short duration. If you have long running processes, you can dramatically impact yours, and potentially other applications performance. For example, IIS will be configured sometimes […]

Recently I picked up a project where I am integrating data into an SQLite database that will be used for an embedded controller. I was provided the database by another software engineer. It already has the table design, and the software is configured to use the schema as is. All I have to do is populate the tables from my […]

Recently I experienced something most of us run into at one time or another. It’s related to the DRY (don’t repeat yourself) principle. I was looking into using a custom tool designed in house, and applying it to a new internal application. The first thing we talked about was how to connect the two applications together. We had already done […]

In SQL Server you can’t nest transactions. The transactional syntax allows for you to create more than one transaction, and it appears that more than one transaction is running. In fact, the transaction count returned by the system property @@TRANCOUNT will increase with each transaction. However, the first transaction completion command closes all open transactions. Here is an example. SELECT […]