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 […]
The Least Expensive SQL Server 2012 High Availability Solution
As we all know by now AlwaysOn Availability Groups are an enterprise edition feature and SQL Server Clustering is a standard edition feature. Butt what happens when you have a small business that is running its apps on SQL Server Express. Can’t SQL Express have any sort of high availability? Officially the answer is no, […]