Tag Archives: sql server

Ownership Chains in SQL Server

Posted on March 14, 2012 by way0utwest

Someone asked the question recently about allowing a user to run a process,but not execute the individual pieces of the process. I replied that ownership chains allow this, and then explained things. Here’s a short example of that. Let’s suppose … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Ownership Chains in SQL Server

T-SQL Tuesday #28 – Jack of all Trades, Master of None

Posted on March 13, 2012 by way0utwest

It’s that time of the month again, T-SQL Tuesday Tuesday. This month Argenis Fernandez, MCM, and big round SQL teddy-bear is hosting. His topic is Jack of All Trades, Master of None. The second Tuesday of every month is when … Continue reading →

Posted in Blog | Tagged , , | Comments Off on T-SQL Tuesday #28 – Jack of all Trades, Master of None

Old, but stable

Posted on March 9, 2012 by way0utwest

I had another poll planned for today, but then I saw Paul Randal’s blog on SQL Server 2000 and it inspired me. I spent many years working on SQL Server 2000 systems, and I liked the platform. It very very stable, reliable, … Continue reading →

Posted in Editorial | Tagged | Comments Off on Old, but stable

Scaling Out

Posted on March 8, 2012 by way0utwest

When I first heard about Service Broker coming in SQL Server 2005, I knew it would be slow to gain traction, and many people would not see the power of guaranteed messaging. However I thought over the next 3-4 years … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Scaling Out