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

LEI is probably poorly written and using @@IDENTITY instead of SCOPE_IDENTITY(). If this is the case, you're basically SOL unless you can convince Lotus to fix it.

There is an unpatched flaw in Microsoft SQL Server that could enable an attacker to access users’ passwords on the database server. The vulnerability is in SQL Server 2000, 2005 and 2008. There is an ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

In the age of big data, efficiently managing relational databases, particularly SQL Server, may be the single most important issue facing a growing number of CIOs and data center managers. Throughout ...