Group items tagged

"To change the DB_Owner to some another "Database Principal"; simply Drill Down to your Database in Sql Server Management Studio and further more Drill Down to your_DB_Name > Schemas > db_owner > right click > select properties. You would find the name of the "Database Principal" that you want to delete. Change this to some another "Database Principal"; for Example, to "dbo"."

Sometimes it is required to get all Items in the database based on a given template. Iterating through the entire database may be a very expensive operation though. However in this particular case, we can resort to the Link database. Link database is used by Sitecore to resolve all the linking issues - what referrers and what references the Item has. And if an item is based on a template, it also counts as a reference from the item to the template. The solution then is very simple: get all the referrers for a given template item.

How to configure SQL 2005 Database Mail sp_send_dbmail

How to configure SQL 2005 Database Mail sp_send_dbmail

" When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Database Management Studio will not allow you to save the changes."

"Performing offline defragmentation of the Active Directory database"

"Issues with the System Attendant Mailbox When Moving an Exchange Mailbox Database"

"Restore or repair the database"

"The Exchange database store may not mount in Exchange Server, and event IDs 9175, 486, 455, 413, and 5 may be logged"

"How to move Exchange databases and logs in Exchange Server 2003"

"Moving an Exchange Mailbox Database to Another Server or Storage Group"

Apache CouchDB is a document-oriented database that can be queried and indexed in a MapReduce fashion using JavaScript. CouchDB also offers incremental replication with bi-directional conflict detection and resolution.

A special thing about the queries is that they can be handled either directly in the database on the data provider level or by the data manager tier. When the query is being resolved, the data manager tries to use its data providers first and resorts to a higher level (and slower) API in case of failure.

A preview release of a component that extends the standard Sitecore Searching mechanisms, specifically, the relatively "new" Sitecore.Search namespace introduced in 6.0 and provides easy search querying APIs