(Arshad Ali) It is not an uncommon requirement to move your database from one SQL Server instance to another instance, either for migration or for setting up a failover scenario. But the problem is, a database relies on some of the data that resides outside the database and hence you have more overh

(Burt King) After starting a new SQL Server DBA position I discovered that our servers, and there were hundreds, all had backups running, but they were all different. Some had backups to local storage, some across the network or to the SAN, and the list went on and on.

(Pinal Dave) A very common error new developers receive when they begin with SQL Server and start playing with the keys. Let us first run following code which will generate an error 8111.

(Mike Chapple) Microsoft SQL Server 2008 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need

(Pinal Dave) I blog and engage with the community because it gives me satisfaction when someone resolves an issue. A few days ago, I blogged about a DBA who began his first day at a new company and could not find out where the installation summary file was.

(Jeff Wharton) Stumbled across a couple of bugs the other day while upgrading a SSIS 2008 package to SSIS 2012 RC0. The bugs relate to using a FTP Task with a Server Port greater than 32767.

(Mohammed Moinudheen) I have transactional replication configured in my production environment with multiple subscribers. The business team has requested that one of the subscriptions be reinitialized, because they think there is some missing data. In this tip we look at the different options that

The SQL Server 2012 Virtual Launch Event kicks off on March 7, 2012 starting at 8:00AM Pacific (-8:00 GMT) with keynotes from Microsoft Executives including: Ted Kummert, Corporate Vice President, Business Platform Division and Quentin Clark, Corporate Vice President, Database Systems Group.

(Gregory Larsen) In order to keep your SQL Server up and running smoothly you need to constantly be performing routine maintenance and monitoring work. If you do not keep a watchful eye over your SQL Server instances performance and stability might suffer. Or worse yet you might not be able to rec

(SQLZealot) It is been long time due to certain critical issues and ofcourse the QUIZ in beyond relational,I could not get in touch with you all.