I'm new at this whole DBA thing, so maybe this is totally standard practice.<BR><BR>But we have a software vendor that wants remote access to our SQL server at an admin level to setup and install ...

The Connecticut Access Users Group, CTAUG.com, will be hosting world renowned Access Expert Juan Soto in a free training session titled “Creating Access dashboards using SQL Server”. Juan will present ...

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 ...

The first parameter ('BUCKSOFT\Marjorie') is the name of the SQL Server login you want to grant access to this database. You can supply a second parameter for the Database user name, but if you leave ...

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

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 ...