iltering is an important aspect of writing most complex queries. While there may be instances where you don’t need a filter, such as a simple query that retrieves a list
ith the proliferation of mobile devices such as BlackBerrys, Tablet PCs, and regular laptops, some critical applications need to store a cache of their data locally at all times. Whether
QL has been evolving?slowly?for over three decades, (see Wikipedia for a historical summary). While SQL in the hands of an expert is quite powerful, it’s sometimes cumbersome compared to other
few months ago, I received a message from quite an experienced DBA and database programmer asking me whether I knew a nice trick for manipulating date/time data without using Microsoft
f the several ways to enforce business rules in the database, only constraints can guarantee that your business rules are always enforced for all your data. This article teaches you
s a developer, how often have you been asked to refactor a SQL statement to increase performance, accommodate changes to database design, support a new database, or for a whole
icrosoft offers two queuing frameworks to its ‘brand’ of developers: MSMQ and SQL Service Broker. These two frameworks offer many of the same features, but differ in some important areas
Working with dates is one of the most common—and most error-prone—parts of writing SQL. Every database engine ships its own set of SQL date functions for getting the current time,
QL Server may be the domain of Microsoft, but that doesn’t mean the database engine doesn’t know how to play nice with Java. In fact, SQL Server is used in