Database vs. Application Virtually all of the paraphernalia of the modern SQL-Server style data model evolved in response to the many-single-users nature of the Microsoft client-server world.

2-tier architecture is a client-server architecture where the server is versatile, meaning it can directly respond to all of the client's resource requests. In 3-tier architecture, however, the server ...

There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

Server-Side Caching with Memory-Optimized Tables The second-best solution is, when you go to your database server, hold your data in memory on your database server rather than on your hard disk. This ...

Do you need to find out where the location of your SQL Server's database is? Use this quick tip from Arthur Fuller to show you how. Sometimes your application needs to know the specific directory ...