Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they were ...

Users and developers access SQL Server for completely different reasons. So, be sure you set up access as defined by who they are and why they need access. For many database administrators, managing ...

I know the title here is going to make some people think I've lost my mind before the thread even begins. Let me lay out the context.<BR><BR>I do some consulting work for my former employer because ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...