(Andy Novick) When working with cash flow calculations in SQL Server one of the key concepts is the Net Present Value of a stream of payments. In a database of payment information, how can the Net Present Value of a stream of payments be calculated in a way that is easy for users to request? Just

(Pinalkumar Dave) During the SQL Server Training, I frequently noticed confusion in people in terms of Statistics. Many people have no idea on how Statistics works. There are so many misconceptions with respect to Statistics. I recently had an interesting conversation with one attendee who believed

(Marcin Policht) SQL ServerServer 2008 Integration Services primarily serve as a development platform for automating Export, Transformation, and Loading (ETL) tasks. The benefits of using variables to promote code reusability can be extended by taking advantage of package configurations. In this art

(Richard Waymire) You have your highly available instance of SQL Server in place, and you’ve grown comfortable with the unique attributes of administering a clustered SQL Server configuration. (See my previous post.) Now, you’ve decided (or Dassault Systèmes has asked you) to apply a service pack to

(Suprotim Agarwal) Here’s a sample output of a SQL Server Column containing special characters, obtained from different sources.

(Derek Dieter) The default port that SQL Server listens on is 1433. This port however is not the same port in all cases as we will come to find. SQL Server has three different ways to communicate. These include: –TCP Ports –Named Pipes –Shared Memory –VIA (Virtual Interface Adapater) – Dep

(Siddharth Mehta) Business Intelligence (BI) is a much known term in comparison to the term Spatial Intelligence (SI). Spatial Intelligence is not limited to just space agencies, in fact it’s used day to day by many of us.

(Matteo Lorini) Is there a way to reproduce and diagnose query compilation and plan issues without actually having the data or the entire database?

(Mike Chapple) Encryption helps you prevent unauthorized access to information when individuals try to bypass your database security controls. For example, someone with a computer on your network might try to use a packet sniffer to monitor connections made by users to a database. Fortunately, datab

(theit8514) The class provided by this article will allow you to perform SQL Backup operations without blocking (aka, asynchronously) while receiving progress, message, error, and completion notifications. It will also allow you to be unaware of the environment of the SQL Server by defaulting to a r