ScriptLogic aims to help DBAs using Microsoft SQL Server manage, back up and restore permissions more easily.

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

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.

This software repairs the database based on the SQL Server data file. It can restore tables, views, stored procedure, functions, and other SQL Server database objects.

Even if you could (I don't know specifically, server-wide permissions can be fine grained by right clicking on the server object and going to properties), there would be nothing preventing you ...

Figure 6. We have really just dipped our toe into the water that is using SMO with PowerShell to explore and report on various portions of SQL server and its database and tables. We can also do things ...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

Database connectivity gives desktop and Web applications much of their value. .NET developers have products and framework objects that can tie a front-end application to SQL Server, MySQL, Sybase, ...

Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...