Recommended reading from mrdenny for December 28, 2012
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. One example of query performance problem due to data type conversion How can you tell if an index is REALLY a duplicate? Portfolio changeover time for the PASS board My Short Struggle […]
Cross Database Chaining
Cross database chaining in SQL Server is actually a fairly old feature, first introduced in SQL Server 2000 SP3. However this feature isn’t often understood mostly because it isn’t often used. Database chaining is when permissions cascade from one object to another because they are used by the parent object. The perfect example is a […]
Cross Database Chaining
Cross database chaining in SQL Server is actually a fairly old feature, first introduced in SQL Server 2000 SP3. However this feature isn’t often understood mostly because it isn’t often used. Database chaining is when permissions cascade from one object to another because they are used by the parent object. The perfect example is a […]
Moving a Sharepoint Site Between Farms With Different Templates
A client came to be with a pretty scary problem. Their SharePoint site was totally down. The databases were there but the actual SharePoint farm was totally dead. All of the SharePoint tools said that the farm wasn’t configured yet so there were some pretty big problems. Thankfully they had a second SharePoint farm available […]