Keeping track of file versions has been a long time issue in the world of software. This remains true if you’re writing source code for an application, com
— Read on buildazure.com/2018/02/21/introduction-to-git-version-control-workflow/
SQL Server Management Studio (SSMS) 18.0 now Generally Available
SQL Server Management Studio v18.0 is now generally available and is the latest version that provides support for almost all feature areas on SQL Server 2008 through to 2019 preview.
If you have a preview of SSMS 18.0 installed, you will need to uninstall before you can install SSMS 18.0 GA. SSMS 18.0 will also not replace an older version of SSMS but will run side by side with it.
Release Highlights
Here is a brief list of is new in SSMS 18.0.
- Support for SQL Server 2019. SSMS 18.0 is the first release to be fully aware of SQL Server 2019 (compatLevel 150).
- SSMS 18.0 is based off the Visual Studio 2017 Isolated Shell.
- Smaller download size.
- Accessibility improvements.
- Ability to install to a custom folder.
- Requires .NET Framework 4.7.2 or greater.
- Support for High DPI (by default).
- Added integration for Azure Data Studio.
- Still no official support for Dark Mode. Please see my article on how to enable Dark Mode for SSMS.
- Database Diagrams has been removed. Seriously it’s gone! You will need to install a previous version of SSMS (like 17.8.1) to get this functionality.
Summary
Dark mode is still not available and remains a feature you have to manually enable. It’s also weird that they dropped support for the Database Diagramming tool without any warning or guidance to replace it. This was a gem of a tool inside of SSMS and was simple to use for visualizing database relationships, and documentation. You will need to rely on an older version of SSMS or use another tool. Other than that it looks like a great update to SSMS.
For more details on what’s new, bug fixes and deprecations, please take a look at the detailed release notes.
To get started download SSMS 18.0 (GA) now.
Enjoy!
References
#AzureApril–Day 1
Inspired by @burkeholland, @editingemily, @sigje and others where instead of putting effort into an Aprils Fools joke, I will instead take the #AzureApril challenge of posting an Azure tip each day in April. Some tips might come from @mbcrump comprehensive list of tips and tricks, while others might come from me and/or the community. Now on to todays tip.
Tip #1
Azure has over a 100 services that offer you everything you need to develop, build and run you applications with all the performance, redundancy, security, and scale that the cloud has to offer. With all these services sometimes it can be daunting on where to begin.
Todays tip is to take bite-sized lessons to reinforce your #Azure skills, all in a single month of lunches. This is a practical guide to learning Azure cloud computing skills quickly or refresh what you already know.
By reading this e-book, you get to build your cloud computing skills quickly and efficiently. You’ll be productive immediately, and when you finish, you’ll be well on your way to Azure mastery.
For more details and to download the e-book, go to https://azure.microsoft.com/en-us/resources/learn-azure-in-a-month-of-lunches/
Since we’re starting a new month today this is a great tip to tackle and complete by end of the month, all while eating your lunch.
Enjoy!
References
New Azure Datacenters Open in Africa
Today Microsoft announced the general availability of new Azure regions in Cape Town and Johannesburg, South Africa. This marks a major milestone as Microsoft is the first global cloud provider to deliver cloud services from datacenters on the African continent.
Microsoft Azure now has a total of 54 regions worldwide that span 140 countries. That’s more than all other cloud providers combined – offering the scale needed to bring applications closer to your users around the world, preserving data residency, and offering comprehensive compliance and resiliency options.
Enjoy!
References
Microsoft opens first datacenters in Africa with general availability of Microsoft Azure
Windows 10 Mail and Calendar app finally gets complete dark mode
Today Microsoft is rolling out an update to its Mail and Calendar app and has finally added a complete dark mode to which the reading pane is now dark (previously the reading pane or email body was white). Microsoft has also added a toggle button to switch between light and dark which sits between the Forward and Archive buttons.
The new update is available for everyone that is using Windows 10 1809 build. You can download the Mail and Calendar app from the Microsoft Store.
Enjoy!
Registration is now open for Microsoft Build
Registration is now open for Microsoft’s premier developer conference, Microsoft Build, which is taking place May 6-8 in Seattle, WA. At Microsoft Build, you’ll get access to the latest product updates, hear about Microsoft’s strategy and product roadmaps, and get hands-on, ask questions, and learn the best practices.
Some of the benefits for attending Build are:
• Learning from real-world experiences on building, modernizing, and migrating cloud applications
• Add value to your new and/or existing applications with AI
• Collaborative coding with your peers using the latest development tools
• Increasing productivity for your business with DevOps automation, tooling, and processes
• Creating and deploying cross platform applications
• Discovering innovations across Mixed Reality, IoT, and Machine Learning
• Learning new ways to easily customize, build, and extend applications with minimal code
If you’re interested in the content from last year, here is complete listing of the 2018 sessions.
New this year is the ability to bring your student-aged family member (14-21 years old) to the conference for free! For details about this wonderful opportunity, click here. Space is limited, so register today. While attending the event last year, one of the Microsoft Executives brought his two daughters and it was awesome to see them take interest and engage with the speakers and product groups. I’m glad they made this available this year for all eligible students.
I went to Microsoft Build last year for the first time and loved the experience to see and try the latest technologies, to connect with peers, and discover new innovative solutions to build. I’m not able to attend this year but I’m hoping to go again in the near future. If you can’t attend, then you always have the option to watch it on demand.
If you’re interested in going, then Register for Microsoft Build now!
Enjoy!
References
February release of Azure Data Studio is now available

The February release of Azure Data Studio is now available to download and includes the following key highlights:
- Introducing Admin pack for SQL Server
- Auto-sizing columns in results
- Notebook UI improvements
- Added Profiler filtering
- Added Save as XML
- Added Data-Tier Application Wizard improvements
- Updates to the SQL Server 2019 Preview extension
- Turned on results streaming by default
- Deploy scripts
- Bug fixes
For a list of the complete updates, refer to the release notes.
Download Azure Data Studio now!
References
Preview of ReflectInsight.Core
Today we published our first draft of ReflectInsight.Core, a port of our ReflectInsight logging library for .NET Framework to .NET Core and we are making it open source on GitHub. We still have some things to iron out like setting up a CI/CD, NuGet package creation, a sample app, docs and some refinements to the code base.
So far is working in our labs and we will share more information with you soon.
Enjoy!
Note: This post was re-blogged at https://blog.reflectsoftware.com
References
https://github.com/reflectsoftware/reflectinsight.core/tree/master
Ignite The Tour 2019 Toronto Recap
This year I had the opportunity to attend and participate as a speaker at the Microsoft Ignite The Tour in Toronto. The event was held over two days from January 10-11, 2019 at the Metro Toronto Convention Centre, and provided a venue for developers and tech professionals to continue learning alongside experts in developer tools and cloud technologies. It also provided an opportunity to connect with technical community and learn best practices and insights into cloud development, data, IT, AI, and business intelligence.
With events like this I usually attend as an attendee, but this year myself and two colleagues put through submissions for the call for speakers from the MVP community. For me this year has largely been about Azure DevOps and trying to connect with local developers, IT, and businesses and showing them up to take advantage of DevOps, specially with Azure DevOps. So it was only natural to focus my efforts around this. It also provided a great opportunity to connect with industry experts and other Microsoft MVP’s to further my education and career path.
Here are some morning pictures outside the contention centre. It was a nice clear day, but it was very cold.
Getting Prepared for my Talk
Day 1 of the conference was our talk on Azure DevOps. After getting my badge I met up with my co-presenters Ehsan and Arlan in the speaker room. This is a relatively quiet place to get away from the crowd and do some preparation or just relax. The food here was great too!
Presenting – Azure DevOps Community Meetup
Our talk was a community meetup on Azure DevOps with 146 people registered and we had great turnout of 130 or so. The presentation sparked many conversations with the attendees and other community MVPs. This later led to a conversation about coordinating a single Global Azure DevOps Bootcamp in the Great Toronto Area which was very exciting.
Working the Microsoft Area – Demo Stations, Lounges and Meeting Pods
After the presentation was done we had arranged a Meeting Pod for both days to continue the Q&A discussions that sparked from the talk. This allowed attendees to come and talk with us afterwards since our time in the room was limited. I also got to work the Demo Station where anyone could walk up to me any ask me anything. I focused my demos on Azure DevOps, Azure Functions, Event Grid and Logic Apps.
Networking, Socializing and Connecting with the Community
Of course you need to have fun and there was plenty of it throughout the two days. I had the opportunity to connect with other MVP’s in the local community and those that flew in for the event. I love this group and the passion we all share to learn and help others in the community.
In the evening there was a MVP social dinner. The name tags for the event were a neat idea, 1.44” floppy disks on a lanyard. I wonder what rock those disks were dug up from? I’m sure I have a box of these somewhere in my basement “tech” museum.
Wrap Up
Having the opportunity to participate at a conference like this was amazing. What was special about this event is that it was my first high profile conference to speak at. When I was younger public speaking was something I dreaded and tried to avoid at all cost. Speaking at conferences like this is nerve racking at first but does goes away as you get comfortable and relaxed. You get so much support from the tech community, whether its other speakers, colleagues or just the attendees wanting to engage with you and try to solve similar problems.
I had a blast at this event and I can’t wait for next year. I hope I once again get the opportunity to participate in this conference as a speaker, staffer or both.
Enjoy!
Resources
- Here are my 2018 Ignite the Tour Azure DevOps Demos on GitHub
- Microsoft Ignite The Tour – Toronto
- Azure DevOps Documentation
- Explore the DevOps Resource Center
- Azure DevOps Hands-On Labs
- Azure DevOps Demo Generator
Introducing Plato.Core
Today we’re pleased to announce the availability of Plato.Core, a port of our popular Plato.NET library for .NET to the .NET Core framework.
Plato.Core supports the following features:
- Async/Await
- Object Mapper
- Memory Cache
- Configuration
- Messaging
- Security
- Serializers
- Support for ActiveMQ
- Support for RabbitMQ
- Support for Redis cache
To get started, search for Plato.NetCore on NuGet.org from within Visual Studio and Visual Studio Code. Take a look and let us know what you think and please contribute!
Cheers,
The ReflectSoftware Team
NOTE: This post was reposted on https://blog.reflectsoftware.com .