Not Your Dad's IT

Updated Solutions to Classic Challenges

A personal website dedicated to helping IT professionals review where we've been, where we are, and maybe where we are headed.

  • Blog
  • About
  • Disclaimer

Azure DB 101 - Connect to an Azure SQL DB Database

December 19, 2018 by Nathaniel Avery in POC

How to connect to an Azure SQL DB is a question that comes up for a lot of admins used to administering on-premises SQL Server. Connecting to the cloud managed version of SQL Server is very similar to the local datacenter version and uses the same tools. Both SQL Server Management Studio (SSMS) and SQL Server Data Studio can be used to connect to Azure SQL Database.

Read More
December 19, 2018 /Nathaniel Avery
azure, Azure DB, cloud, public cloud
POC
Comment

Project Repository - Azure DB Lessons

December 11, 2018 by Nathaniel Avery in POC

I’ve created a new GitHub repository to track various Azure DB projects I’m working on in my spare time. Azure DB’s fully managed nature makes it somewhat different than traditional Infrastructure as a Service (IaaS) installs. There are some features (like ETL) which are not available to end users which means customers may need to reconsider some architectural decisions. My plan is to work on the basics in addition to more advanced topics related to the architectural changes. Like any side project, I can’t quite commit to timelines, but as long as I keep coming up with questions I’d like to answer, I’ll keep adding. The first project is to build a SQL DB via code. The beauty of doing this in the public via GitHub is that anyone can fork the code, or contribute.

Read More
December 11, 2018 /Nathaniel Avery
azure, SQL, SQL Server, Azure DB, github
POC
Comment

Powered by Squarespace