SQLAuthority News – Microsoft SQL Server Compact 3.5 Server Tools Beta 2 Released

SQL Server Compact 3.5 Server Tools installs replication components on the IIS server enabling merge replication and remote data access (RDA) between SQL Server Compact 3.5 database on a Windows Desktop & Mobile devices and database servers running SQL Server 2005 and later versions of SQL Server 2005. Download SQL…
Read More

SQLAuthority News – Book Review – SQL Server 2005 Practical Troubleshooting: The Database Engine

SQLAuthority.com Book Review : SQL Server 2005 Practical Troubleshooting: The Database Engine (SQL Server Series) (Paperback) by Ken Henderson Link to book on Amazon Short Review : Database Administrators can use this book on a daily basis in SQL Server 2005 troubleshooting and problem solving. Answers to SQL issues can…
Read More

SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details

SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details This error is very common and many times, I have seen affect of this error as Suspected Database, Database Operation Ceased,…
Read More

SQL SERVER – 2008 – July CTP Released

SQL Server 2008 July Community Technology Preview has been released. With SQL Server 2008 July CTP release, customers can immediately utilize new capabilities that support their mission-critical platform and enable pervasive insight across the enterprise. SQL Server 2008 lays the groundwork for innovative policy-based management that enables administrators to reduce their time spent on maintenance tasks. SQL Server 2008 provides enhancements in the SQL Server BI platform by enabling customers to provide up-to-date information with Change Data Capture and MERGE features, and develop highly scalable analysis services cubes with new development environments.

Read More