Tag Archives: sql server

Rights for one table

Posted on September 16, 2010 by way0utwest

I ran across a thread that was asking how to grant rights to a person for one table only, and not other tables. My response is simple: CREATE ROLE MySingleTableRoleGOGRANT SELECT ON dbo.MyCustomers TO MySingleTableRoleGOEXEC sp_addrolemember ‘MySingleTableRole’, ‘Steve’ That’s it. … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Rights for one table

Social Engineering Dangers

Posted on September 15, 2010 by way0utwest

I heard about a social engineering contest at this year’s DefCon hacker conference. The write-up said that every company targeted would have failed in a security audit, and these were some large companies, like Google, BP, Proctor and Gamble, Microsoft … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Social Engineering Dangers

T-SQL Tuesday #10 – Indexes

Posted on September 14, 2010 by way0utwest

It’s time for T-SQL Tuesday again, the brainchild of Adam Machanic (Blog|Twitter), and this month’s topic is Indexes. A thanks to Michael Swart for hosting this month’s event, and sending me a personal invite through email. That was pretty cool, … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on T-SQL Tuesday #10 – Indexes

Common SQL Server Mistakes – Shrinking Databases

Posted on September 14, 2010 by way0utwest

I don’t like there being an easy command to shrink databases, and I especially don’t like seeing the shrink option as a part of the default maintenance plans.However it seems that this technique for managing sizes is used quite often, … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Common SQL Server Mistakes – Shrinking Databases