How to get the Best Performance from Azure SQL Database Managed Instance

Published On: 2018-11-19By:

IO performance for your Managed Instance may not be what you were expecting. Typically when we create databases, especially when working in the cloud, we create the databases pretty small. However, this can be a problem with Azure SQL Database Managed Instance.  The performance that’s assigned to your databases which are hosed in Managed Instance will depend on the size of the database when you first create the database.  This means that you’ll want to create the database at the largest size possible (1TB currently) to get the best possible performance from your managed instance environment.

Denny

 

The post How to get the Best Performance from Azure SQL Database Managed Instance appeared first on SQL Server with Mr. Denny.

Thoughts on Microsoft Ignite and the PASS Summit being on the same week

Published On: 2018-11-12By:

Having the PASS Summit 2019 and Microsoft Ignite both on the same week will be a very interesting problem, to say the least.

From an attendee perspective, there isn’t a lot of crossover between the two conferences. Some people are able to attend both events, but for the most part, there is going to be minimal crossover between the two events.

From a speaker perspective, there is some overlap between the PASS Summit and Microsoft Ignite, because only a few speakers are selected to present at the Microsoft Ignite conference.

From a sponsor and exhibitor perspective, things are going to get a little more interesting.  There is a decent amount of crossover between the vendors when they have a booth at the conferences.  Vendors will probably end up having to pick an event to sponsor and have their teams attend.

This choice is where things will get interesting. While the PASS Summit is about DBAs and Developers, the Microsoft Ignite conference is about everyone in IT, including senior management. This most significant part of IT that Microsoft Ignite focuses on is the fact that IT management has the budget to buy tools. While DBAs and Developers are the ones that have to use tools, management has to decide if they should buy the tool, hire the consultant, etc.

The fact that senior management attends Microsoft Ignite and typically doesn’t attend the PASS Summit is going to be a challenge for the PASS Summit, when it comes to attracting vendors and sponsors.  One of the things that differentiate members of management from DBAs and developers, is that management can spend money on tools, consulting, etc.  This means that vendors that are deciding between going to the PASS Summit to talk to DBAs and Developers and going to Microsoft Ignite to speak to IT senior management are going to have a decision to make.

Given that DBAs and Developers typically lack authority to spend money (or they can’t spend much money) where members of management have much more money to spend. From a pure business perspective, going to the PASS Summit may end up being a hard decision for companies and people that typically go to both events. Additionally, Ignite is a much bigger conference (9-10x the size of PASS Summit), making it a richer surface area for vendors.

Denny

The post Thoughts on Microsoft Ignite and the PASS Summit being on the same week appeared first on SQL Server with Mr. Denny.

Is Azure SQL Database Managed Instance the Right Solution?

Published On: 2018-11-05By:

Maybe.  Is the software that you’re trying to move to Microsoft’s Azure require the use of a SQL Server instance so that you can create jobs, logins, and do

https://www.flickr.com/photos/theaucitron/5810163712/

things like cross-server queries?  Are you trying to avoid adding more Virtual Machines (VMs) to be managed in your environment (and a SQL Server Failover Cluster or Availability Group)?  If the answer to these questions is “yes” then Managed Instance might not be the right solution for you.

Now granted, you may need to wait until the Performance Tier of Managed Instance is available as the General Purpose tier may not have the power to run the application that you need to set up.  If CPU and memory is the only problem that you’re running across than merely waiting is all that you have to do.

Managed Instance is like everything else in Azure, it may or may not be the correct solution to solve the problem at hand, but it might be.

Denny

The post Is Azure SQL Database Managed Instance the Right Solution? appeared first on SQL Server with Mr. Denny.

Denny Cherry & Associates Consulting & ATTOM Data Solutions Announce Successful Completion of Microsoft Azure Migration

Published On: 2018-11-02By:

OCEANSIDE, Calif., Nov. 1, 2018 /PRNewswire/ — ATTOM Data Solutions, curator of the nation’s premier property database, and Managed Microsoft Partner Denny Cherry & Associates Consulting (DCAC) jointly announced the successful completion of a 50 Terabyte migration to Microsoft’s Azure platform.

The engagement included:

  • Consolidation of multiple legacy SQL Server databases
  • Migration to Azure
  • Conversion to SSIS catalogued project model
  • Sizing and choosing the correct VM for the Azure environment.

Post migration, ATTOM Chief Technology Officer Todd Teta estimates the company is now saving 30% of their budget on infrastructure.

ATTOM’s Chief Data Officer Richard Sawicky commented, “We now have the flexibility to scale, expand, and consolidate all of our operations and be nimble as we take on new projects, new datasets, and better serve our customers on a modern platform capable of enrolling a lot of the Azure functionality.

DCAC principal and Microsoft MVP Joey D’Antoni commented, “The ATTOM migration was quite challenging as there were lot of moving pieces. Richard and I worked really hard to ensure we had a solid checklist for migration, and outside of a single small error we saw immediately after migration, the process was seamless.”

“There were a ton of moving parts, and Joey D’Antoni and Denny Cherry were there to quarterback us through it all,” Sawicky added.  “There is no way that we would be sitting here 100% in Azure without those guys.”

For more info visit the website. Media inquiries about this release contact Kathleen Hannon  khannon@dcac.co.

About Denny Cherry & Associates Consulting

Award-winning Microsoft Managed Partner Denny Cherry and Associates Consulting assists companies with reliably attaining IT goals such as HA, scalability, SQL Server virtualization, Azure migration and acceleration, while finding ways to save on costs. With clients ranging from Fortune 50 corporations to small businesses, their commitment to each is the same: to provide a deft, high-speed IT environment that leverages every aspect of their platform: from architecture, to infrastructure, to network.

About ATTOM Data Solutions 
ATTOM Data Solutions provides premium property data to power products that improve transparency, innovation, efficiency and disruption in a data-driven economy. ATTOM multi-sources property tax, deed, mortgage, foreclosure, environmental risk, natural hazard, and neighborhood data for more than 155 million U.S. residential and commercial properties covering 99 percent of the nation’s population. A rigorous data management process involving more than 20 steps validates, standardizes and enhances the data collected by ATTOM, assigning each property record with a persistent, unique ID — the ATTOM ID. The 9TB ATTOM Data Warehouse fuels innovation in many industries including mortgage, real estate, insurance, marketing, government and more through flexible data delivery solutions that include bulk file licenses, APIs, market trends, marketing lists, match & append and more.

1 2 3 336

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.