sql server

Omaha Global Azure Day 2020

All around the world user groups and communities want to learn about Azure and Cloud Computing! David Klee from Heraflux is presenting at this great event.

This year, all communities will come together once again in the seventh great Global Azure event! Each user group organizes their own one to three day Azure event the way they see fit and how it works for their members. The result is that thousands of people will get together to learn about Azure and join together online under the social media hashtag #GlobalAzure!

Omaha Azure User Group was formed to promote a community of people that are interested in understanding the benefits of Azure and to learn from others how they are leveraging the platform to solve business problems. Omaha Azure User Group has been a part of Azure Tech Communities as of November’2019. For more details, please visit – https://omahaaug.com/

Omaha Azure User Group will also participate in the Global Azure event this year and organize a full day Azure event for Omaha Azure family to learn about Azure together! The Global Azure Day 2020 – Omaha will take place on April 24, 2020 at Kiewit University. The event is open to IT professionals, architects, developers, administrators, and anyone who is interested in Azure. There is no registration fees for the event and its a free event hosted by community members for community.


Presenting at Omaha Azure User Group this Wednesday

This Wednesday, February 26th, I will be presenting a new session entitled "All Things SQL in the Microsoft Cloud" for the Omaha Azure Users Group, starting at 6pm Central time. It is held at the Blue Cross and Blue Shield of Nebraska office at 1919 Ak-Sar-Ben Drive (that's Nebraska spelled backwards for those of you not from the area).

Session Details: Microsoft’s SQL Server database platform has been the foundation of enterprise applications for decades. The adoption of the cloud has started to change the data landscape, and you should be prepared. Microsoft’s Azure cloud platform brings many compelling reasons to move your databases to the cloud, but what do you need to know to have a successful migration? Should you pick Azure SQL Database, Managed SQL Instances, or a SQL Server running in a VM in the cloud? How do I size the new service to maximize performance while minimizing cost? What should I expect in the cloud? What about a hybrid architecture? This interactive session will discuss the similarities and differences of operating a SQL Server in the cloud and will demonstrate many tips and tricks for properly selecting and managing the databases in the cloud.

I look forward to seeing you all there! Bring your questions, and make sure to RSVP at the Meetup group today!


Tell Us About Your Worst Database Code Offenders

For years, I've done consulting around helping organizations tune their database platforms, both from within the database and underneath, to help boost performance and availability. Some database design or code is capable of being tuned, since the organization owns it, but they might lack the time or ability to tune beyond a lab environment. Other times, third-party software vendors ship some pretty troubling code that eats an extraordinary amount of CPU time or storage demand on the database servers. Throwing hardware at the problem only pushes the pain further out into the future but doesn't solve the problem.

We've made some significant improvements lately with our ability to work with ISVs to help them tune their code so that their customers benefit. Their willingness to help shows me that some software vendors do listen and care about their customer complaints. Given the gains we've made for some large ISVs, I'd love to hear your thoughts on specific applications and vendors that ship sub-optimal code. We want to use the list to approach these vendors directly to see if we can convince them to let us help tune their code, and in turn, make their software perform better and get happier customers. If you have a moment, please fill out the SurveyMonkey survey here and let me know your top offenders that you'd like to see corrected! I really appreciate your feedback!


Omaha SQL Server Users Group Presentation Dec 4

David Klee is proud to present an in-person technical session to the Omaha SQL Server Users Group entitled "Level Up Your Cloud Infrastructure Skills" on Wednesday, December 4, at 6:00pm.

Session Details: Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? How many does your database consume during a given day? Properly sizing a cloud database depends on your knowledge of this metric. Failure to properly configure storage performance at the time of deployment will slow down your SQL Server considerably. Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!

RSVP for this free in-person event today! We look forward to seeing you there!


Omaha SQL Server Users Group Presentation - Dec 4

I'm proud to announce that I'll be presenting an updated session entitled "Level Up Your Cloud Infrastructure Skills" for the Omaha SQL Server Users Group tomorrow on December 4th at 6pm.

Abstract: Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? How many does your database consume during a given day? Properly sizing a cloud database depends on your knowledge of this metric. Failure to properly configure storage performance at the time of deployment will slow down your SQL Server considerably. Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!

RSVP for this free event here, and I look forward to seeing you all there!


PASS HA/DR Open Q&A Extravaganza Dec 10

As leader of the PASS High Availability and Disaster Recovery virtual chapter, I invite you to bring your questions for a mega open Q&A session on Tuesday, December 10th, at 1pm Eastern time. We have assembled one of the largest lineups of SQL Server HA/DR experts in our history, and any question goes! Not in any order, the speakers are:

This open-ended Q&A session will help you answer any questions that you have wondered about or currently fight with on SQL Server and Microsoft data platform high availability and/or disaster recovery. Bring your questions and we have the answers! RSVP today for this free webinar!


Omaha Azure User Group Presentation 2019.10.20

David Klee is proud to present to Omaha's Microsoft Azure Users Group in a new session called "Everything you Need to Know about SQL Server in Azure".

Session Details: Are you interested in moving your SQL Server workloads to the Azure public cloud? Where do you start? Do you pick Azure SQL Database, SQL Managed Instance, or do you need the full versatility (and overhead) of SQL Server in an Azure IaaS VM? How do you get your data there? How do you maintain performance and availability? How can you monitor it? All of these questions and more will be addressed in this interactive session. Bring your questions and let’s explore Azure SQL Server offerings together!

RSVP for this meeting at the user group Meetup site. We look forward to seeing you there!


P21 WWUG Connect Conference 2019

Heraflux is proud to sponsor and present at this year's P21 WWUG Connect conference in New Orleans, LA, on September 9th and 10th. For more information, p21p21.


Lincoln SQL Server Users Group 2019

David Klee is proud to present at the Lincoln Nebraska SQL Server Users Group on September 5th! Stay tuned for more details!


SQL Server Tuning Results in Cloud Licensing Reduction

We have a Client that recently expressed interest to make their SQL Servers more efficient so that they can establish a standardized scale-out model for their hosted software platform. The objective was to allow a certain number of 'normal' sized customers to coexist on the same SQL Server instance in a VM in the cloud. The  challenging situation for this Client is that the licensing cost of a cloud-based SQL Server deployment was beginning to become cost prohibitive. The SQL Server usage patterns were pretty standard for an in-house developed software package, where the developers are great at what they do, but are not trained in SQL Server internals.

We did a tremendous amount of sampling with Windows Perfmon to get a baseline of resource consumption across what the Client would consider a business cycle. Check out the CPU consumption patterns by CPU core.

That's a moderately active machine, and the concern was that if it became much more active, especially during the morning, they were not going to achieve the customer density per instance that they were looking  for.

We went in and reviewed the infrastructure stack top to bottom, from the VM disk type and disk presentation all the way up to the SQL Server table and index structures, and the way that the application was querying for the data. Many of the items were fantastic and well managed, but a number of items (mostly platform default settings) were getting in the way of scalability. We accessed the system  and tuned the following items without modifying anything that would require significant regression testing of the application.

  • Multiple disk controllers and virtual disks, and better distributed the SQL Server objects to more appropriately load balance the OS-layer I/O queues
  • Enabled Windows Receive Side Scaling for the network adapter to reduce the CPU concentration for network traffic handling
  • Introduced SQL Server Read Committed Snapshot Isolation so that we can achieve better concurrency for read workloads within their databases
  • Tuned the SQL Server parallelism settings (Cost Threshold of Parallelism and Max Degree of Parallelism) to better align the application demand with the CPU architecture
  • Significant amounts of missing and unused index tuning within the customer databases, and created a standard tuning model to be used across all customers

After tuning for just one week and two maintenance windows, look at the next business cycle CPU activity pattern.

The difference is stark. The CPU consumption across all instances is much lower than before, and so low that based on the projections, they can handle double the customer load per instance on a cloud-based SQL Server instance size half of what they anticipated. Plus, performance dramatically improved for each click of the user in their web application.

The results are clear. The customer is able to improve their customer experience while chopping their deployed SQL Server virtual machine costs by over 75%. Immediately!

I’ll repeat that! The customer just needs to schedule a maintenance window for us to reconfigure the virtual machine. We can apply the indexes and other changes with only a brief interruption in service. Monitor the resource consumption until we see how the machine settles in. One more short interruption in service to change the resource assignments to the VM is all we need to start saving on the cloud deployment costs.

We can do this for your SQL Server databases and help you save on your associated cloud costs . Contact us to learn more!