Running Project Server 2003 with SQL 2005
Aaron Tiensivu
writes "
It is unsupported currently, but it doesn't look too difficult to do.
"
RAID 0+1 and RAID 1+0
DynamicAccounting.net
writes "This is from an article by Kim Tripp from Saturday, May 13th. I'm reprinting part of it here for all of our SQL DBA's.
RAID 0+1 and RAID 1+0 "
Mulling Microsoft Mysteries
Barbara Darrow
writes "What's in the cards for Commerce Server and SQL Server? Read on."
CompanyWeb, Monitoring, etc Stop Working After Uninstalling SQL 2000 SP4
markstan
writes "We've seen a few cases where uninstalling a SQL 2000 SP4 instance may cause loss of connectivity to other SQL instances. This may happen when you uninstall an application that uses SQL/MSDE, when you manually uninstall a SQL instance, etc.
"
SQL Server 2005 SP1 Available Now!
DynamicAccounting.net
writes "SQL Server 2005 Service Pack 1 was release today. If you've delayed moving to SQL Server 2005 while waiting for the first service pack, time is up! You can get SP1 here.
"
SQL 2005 SP1 - Enable encryption between server and client
Aaron Tiensivu
writes "Looks like the one of the new features mentioned in the SP1 release notes is located here:
"A registry switch has been added that you can use to control encryption between a master server and a target server (MSX-TSX)."
"
SQL Server 2005 SP1 has been released
Claus Busk Andersen
writes "This release includes SQL Server Express with Advanced Services that includes Reporting Services. The service pack can be downloaded here http://www.microsoft.com/sql/sp1.mspx This Service Pack also include tools for SQL Server Express that allows creation of reports and management of the SQL database...(read more)
"
Convergence follow up - Business Scorecard Manager and Dynamics NAV
Claus Busk Andersen
writes "I've had the question for additional information on both Reporting Services, Business Scorecard Manager and SQL Server in general from several people approaching me after the sessions at Convergence so I figured I'd post them here."
What's Next for SQL Server?
Mary Jo Foley
writes " Microsoft has big plans for SQL Server. But it's not ready to share many of them yet. Company execs did offer some very broad directional statements on Thursday about Microsoft's plans for storing customers' exponentially growing amounts of relational and non-relational data....."
Microsoft Outlines (Vaguely) Its Database Road Ahead
Mary Jo Foley
writes "Think every two to three years for a new SQL Server release. Expect a newly rebranded mobile version of SQL Server that will run on the Windows client. And watch for new tools tie-ins, according to the Redmond software giant. "
Quickly Disconnecting SQL Users from a Database
Mitch Milam
writes "On SQLServerCentral.com tonight, I found a really neat little SQL procedure written by Brian Knight that allows you to disconnect any users currently connected to a specific database.
Quickly Disconnect Users
I needed this script so I could disconnect all of the CRM users so I could perform some maintenance on the CRM databases.
"
Net Change Methods - The use of Triggers
Pierre Hulsebus
writes "There are 3 basic ways you can tell the information is changed in Solomon.
1) Time Based Queries - Build queries into the data that compare the last update time stamp on data with the last time the query was run.
2) Export and Compare - Use SQL DTS to scheduled exports of the relevant Solomon info into shadow tables and then compare the changes.
3) Triggers - Put triggers on the relevant tables in Solomon to publish changes as they occur.
"
Installs and SQL Server
John Straumann
writes "Today I did my first non-SBS install of MSCRM in a customer’s lab environment. They had SQL Server installed in a named instance which is unsupported by MSCRM, so since I am not a SQL guru (or even a SQL guru in trainingJ) so I involved a SQL expert.
On his advice, we installed a new instance of SQL Server on the same machine as the named instance, apparently you can have up to 16 instances on one SQL install, applied SP4, and away we went. This is a cool feature of SQL I was not aware of, so it was worth getting up today, I learned something new!
I also learned that SQL 2005 can have up to 50 instances!
"
PopUp Blockers
Anne Stanton
writes "Microsoft CRM 3.0 accesses a central MS SQL database on your server or if offline a local instance of the data. Now you can imagine with all this accessing that popup blockers might get in the way. So if you are having difficulty accessing check those popup blockers. It is amazing how many layers of "defense" can be installed by a user when frustrated by JUNK. Sometimes eliminating and reorganizing the defenses is an important side step. "
|