This article is a follow-up to one I wrote in August 2017, "How To Set Up a SQL Express Database for Horizon View," in which I detailed how to configure a SQL Server Express database for use with View ...

I configured View Composer to use my SQL Server Express database by taking the following steps. While installing View Composer, I clicked on ODBC DNS setup. This brought up a dialog to set up the ODBC ...

Indexed views. In SQL Server 2000 and 2005, you have the ability to add indexes to views. But, if a view is just a stored query definition in the database with no data of its own until it is run ...

[Click on image for larger view.] Figure 1. In the above demo, I included all the tables in my Azure SQL Database (AdventureWorksLT) ...

Nominally, views are named SQL queries. These named-queries can be used within other queries as if they were physical tables. Therefore, inside a given SQL query, users may incorporate tables or views ...

To do it via PowerShell, you'll need your Azure SQL database server name. To get this, you can use the Get-AzureSqlDatabaseServer cmdlet. You can see here that I have a single server called ...

When I am working with an Oracle database, I still find myself using SQL*Plus for many quick and dirty database queries. In particular, I often look up constraints in SQL*Plus. In this post, I ...

Most Common Wait Types in SQL Server and What They Mean. ASYNC_NETWORK_IO—The async_network_io wait types point to network-related issues. They are most-often caused by a client application not ...