I am traveling to New York and New Jersey for a Database Architecture and Implementation discussion, so replies to comments and emails will wait two days.
SQLAuthority News – Microsoft SQL Server Compact 3.5 Server Tools Beta 2 Released
SQL Server Compact 3.5 Server Tools Beta 2 installs replication components on IIS for merge replication and RDA with SQL Server 2005. Download links are here.
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
SQL Server has two different ways to comment code. Let us learn all of them here in this blog post. Various the options in the blog posts.
Orphaned Users After a Restore, and How to Fix Them
Find orphaned users after a SQL Server restore, compare user and login SIDs, and repair the intended mapping with ALTER USER.
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
Error 945 means the database cannot be opened due to inaccessible files or low disk space. My four checks: disk space, autogrow, permissions and read only files.
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Search SQL
A SQL joke from a DBA meeting: when you search SQL terms like MSSQL Client on Microsoft, it suggests MySQL Client. I did not believe it until I tried it.
SQL SERVER – 2008 – July CTP Released
Microsoft released the SQL Server 2008 July CTP, with policy-based management, Change Data Capture, MERGE and new tools for analysis services cubes.