It's not terribly difficult to connect your Horizon deployment to a database. Following the instructions here, you shouldn't find it difficult to set up and use SQL Server Express with Horizon either.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

When PROC SQL executes the view, the stored query assigns the libref and establishes the DBMS connection using the information in the LIBNAME statement. The scope of the libref is local to the view, ...

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

Twice in the past couple of months I’ve gotten tripped up by the same data issue when using LINQ to Entities in the .NET framework. I create a simple view in my database which performs some ...

The ability to use SQL with Entity Framework Core has always been a cool feature. There's a new feature in Entity Framework Core that opens the door for whole new set of SQL-related functionality.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

Tim Kridel is an independent analyst and freelance writer with years of experience in covering technology, telecommunications and more. Just how much does the Department of Defense rely on Microsoft ...