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

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

The view name, once defined, database users may reference this view as if it were a physical table. Whenever the controlling mechanism within the database sees a query against a view, it simply drags ...

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

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

Joey on SQL Server. Hands-On with Copilot for Azure SQL Database. I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do.

How to Attach an SQL Database to a Web Page. Your Web page can display up-to-date information dynamically -- all the time. And you never have to edit the page again.