While conducting Interview for my outsourcing project, I asked one question to interviewer that what are the restrictions on TempDB? The candidate was not able to answer the question. I thought it would be good for all my readers to know the answer to this question so if you face this question in an interview or if you meet me in the interview you will be able to answer this question.
SQLAuthority News – Top 10 Tips for Successful Software Outsourcing
Few days ago, I wrote article about SQLAuthority Author Visit – IT Outsourcing to India – Top 10 Reasons Companies Outsource. I received quite a few emails regarding this article. I was really impressed that how much vendors care about their reputation and their client. I received so many requests…
Read MoreSQL SERVER – Do Not Store Images in Database – Store Location of Images (URL)
Just a day ago I received phone call from my friend in Bangalore. He asked me What do I think of storing images in database and what kind of datatype he should use? I have very strong opinion about this issue. I suggest to store the location of the images…
Read MoreSQL SERVER – White Papers: Migration from Oracle Sybase, or Microsoft Access to Microsoft SQL Server
Guide to Migrating from Oracle to SQL Server 2005 This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2005. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration…
Read MoreSQL SERVER – Microsoft Synchronization Services for ADO.NET v2.0 CTP1 Refresh
Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local…
Read MoreSQLAuthority News – Microsoft SQL Server 2008 Community Technology Preview (November 2007) VHD
SQL Server 2008, the next release of Microsoft SQL Server, will provide a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling…
Read More
SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability)
ACID (an acronym for Atomicity Consistency Isolation Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved.