To help you get a leg up on SQL Server 2014, I plan to spend the next several column entries telling you about those broad categories and the most salient features within them. Today, let’s start with ...

Prior to SQL Server 2016, currently in CTP, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with ...

In this case, MS SQL will read the entire page with all the columns and "give back" only the necessary data. This leads to excess data reading, and therefore, reduces productivity.

Query outcomes are now improved after the Database Tuning Advisor references the "indexed Spatial Data Type column." SQL Server 2008 SP3 can be downloaded here for 32-bit or 64-bit hardware.

SQL Server 2022: Here’s what you need to know Your email has been sent TIOBE Index: Top 10 Most Popular Programming Languages WWDC: Apple Unveils Unified Design Language and Built-In AI Tools ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

In an earlier column, I showed how to use the new SQL Server JSON support to return JSON objects directly from SQL statements, potentially slimming down the code in your Controller classes. But that ...

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.