Matthew Harris

Matthew
Harris

has more than 8 years of experience with database development and administration. He is cofounder and head of technology at College Miner, a data mining and business intelligence company. He holds a master of science from Boston University.

Articles
Using Table-Valued Parameters to Update Multiple Rows 6
With SQL Server 2008’s table-valued parameters, you can pass a table as a parameter to a stored procedure to update multiple field values in thousands of files. And you can easily add this functionality to an application to let users update the transactions themselves, rather than sending a request to the DBA.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Feb 12, 2016
blog

Your Data’s Rate of Decay

Did you know that data has a half-life? That is the amount of time it takes for the information in your database to go bad. How? Because contact data is always changing....More
Feb 5, 2016
blog

The Solution to Large Quantities of Data

High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More
SQL Server 2016 Reporting Services
Jan 25, 2016
Article

Top Takeaways from Microsoft's Reporting Roadmap

The future for on-premises Microsoft business intelligence looks a whole lot brighter these days. Here are the top five takeaways from Microsoft's recent business intelligence announcements....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×