You’re simply granting permissions to SQL Server data and objects to valid Windows users. Role types Server roles are maintained by the database administrator (DBA) and apply to the entire ...

This utility is meant to be used by a developer or database administrator with access to SQL Server Management Studio, not an application user. The script assumes that the user has at least the ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this permission much easier ...

It can restore tables, views, stored procedure, functions, and other SQL Server database objects. To use the software, you need to first detach the database or take it offline. You can also stop the ...

A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.

LCK_M*—This wait type happens when a query locks an object while another query is waiting to lock ... are used to synchronize access to BUF structures and associated pages in the SQL Server database.

"An object explorer allows developers to easily make connections to their SQL servers and databases and explore the hierarchy of the SQL Server instance," Yu explained. "Users can also easily launch ...