4 videos are tagged with sql

Rating: Everyone
Viewed 111 times
Recorded at: February 28, 2013
Date Posted: October 21, 2014

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.

Rating: Everyone
Viewed 4,440 times
Recorded at: April 25, 2014
Date Posted: May 21, 2014

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.

Rating: Everyone
Viewed 326 times
Recorded at: November 12, 2013
Date Posted: September 10, 2014

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.

Rating: Everyone
Viewed 497 times
Recorded at: May 6, 2016
Date Posted: May 13, 2016

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.