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?

SQL Server 2022 takes that ability a few steps further. Last year, I wrote a column on the introduction of query store hints into Azure SQL Database. This functionality allows a DBA to add a query ...

JSON has stolen some of XML's thunder with features such as human and machine readability ... In this column, I focused on the JSON-to-rowset scenario. However, SQL Server 2016 also fully supports the ...

The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new ...

Beginning in Version 7, you can associate a libref directly with your DBMS data and use the libref in your Pass-Through query just as you would use any SAS data set. As a result, you can now create a ...

In part 1 of my SQL Server ... used when the query was compiled and is suboptimal for other values. This is typically caused by data skew. For example, if you had a column that had integer values ...