Creating a quality application unit test environment can save IT time, money — and prevent significant errors! When I was managing software development, one of the messiest and least efficient areas ...

If I have an application that uses a database as its data store (and ultimate source of truth) that brings some obvious issues when developing tests: In the applications, objects should ONLY be ...

How to use the InMemory provider in Entity Framework Core to test your methods without hitting the database or using fakes and mocks The InMemory database provider is an exciting feature in newer ...

I've used lots of methods to transform data between databases and object code. From hand-coded SQL to JDO to EJB. I've never found a method I liked particularly well. This distaste has become ...

Database connectivity gives desktop and Web applications much of their value. .NET developers have products and framework objects that can tie a front-end application to SQL Server, MySQL, Sybase, ...

There are many different ways to look at database administration. It can be done by task, by discipline, by DBMS, by server, and so on. But one useful way to look at database administration is in ...

When I started writing SQL, I was never worried about security; I was worried that I would write a bad query that would crash the database. And it was really easy to write SQL that would consume 100 ...