Reset Ektron Search Property on Content

The issue you have with Ektron is that when you update the Is Searchable checkbox on a folder, it is for all future content. Existing content is left as is. The SQL will update the Is Searchable to the parent…

Find size of all SQL tables

To find all the sizes of the SQL tables on disk, run the following command in SQL. If you have a large run away database it will help you track down the culprits. SELECT t.NAME AS TableName, s.Name…

Reseting the admin password to b

To reset the admin password to "b" via SQL, just run the following SQL on the core database. UPDATE dbo.aspnet_Membership SET [Password]='qOvF8m8F2IcWMvfOBjJYHmfLABc=', [PasswordSalt]='OM5gu45RQuJ76itRvkSPFw==', [IsApproved] = '1', [IsLockedOut] = '0' WHERE UserId IN (SELECT UserId…

Getting Sitecore out of SQL

In a recent project I needed to call Sitecore via SQL. Here are a few snippets that will get most people started. It should be noted that getting Sitecore data via SQL is not always faster than using the API.…