SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...

Web queries offer a handy way to import data from selected tables into a worksheet--but Excel isn't as accommodating as it should be, especially when it comes to parameters. These tricks will let you ...

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there were ...

Sharing database data throughout a company is crucial to the daily operations of most businesses. To facilitate this, the data doesn't reside on one person's desktop PC; instead, a database server ...