SQL Database Administration

SQL Server Multi-Tenancy in the Real World

2023-10-232023-11-18

With the advent of cloud technologies, “microservice” design patterns, and SaaS products, how could a “monolith” sort of “legacy” system ever hope to achieve the same level of scalability without breaking the bank and/or starting from scratch?

Implementing actual multi-tenant database systems is not an easy task, especially when done on top of an existing on-prem system.

Join Eitan Blumin in this data-driven session to hear about his experience as a database solutions architect in a real-world project that takes a single-tenant, on-prem system, and turns it into a cloud-based, multi-tenant, self-managing SaaS marvel! ☁

You may not hear what you expect! 😉

This session is intended for database developers, solution architects, product managers, and C-level executives.

Contained Availability Groups in SQL Server 2022

2022-06-112023-03-13
1 Comment

While being an awesome feature introduced in SQL Server 2012, Availability Groups were always missing the ability to synchronize server-level objects between replicas. This finally changed 10 years later, in SQL Server 2022, with the introduction of “Contained Availability Groups”.

A contained availability group is an Always On availability group that supports:

managing metadata objects (users, logins, permissions, SQL Agent jobs etc.) at the availability group level in addition to the instance level.
specialized contained system databases within the availability group.

In this session, you will:

learn about the similarities, differences, and functionalities of contained availability groups.
see a live demo of the creation and usage of a contained availability group.
learn how to work with the feature of contained availability groups and its pros and cons.

How to Save Money on Your SQL Server Hardware

2021-07-222023-06-03

Having a production machine with SQL Server in your organization is no cheap feat. Significant costs could accumulate due to expensive hardware and licensing.

How could we know whether our SQL Server machine is wasting our money? What are the most common pitfalls? How to detect them and what can we do to remedy them?

Learn all this and more in this session.

This session contains tips relevant to SQL Servers on-premises as well as in the cloud.

Performance Monitoring with Azure SQL Analytics

2020-11-192022-08-14

Do you have Azure SQL Databases or Azure SQL Managed Instances? Are you looking for database performance monitoring solutions without going broke or implementing your own?

Azure SQL Analytics might be the solution for you. But is Azure SQL Analytics really good enough for the job? Can it be a decent competitor to powerhouses such as SentryOne, Red-Gate, Apex, Solarwinds, and others?

Join Eitan to see how to get started, learn about the pros and cons and how it stacks up against 3rd party monitoring platforms, and see a live demo.

How to HADR Your SQL Jobs

2020-06-292022-12-17

You have a couple or more SQL Servers with some sort of High Availability solution between them (AlwaysOn Availability Groups, Database Mirroring, etc.). You also have a bunch of scheduled jobs that you need to run on the Primary server.

But wait…. How would you make these jobs run only on the Primary server? After all, if they try to run on the Secondary, they might fail (whether because the database is inaccessible or because it’s read-only). Additionally, you would need to consider a failover where the Primary and Secondary servers would switch roles.

This means that you would have to create these jobs on both servers, and then implement some sort of mechanism that would detect, for each job, whether the instance it’s being executed at is currently the Primary.

There are a few ways to go about doing this. During this session, we will cover possible solutions, downfalls, tricks, and much more.

Advanced Dynamic Search Queries

2020-04-282022-12-17

What is the solution for implementing truly dynamic search queries? Not just a stored procedure with optional parameters, but something even more dynamic than that? Let the end-user choose the exact fields and, more importantly, the operator types to use on them, in order to get the results that they need. And how do you achieve this level of dynamic interactivity without risking SQL injection? This presentation will answer these questions and give you a solution involving some advanced T-SQL martial arts!