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 4
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.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Man deciding which door to choose
Aug 15, 2014
Sponsored

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More
SQL Server Management Studip Options screenshot
Aug 5, 2014
blog

SQL Server Management Studio’s Ugly ANSI_PADDING Bug

Learn more about the problem with SQL Server Management Studio's generation of scripts with ANSI_PADDING OFF along with a helpful solution....More
Save money red computer keyboard key
Jul 30, 2014
blog

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....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) ×