GRANT Schema Permissions on all Store Procedures.

Challenge: Developer emailed me today and asked me to have db_owner access to production database. Initial Reaction: When I first saw this email, I said to my self “HELLO NO” Solution: I took a deep breath and emailed him and asked “What exactly are you going to do in production” His response was “I would […]

Read More »

Don’t go Cheap on Memory!!

  If you have SQL Server enterprise edition (expensive version ), Do not go Cheap on RAM. ¬†If your databases are larger than 1TB, I would highly recommend starting with 256GB . The best way to to justify your Memory needs start with a baseline of the environment. ¬†Counters to begin monitoring would include: SQL […]

Read More »

What is a Linked Server and How to set it up?

Sometimes an application may need data stored in another database on a different instance of SQL Server. That different instance might be on the same physical machine or might be on another machine altogether. So what do you do in this situation? Your options depend on your data requirements, like how up to date does […]

Read More »