Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

A few days ago, Microsoft shocked us when it announced that it would soon bring its SQL Server database to Linux. It’ll take until 2017 before SQL Server will be available on Linux, though. Until then ...

How to protect your database from SQL injection, data theft, rogue users, and well-meaning meddlers without tying your environment in knots Like so much of IT, database security requirements largely ...

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

Microsoft will end security support for SQL Server 2005 in April 2016, and higher education IT leaders must prepare to upgrade. Phil Goldstein is a former web editor of the CDW family of tech ...

I'm rebuilding our SQL 2000 box and trying to figure out the best way to configure the permissions settings. The first question is whether to use a local or domain account for the SQL service account.

SQL Server In the good old days of SQL Server, all we had to do was make our service account a member of the local administrators group and we were all set. Of course, those days have gone and that ...

The Microsoft SQL Server team has made incremental updates to SQL Server Data Tools (SSDT), updating the Schema Compare utility, improving Microsoft Azure SQL Database security and supporting Parallel ...

A recent salary survey indicated that database-related programmers had excellent job security, and now there's more good news about job prospects in the exploding mobile arena and SQL Server usage in ...