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.

Several attendees at a conference of SQL Server users said Microsoft can do more to secure its SQL Server database, and company executives detailed plans aimed at meeting those demands as part of ...

To help other users who find themselves in the same boat, here are my step-by-step instructions on how to install an SQL Express Database for Horizon View. Before installing SQL Express, I checked the ...

Credit card information in your business's database is much more secure if you encrypt it. If you store this information as plain text, unscrupulous users can easily steal the data either through ...

Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...

If you have accidently deleted data from database tables in MS SQL Server, you can restore the deleted data (tables) using Log Sequence Number (LSN). But for this, you need the transaction backup file ...

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

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

Oracle is going after users of Microsoft’s SQL Server with a new tool for migrating data from SQL Server to its own MySQL database, the vendor announced Wednesday.

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...