Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Public Endpoint
Posted by Barac in Azure, SQL Server, SQL Tips and Tricks on Sep 5th, 2019 | 0 comments
In the previous post we had example how to connect to Azure SQL Managed Instance from Azure VM within same VNet using private endpoint Now I will show you how to connect to the SQL Managed Instance from your remote location using public endpoint. First go to your SQL MI and select Virtual Network Enable Public Endpoint (data) option Public endpoint provides the ability to connect to Managed Instance from the Internet without using VPN and is for data communication (TDS) only. After enabling your SQL MI will have 2 connection...
Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Private Endpoint
Posted by Barac in Azure, SQL Server, SQL Tips and Tricks on Aug 30th, 2019 | 0 comments
There are different ways to connect to SQL Managed Instance using SSMS. One of the easiest ways to do that is using Private Endpoint. Azure SQL Managed Instance provides a private endpoint to allow connectivity from inside its virtual network. In this example we are going to use azure VM within the same Virtual Network as SQL Managed Instance. You should create VM inside the same VNet but different subnet. When you create SQL Managed Instance you will have following resources in you Resource Group: SQL managed instance Virtual Network Network...
SQLSATURDAY 866 Auckland, New Zealand / Use PowerShell to deploy and configure Azure SQL Database (PaaS) with good resilience to outages and with integrated Azure SQL Analytics monitoring solution
Posted by Barac in SQL Server, SQLSATURDAY on Aug 16th, 2019 | 0 comments
Last weekend, I had the privilege of speaking at SQLSaturday Auckland 2019. It was a great pleasure being a part of this awesome event and met so many amazing people. Many thanks to all attendees and thanks to Leila Etaati, Reza Rad, Indira Bandari and everyone else for organising yet another great event! Title: Use PowerShell to deploy and configure Azure SQL Database (PaaS) with good resilience to outages and with integrated Azure SQL Analytics monitoring solution. Duration: 30 Minutes Speaker: Zoran Barac Abstract: Use one single...
SQLSATURDAY 866 Auckland, New Zealand
Posted by Barac in SQL Server on Aug 1st, 2019 | 0 comments
SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Aug 10 2019 at Unitec Institute of Technology, 139 Carrington Rd, Mount Albert, Auckland, Auckland, 1025, New Zealand Here you can find more information regarding this event: https://www.sqlsaturday.com/866/EventHome.aspx Here you can find more information regarding full Conference Schedule:...
Auckland SQL User Group Meetup Event / Edwin M. Sarmiento, Microsoft MVP / Designing a SQL Server AlwaysOn AG Topology Without Losing Your Sanity
Posted by Barac in SQL Server on Jul 28th, 2019 | 0 comments
15C Managing Director, Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Edwin M. Sarmiento is coming to Auckland on August 8th to deliver a session in front of our Auckland SQL User Group! Designing a SQL Server AlwaysOn AG Topology Without Losing Your Sanity Thursday, Aug 8, 2019, 12:00 PM Microsoft New Zealand LtdLevel 5, 22 Viaduct Harbour Ave Auckland, NZ 11 database professionals Attending 15C Managing Director, Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Edwin M. Sarmiento is coming to...
PASS / Modern Migration Tour 2019 – Auckland, New Zealand
Posted by Barac in SQL Server on May 24th, 2019 | 0 comments
Modern Migration Tour 2019 – AUCKLAND, NEW ZEALANDhttps://www.eventbrite.ca/e/modern-migration-tour-2019-auckland-new-zealand-tickets-62011870173# LocationMicrosoft New ZealandL5 Microsoft House22 Viaduct Harbour AveAuckland 1010 Date And TimeMon, 27 May 201912:00 PM – 1:30 PM NZST Description: End of support for SQL Server 2008 is almost here (ends in July!), which means it’s time to take flight on your migration strategy. But, do you have a plan in place? What approach should you take to ensure a smooth transition? To guide you...
Auckland SQL User Group Meetup Event / Kevin Kline, Microsoft MVP / Push Your App to Enterprise Scale with Advanced SQL Server Features
Posted by Barac in SQL Server on May 10th, 2019 | 0 comments
SentryOne Principal Program Manager, renowned database expert, founder and former president of PASS, and Microsoft SQL Server MVP, Kevin Kline, will share his deep SQL knowledge and best practices at a series of SQL Saturdays and SQL Server User Group meetings all around the world. As a part New Zealand Down Under Tour, in association with SQLMasters Consulting, Kevin Kline is coming to Auckland on June 4th to deliver a session! Push Your App to Enterprise Scale with Advanced SQL Server Features Tuesday, Jun 4, 2019, 12:00 PM Microsoft22...
SQL Server / SSMS / Expanding Indexes List Query
Posted by Barac in SQL Server, SQL Tips and Tricks on Mar 11th, 2019 | 0 comments
Same as in previous posts examples Expanding Tables List Query and Expanding Columns List Query I usually do not notice this type of queries working in the background. But recently I end up working with a customer having DB with over 500K indexes, 150K tables and expanding indexes list operation can end up being slower than usual. Here is the code: SELECT i.name AS [Name], 'Server[@Name=' + quotename(CAST( serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/Table[@Name=' +...
SQL Server / SSMS / Expanding Columns List Query
Posted by Barac in SQL Server, SQL Tips and Tricks on Mar 5th, 2019 | 0 comments
Same as in previous post example Expanding Tables List Query I usually do not notice this type of queries working in the background. But recently I end up working with a customer having DB with 150K tables, some of the tables have more than 500 columns, and expanding columns list operation can end up being slower than usual. Here is the code: SELECT clmns.name AS [Name], 'Server[@Name=' + quotename(CAST( serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/Table[@Name=' +...
SQL Server / SSMS / Expanding Tables List Query
Posted by Barac in SQL Server, SQL Tips and Tricks on Mar 3rd, 2019 | 0 comments
Usually I do not even notice this query working in the background, since this operation is quite fast. But recently I end up working with a customer having DB with 150K tables, and expanding table list operation can be really slow and expensive. Here is the code: SELECT tbl.name AS [Name], SCHEMA_NAME(tbl.schema_id) AS [Schema], 'Server[@Name=' + quotename(CAST( serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/Table[@Name=' + quotename(tbl.name,'''') + ' and @Schema=' +...
About Me
My name is Zoran, currently living in Auckland, New Zealand. I am a database specialist with more than 10 years of hands-on experience in database administration and optimisation. Also, I am a Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert with a Master‘s degree in Information Technology.
read moreAuckland SQL Group
MSDN PROFILE
