Under SQL Server 7.0, for example, you can specify that logins — both successful and failed — be written to the Windows 2000 (or Windows NT) application log, which you view using the Event Viewer.

A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a virtual table to simplify queries and add a layer of security to your base ...

For example, DMVTOOL lets you see SQL Server dynamic management views from the command line, so you can get performance information about the database. There’s also PowerShell scripting support.

How do you see SQL Server evolving in the future? I think we can expect to see more and more cloud integration as hybrid solutions are becoming increasingly common. Also, I think we'll see more and ...

The biggest licensing change for SQL Server 2012 is Microsoft's shift from counting processors to counting cores (see table). The licensing describes four cores per physical processor as being the ...

Now that SQL Server also has Java within its SQL code, you have a new path to migrate Java applications to SQL Server. Pushing business logic into the database: Teams that are accustomed to developing ...

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.

Expect to see SQL Server 2022 hit GA this fall (at any rate, Microsoft has committed to releasing it by the end of 2022). Let's dive into the features. 1. AWS S3 Support ...