Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

My plan was to get the text file and do a Bulk insert into a holder table in Sql server 2000 via the bulk insert command inside a stored procedure.

SQL Server 2012 will offer a variety of new features centered on big data, business intelligence and cloud computing.

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code.

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.

Three important tools are now integrated into SQL Server 2000’s Query Analyzer. SQL Trace lets you trace code directly from a query window, without running the Profiler.