(Pinal Dave) Has it ever happened to you that you say something but forget to follow up due to any reason? It usually does not happen to me as I try to remember everything in my task list but there is always an exception.

(Paul M Simpson) While I realize the title of this tip isn’t grammatically correct (à la Paul McCartney’s famous song, Live and Let Die, with its line, “If this ever changing world in which we live in”), it was simply the most succinct way to state the purpose of this function.

Project or team management isn’t about controlling the project or group. It’s about managing the inevitable changes that naturally occur with ease and confidence. This series introduces a different way to approach the natural flow of project events. These articles changes one’s mindset to more “c

(Dinesh Asanka) Orphan users can occur once you detach databases or restore a database from another SQL Server database instance. The reason for this is that whenever a user is created, a login name and SID will be created. Each database user is mapped with an SID.

(Tony Petrossian) A few years ago when we started building Windows Azure SQL Database, our Cloud RDBMS service, we assumed that fault-tolerance was a basic requirement of any cloud database offering.

(Arshad Ali) The amount of data is increasing on a regular basis and so is the responsibility to ensure the quality of data remains intact. The data quality issues include inconsistency, incompleteness, invalidity, inaccuracy, duplicity etc.

(Matt Bowler) Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics.

(Marcin Policht) SQL Server 2012 Integration Services introduced a new approach to manage the deployment of packages developed using SQL Server Data Tools, referred to as Project Deployment Model, while still maintaining support for traditional methodology (labeled as Package Deployment Model).

(Pinal Dave) SQL Server has lots of things to learn and share. It is amazing to see how people evaluate and understand different techniques and styles differently when implementing. There are three different instances where I have come across a situation where I felt that proper understanding is imp

(Michael J. Swart) In this article, I recommend that you use composite primary keys for child tables in composite relationships. If a child record is part of its parent record, then the parent’s primary key should be part of its child’s primary key.