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.
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.
Over 50 hours of recorded sessions. Including topics on:
• Windows Server & Windows 8
• SQL Server
• Platform Development Tools
Known for its unbiased content, this year’s IT/Dev Connections provides deep training on the technologies that run your business.
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More