Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...

You can expand security by restricting SQL Server data that users can see and interact with via views or stored procedures. SQL Server security is more robust than the security model Access offers.

Since the SQL Server was on a server other than my View Connection server, I had to enable networking for the database. To do this, I went to the SQL Server Configuration Manager, expanded the SQL ...

SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals.

To run your SQL Pass-Through views for the MS SQL Server, you are encouraged, but not required, to create a data source name. You can use the ODBC administrator to create it. Refer to Data Source ...

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.