by James Crowley – There are no standard functions in either MySQL or MS SQL Server to return a running total for an SQL query. It is, however, relatively easy using the CROSS JOIN statement. In order to do this, use the following SQL:

Learn How to Set Up Security and Encryption for Servers Accessed by SQL Server CE Clients

By Paul DuBois – MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there’s a worked-out solution or "recipe"–short, focused pieces of code that you can insert directly into your app

In some situations, access control policies may stipulate that the Windows NT Administrator(s) should not be given system administrator (SA) access to SQL Server. A default installation of SQL Server permits members of the local Administrators group to be allowed trusted connections as SA. This arti

The sa account is always mapped to dbo, even when sa is not the real database owner. The dbo account is the login that the sysdatabases system table in the master database displays, as the sp_helpdb system stored procedure shows. Yes, you can change the dbo to the sa from the Windows NT login.

By James Niccolai – Microsoft Corp. has released new tools for its SQL Server database that should make it easier for its partners to create data analysis applications for their customers in the financial services and manufacturing industries, the software maker said Monday.

By Vyas Kondreddi – This article provides you with a simple stored procedure, that can search all the columns of all the tables in the current database, and replace a given search string with another string.

By Itzik Ben-Gan – For accuracy and performance, you need to make sure that all IP addresses in your tables are valid. Here’s how to write a CHECK constraint that validates character strings containing IP addresses.

Don’t think that performance tuning your SQL Server applications is regulated to the end of the development process. If you want your SQL Server-based applications to scale and run at their full potential, you must begin considering scalability and performance issues during the early stages of your

By Douglas Seward – We recently had a problem with SQL Server 7 bombing out when trying to process a view of our DB2 table where some of the date fields were initialized with the value ‘0001-01-01’. In SQL Server the earliest date recognized is 1753-01-01, so it could not process date fields with th