Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

I have been testing SQL Server 2008 RC0 (Release Candidate Zero) that was made available recently and I must admit I am beginning to like it. Even the new logo is growing on me. There are many new ...

As we’ve come to expect from new SQL Server releases, SQL Server 2012 has so many new features that it’s impossible even to mention them all. Nearly everyone is well served, from the BI-hungry users ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

Mike Chapple is associate teaching professor of IT, analytics and operations at the University of Notre Dame. Almost every agency business function relies on at least one database. These range from ...