Thursday, October 29, 2015

Latest SSMS stream lines the process for adding Azure Firewall Rules at connection

If you haven't heard, Microsoft have broken the release of SQL Management Studio away from the main product. While at this stage it is continuing to be released at the same cadence as the SQL 2016 CTP 2 cycle (e.g. Monthly) the updates are targeting features for existing releases, Azure SQL, and of cause SQL 2016. You can get the latest release @

I have been working on a project of late with an Azure SQL DB back-end and one thing that has always frustrated me given my role keeps me out in the field is that I am constantly having to log into the portal and update the firewall rules....... Well the latest release of SSMS makes this process much easier.

Now when you try and connect to an Azure SQL Server and a firewall rule on the server blocks your connection, you are no longer prompted with the message informing you that the client is not allowed to connect. Now you are prompted with a dialog asking you to log into Azure and create a firewall rule. It even populates the client IP Address for you and suggests an IP range.

One you authenticate, select the appropriate option for the Firewall Rule (e.g. static or IP range). Click OK and SSMS will place a call to the Azure web services to add the firewall rule.

Once the rule is added, the authentication process continues which is a nice touch because I was half expecting to be prompted to log in again.

 Obviously for this to work the user then needs the required permissions on the subscription

This is a great example of how the team is actively working on improving the toolsets and responding to feedback so make sure you keep the connect items rolling in.

In other news, I am presenting with a colleague at MS Ignite Australia next month on some of the new toolset features in SQL 2016. If your attending make sure you attend and come say hi as I will be around the Data Den and Exhibition hall throughout the event.

Legal Stuff: As always the contents of this blog is provided “as-is”. The information, opinions and views expressed are those of the author and do not necessarily state or reflect those of any other company with affiliation to the products discussed. This includes any URLs or Tools. The author does not accept any responsibility from the use of the information or tools mentioned within this blog, and recommends adequate evaluation against your own requirements to measure suitability.


  1. Ein paar hundert von Ihnen werden eine gute Uhr an sich kaufen, ohne auf eine Fälschung zurückgreifen zu müssen.Bestimmte Seiko Uhren oder kleine Marken wie Smiths oder Precista von Timefactors sind viel gefolgt und zu Recht. Replica Rolex-Uhren Sie haben große lang anhaltende mechanische Bewegungen und werden für viele Jahre dienen.
    Replik Rolex-Uhren
    Replik rolex-Uhren

    1. Zwracałem uwagę na repliki zegarków. tanie i modne polska zegarki Po otrzymaniu towaru byłem bardzo zaskoczony, skórzany pasek jest wygodny, zegarek jest lekki, wysokiej jakości, a cena jest dobra. replika zegarki franck-muller Jeśli szukasz zegarka, który pasuje do Twojego codziennego noszenia, ten zegarek repliki jest zdecydowanie idealnym strojem. Kupię ponownie!

  2. Since 1848,best replica watches Omega watches built a reputation of being the ultimate in luxurious elegance and sporty sophistication. In 1931, the replica omega watches brand entered the Geneva Observatory trials, competing in several categories designed to test the rigor and mechanical reliability of the Omega timepiece. The brand won all six categories and thereby adopted the slogan, "Omega, exact time for life." In 1965, NASA selected Omega to be the official watch used in training and space exploration. A true giant in name and reliability, Omega produces elegant watches that are impervious to changes in fashion. At , we offer a variety of Omega watches for sale — at the lowest prices online. When you are ready to buy an Omega watch, browse our selection that includes the: Seamaster, Speedmaster, 1957 Trilogy, DeVille, Planet Ocean, and Constellation.

  3. The Royal Oak Offshore draws from Audemars Piguet’s signature Royal Oak model and pushes it to the limits.fake watches The replica royal oak offshore watchesbrand takes their iconic Royal Oak to the next level by employing a fearless and boundless spirit of innovation. Only available in limited editions, the Royal Oak Offshore collection is big, bold, and brash. Its commanding presence is certainly anything but understated. Still, it packs the same refined finishes and superior functionality of the Audemars Piguet brand.

  4. Alexander McQueen is an iconic replica ALEXANDER MCQUEEN Shoes fashion house creatively cheap ALEXANDER MCQUEEN sneaker womens taken over by Sarah Burton who continues to work and evolve with the brand, offering a luxurious range of prêt-à-porter clothing and accessories.

  5. Dette eksemplar gucci tøj kvalitet er perfekt, meget behagelige at have på, til at rejse til at bære denne kjole.billige gucci Jeg anbefalede denne hjemmeside til mine gode venner.billige gucci damer baelter De er meget glade for at købe sådanne billige gucci tøj.

  6. replica breitling watches is one of the world's most respected Swiss horologists. Founded in 1884 in Saint-Imier, the brand cemented its reputation as an aviation specialist, but miniforwatchis now an authority in diving and chronograph categories, too. Specialist watchmaking All COSC certified chronometers.

  7. cheap Soccer Jerseys is the best soccer jerseys wholesale tammy abraham Jerseys Buy the cheap soccer jerseys, soccer shirts, soccer kits, training kits with wholesale price.

  8. Alexander McQueen est une maison de couture emblématique, alexander mcqueen chaussures francereprise par Sarah Burton, pas cher femme alexander mcqueenqui continue à travailler avec la marque pour développer une gamme de prêt-à-porter et de prêt-à-porter haut de gamme.

  9. Rolex watches are crafted from the finest raw materials and assembled with scrupulous attention to detail. cheap replica watchesEvery component is designed, replica rolex watchesdeveloped and produced in-house to the most exacting standards.