I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...

What a week for our first Immersion Event on Internals and Performance

by Press Release

SQLServerCentral.com

Training

A short writeup on the first Immersion Event from SQLskills, a week long class designed to bring real world skills to DBAs and developers that want to become highly skilled SQL Server professionals.

Implicit and Explicit Conversions

by Steve Jones

SQLServerCentral.com

Editorial

Code that depends on implicit conversions can live for years in production without issue. However Steve Jones says that you shouldn't depend on these conversions

SQL Server 2008 and 2008 R2 Integration Services - Managing Local Processes Using Script Task

by Additional Articles

Database Journal

Integration Services (SSIS)

SQL Server 2008 R2 Integration Services includes a number of predefined tasks that implement common administrative actions to help with data extraction, transformation and loading (ETL). While in a majority of cases they are sufficient to deliver required functionality, there might be situations where an extra level of flexibility is desired.

SQLPeople: An Interview With Andy Leonard

by Joe Webb

SQLServerCentral.com

Blogs

The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get...

SSRS: Shared DataSet, Not So Shared!!!

by Patrick LeBlanc

SQLServerCentral.com

Blogs

I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...

The Business

by Andy Warren

SQLServerCentral.com

Editorial

How is your IT relationship with "the business"? Andy Warren asks today if there is a real client relationship between the implementers of technology and the consumers.

Lipoaspiration in your SQL Server Database

by Additional Articles

SimpleTalk

Administration

Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.