David Campbell is a Microsoft Technical Fellow whose present role is Vice President of Product Development for the SQL Server product suite.
David graduated with a Master's Degree in Mechanical Engineering (Robotics) from Clarkson University in 1984 and began working on robotic workcells for Sanders Associates -- later a division of Lockheed Corporation. In 1990 he joined Digital Equipment Corporation where he worked on their Codasyl database product DEC DBMS as well as their relational database product; Rdb.
Upon joining Microsoft in 1994, David was a developer and architect on the SQL Server Storage Engine team that was principally responsible for rewriting the core engine of SQL Server for SQL Server Version 7.0.
At Microsoft, he has held numerous positions and driven a number of major initiatives such as overseeing the initial product development of several of Microsoft's Azure (public cloud) services; defining and implementing SQL Server's global development processes; and, more recently, defining and overseeing the initiation of Microsoft's commercial Big Data product strategy.
David holds several patents in the data management, schema and software quality realms. He is a frequent speaker at industry and research conferences on a wide variety of data management and software development topics.
David lives in Sammamish WA with his wife Marcia and two teenage sons. He enjoys traveling with the family, photography, and occasionally making dust in the woodshop.
I will show how to use Go's database/sql package, with MySQL as an example. Although the documentation is good, it's dense. I'll discuss idiomatic database/sql code, and cover some topics that can save you time and frustration, and perhaps even prevent serious mistakes.
Come learn about architecting high-performance applications and production workloads using Amazon RDS for SQL Server. Understand how to migrate your data to an Amazon RDS instance, apply security best practices, and optimize your database instance and applications for high availability.
If you've struggled through writing complex queries in raw SQL, ActiveRecord methods are a helpful breath of fresh air. If you're not careful though, those methods could potentially leave your site open to a nasty SQL Injection attack.
We'll take a look at the most common ActiveRecord methods (and some of the lesser known ones!) with one question in mind....will it inject? If it's vulnerable to a SQL injection attack, we'll cover how to structure your query to keep your data secure.