Two days ago I wrote an article about SQL SERVER – TempDB Restrictions – Temp Database Restrictions. Since then I have received few emails asking details about Temp DB. I use following T-SQL Script to know details about my TempDB. This script is a pretty old script but it does work great most of the time. I strongly encourage all of you to use a script to check your TempDB Information.
SQL SERVER – Solution – Log File Very Large – Log Full
I have been receiving following question again and again either through email or through comments on this blog. My log file is too big, what should I do? Answer to this question is in three steps. Backup the log file to any device. Truncate the log file. Shrink the log…
Read MoreSQLAuthority 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