Wednesday, April 10, 2013
A baker’s dozen stored procedure improvements you can make right now
This is a beginner – intermediate level discussion of a number of simple things that can improve the performance of a struggling stored procedure. I’ll cover things from logistics involving test systems and the shock of learning how a procedure performs under a live load to locking, joins, temp tables and UDFs in a way that will leave folks with a useful toolbox (and hopefully give them a chuckle in the process). The old hands won’t find too much new, but the up-and-comers will want to take notes.
Paul Atkinson [ LinkedIn ] has been working with database technology since his days at Microsoft in the early 1990s, where he learned Microsoft Access first as a side project and later as a support rep. From there he went on to get a degree in Computer Science from Portland State University, rode the dot-com wave as a DBA, and came out of the dot com bust as a contractor primarily in the healthcare industry. Currently, Paul works for Huron Healthcare as a BI Architect and Team Lead developing both traditional and real-time BI solutions, and also recently saw the release of his first book: Beginning Microsoft SQL Server 2012 Programming (part of the Wrox Programmer to Programmer series).
Paul, his wife Kristin, and their daughter Maureen love living in Portland, Oregon. When he’s not working or writing Paul plays on multiple soccer teams, and otherwise keeps busy as a mountain biker, snowboarder, hasher, bicycle commuter, proud member of the Timbers Army, and semi-professional chocolatier. As Robert Heinlein wrote, specialization is for insects.
Also, Tim Morgan and James Bohem
OWASP: Application Security Resources (the SQL-centric abridged edition)
Application security is a moving target, but the Open Web Application Security Project (OWASP) is here in Portland to help you write more secure code. James and Tim will walk you through all of the free resources made available by OWASP to developers, application architects, and information security professionals. As an example of how OWASP can help you, we’ll touch on a few of the finer points of SQL injection (and database security in general), discuss the possible dire implications, and then show how OWASP methodology can help you easily avoid this common pitfall, and other common application and database security issues. Q&A will follow.
Tim Morgan [ LinkedIn] has been taking deep technical dives in security for over a decade as an application security specialist and vulnerability researcher. Tim resides in Oregon and works at VSR where he helps to secure his customers’ environments through penetration testing, training, and forensics investigations. His past security research has culminated in the release of several responsibly disclosed vulnerabilities in popular software products. Tim also develops and maintains several open source digital forensics tools as well as Bletchley, an application cryptanalysis toolkit.
James Bohem [ LinkedIn ] is the focal point for the security program at WebMD Health Services, which includes a large web-based application with millions of users, as well as other security technologies and the security and risk management program for this 400+ person division of WebMD based in Portland. His previous background includes 15 years in security consulting, focusing on application security, design, and technical compliance with a range of regulations and standards. In addition, he has experience developing large distributed applications, microkernels, the UNIX kernel, and international software standards for open systems.
Oregon SQL welcomes ServerLogic as a new Sponsor. ServerLogic provides innovative software products, IT staffing and placement services, corporate website development and hosting services, eGovernment consulting services, and IT infrastructure support for Global 2000 companies, startups, and government. ServerLogic helps our clients leverage the power of today’s latest technology across numerous industries, including transportation & logistics, higher education, biotech, retail, healthcare, manufacturing, and government.
ServerLogic has partnered with leaders such as Microsoft to deliver cost-effective technology-based business solutions to its customers. Located in the Pacific Northwest, ServerLogic products and services are used by customers worldwide.
Explore our solutions and contact any of our offices to learn how we can help you.