If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results. This method won't work in SQL Server, but Microsoft's Trans ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way?

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

You can use SQL to create, modify, search, and display database information. Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements.

SQL Server 2016 provides new support for working with JSON objects. In a previous column, I discussed how to generate JSON from SQL queries. This column looks at the reverse process: accepting JSON ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.