• ·       explain the difference between symmetric and asymmetric encryption.
• ·       select the right cryptographic technology for your special security requirement.
• ·       identify when to use one-way hashing instead of encryption.

In today's rapidly-moving world, it's not enough to know how to build great on-premises databases. The rapid pace of development sometimes demands fast solutions that make data available via services, across platforms, and for all kinds of devices.

In this session, consultant G. Andrew Duthie will show you how Azure Mobile Services provides the ability to quickly build services to store and access data in the cloud, and easily provide client apps for the web, iOS, Android, and Windows/Windows Phone.

Best of SSWUG Webcasts:

In this webinar, we'll explore the options, pros and cons of each and how-to information about setting up databases with Microsoft's Azure systems. This will include a look at both Database Services and Virtual-Machine-oriented solutions, along with different considerations and things to understand about each.

Here's a look at the different topics to be addresses:

- Setting up your Windows Azure SQL Database
- Setting up a VM
- Setting up a SQL Server on a VM
- Understanding some of the differences between VM and WASD implementations
- Making the choice, questions to ask
- Best Practices
- Disaster Recovery considerations in the environments

Do you want to be a DBA? Have you been appointed DBA-by-default? Are you responsible for up time? Operational aspects of your server? Performance? 
This presentation, which encompasses over 100 years of combined DBA experience, covers everything you need to consider in order to be a great DBA, including: 
·         the right way to manage preventive maintenance (including what is important to do, and what is important not to do);
·         planning for disaster recovery;
·         interacting with developers and management;
·         personal characteristics of the great DBA;
·         how to be perceived as a great DBA, as well as being one in fact

While the industry studies uniformly blame 70-80% of performance issues on bad code, there’s a presumption that database physical design supports the queries. Proper indexing has a dramatic positive effect on query and server performance (sometimes taking multi-day queries down to seconds). 
There is a great deal of misinformation and uniquely inappropriate information being presented in white papers and documentation on the web. 
This presentation discusses:

• ·         Physical index structures;

• ·         How physical structures affects optimizer decisions;

• ·         How the optimizer may or may not use indexes;

• ·         Index design and selection for performance

The term IoT, short for the Internet of Things, has become quite the buzzword recently. But what are the implications of the IoT in terms of data? Many internet-connected devices feature sensors, and in order for those sensors to be useful, the data from them needs to be transported, stored, and made available for review and analysis. 

In this session, consultant G. Andrew Duthie will show some of the techniques and technologies that you can use to collect, transport, and store data from IoT devices and sensors, including ASP.NET Web API and SQL Server, as well as Azure services specifically designed to support IoT. He'll also discuss architectural considerations, such as local caching, to optimize performance when dealing with small bits of data from many devices.