Blog Year 2012 In Review
Welcome my friends to the first official work day of the year 2013. You enjoying that hangover yet? It is time again to take a little peak at the last year (as far as my blog goes) and see just what was the most popular posts, and what just sucked so that hopefully for this […]
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 […]