SQL Server Data Tools

Hosted by Canada's Technology Triangle .NET User Group

Public group


SQL Server Data Tools (SSDT) is a very under used set of tools. People are still keeping alter scripts in folders and sheepishly apply them hoping they won't mess up the Database. Everyone needs to learn and use SSDT, it makes your life much easier and gives you the change audit trail your Database deserves.

I'll show you how to get your Database into a VS solution. How to make changes and check them in against a work item. Build to validate changes, Perform Static Code Analysis. We'll set up an Automated Build in TFS then create a Deployment. I'll show you how to use the publish profile to set all those options. How to set the version number on the Database and turn it into a Data-Tier Application. This will be a practical Demo centric presentation.

6:00 pm - Doors open. Water, pop, and light snacks served.

6:30 pm - Session start

Free parking is available at the library. Find us in the Meeting Room at the rear of the library.

About The Speaker:

Dave Lloyd is a Microsoft MVP, course author and one of the founding partners of ObjectSharp Consulting. He is a regular speaker at user groups in and around the Toronto area. He’s been writing software for over 30 years and teaching developers in the classroom for almost 30 years.

Sponsor Shoutouts:

Special thanks to Northsail Software (https://northsail.io/) for being a full season sponsor of our .NET stream!

About Northsail Software: Our mighty boutique develops software solutions for a wide range of clients located in Kitchener-Waterloo, Cambridge, Guelph, and Toronto, as well as across Canada, the USA and the globe.

Special thanks to Microsoft Canada (https://twitter.com/microsoftcanada) for being a full season sponsor of our .NET stream!

About Microsoft Canada: Established in 1985, Microsoft Canada Inc. is the Canadian subsidiary of Microsoft Corp. (Nasdaq "MSFT"), the worldwide leader in software, services and solutions that help people and businesses realize their full potential. Headquartered in Mississauga, Microsoft Canada has nine regional offices across the country dedicated to empowering people through great software. Microsoft Canada is equally passionate about committing to Canadian communities. Since its inception, Microsoft Canada has had a corporate giving philosophy that goes beyond financial donations to champion inventive forms of philanthropy.

Special thanks to RL Solutions (http://www.rlsolutions.com/home) for being a full season sponsor of our .NET stream!

About RL Solutions:RL Solutions creates healthcare software for patient feedback, incident reporting & risk management, infection surveillance, peer review, root cause analysis and claims management.