Daily Archives: March 7, 2011

SQL Server Truncate Table Permissions

I saw a note recently where someone asked what permissions were needed for a user to execute TRUNCATE TABLE. In previous versions we needed ownership of the table or DBO level permissions. I had thought this was changed in SQL … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Common SQL Server Mistakes

This presentation is designed to cover some of the basic mistakes that I find people making quite often when working with SQL Server. It is a mix of development and administrative items, designed to help beginners get a grounding in … Continue reading

Posted in Presentations | Tagged , ,

The Wisdom Department

The more that I work in business, the more that I think that there truly is more to a company just maximizing the amount of money you can make. We often say that a business exists to maximize profit, but … Continue reading

Posted in Editorial | Tagged