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

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

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

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.

SQL Database Edge can run in both connected and fully disconnected fashion, something that’s also important for many use cases where connectivity isn’t always a given, ... View Bio . July 15 ...