Windows Authentication Mode is the default and recommended authentication mode. It tactfully leverages Active Directory user accounts or groups when granting access to SQL Server. In this mode, ...

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

I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2. This feature, known as Extended Protection for Authentication (Extended ...

The coupling is much looser in Linux; Pacemaker doesn’t see changes made in SQL Server. Windows Integration: One can configure availability groups with SQL Server using Windows’ authentication (such ...

The only way to get extended support for 2008 versions of Windows and SQL Server is in the cloud. Here’s why you should be thinking about 2012 migrations now as well. The release of Windows Server ...