I am excited about the opportunity to present at Code Camp 27 in the surrounding Boston area. It will be a good time to meet old friends and make new ones.
I hope you have time to attend this awesome free event on March 25, 2017 at the Microsoft Office, Five Wayside Road, Burlington, MA.
Here are the details behind the first presentation that I gave that day.
Public Preview of SQL on Linux
There was a lot of excitement at the Connect() developer conference in November 2016. Two major announcements were made at the conference.
First, visual studio code now runs on Windows, Linux and Mac. Second, SQL Server v.Next is coming to Linux. This means a developer can
develop code against SQL Server in a Window less environment. If you are really passionate about Linux, join the hundreds downloading and testing this preview release.
1 – Core code deployed for multiple environments.
2 – Installs on Red Hat and Ubuntu flavors of linux.
3 – Generate ssh key.
4 – Deploy standard Red Hat image.
5 – Install core engine and tools on linux.
6 – Connect to engine via sqlcmd.
7 – Open firewall for external access.
8 – Create database on Linux via SSMS in windows.
9 – Load data into table via bcp.
10 – Supports docker (container) images.
11 – Current limitations.
12 – Future road map.
Here are the details behind the second presentation that I gave that day.
Azure SQL Database – Software As A Service
Are you tired of installing, configuring and patching Microsoft SQL Server?
Azure SQL database maybe a way to move some of your existing infrastructure to the cloud. Depending upon your companies philosophy, it might be great for development, testing, and possibly production environments. The exciting thing about this service is that new features will be released on this platform first before trickling down to the on premise editions.
Come to this session and learn what you need to start right away.
1 – Create Azure Account
2 – Create Database Server
3 – Adding IP Rules for client access
4 – Capturing the connection string
5 – Using SSMS, SSDT or SQLCMD
6 – Creating a database from TSQL
7 – Sample database with common objects
8 – Good, bad and ugly truths
9 – Exciting new features in Azure SQL DB
10 – Various Migration patterns