SQL Server Multi-Tenancy in the Real World en

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.

In this session, you will learn about the common database multi-tenancy models, how to adapt such a model to a very common on-prem "monolith" system design, and learn a few interesting "tricks" to help manage and maintain such a beast.

more info: https://eitanblumin.com/portfolio/sql-server-multi-tenancy-in-the-real-world/

Performance Monitoring with Azure SQL Analytics en

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 SolarWinds, Red-Gate, Apex, Quest, 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.

Dynamic Search Queries in T-SQL - The Ninja way en

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!

More info here:
https://eitanblumin.com/portfolio/advanced-dynamic-search-queries/

Development Lifecycle Basics for DBAs en

What is source control? What is version history? What are unit tests? What do CI and CD even mean, and what the heck is an Artifact?? In this new era of Agile development, DevOps, DataOps and other weird buzzwords, we the DBAs gotta learn to keep up. It's time to add our monstrous database into the continuous integration pipeline. But first, we need to know what we're going into and need to familiarize ourselves with the terms and methodologies of the world of software development lifecycles.

More info:
https://eitanblumin.com/portfolio/ci-cd-ssdt-development-lifecycle-basics-dbas/

SSDT Methodologies for SQL Server DevOps en

In this session, we will cover the concepts and methodologies in SSDT that allow DBAs to implement a continuous database development lifecycle.

SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD - SSDT has it all - and it's completely free!

More info here:
https://eitanblumin.com/portfolio/ci-cd-ssdt-methodologies-for-db-devops/

How to HADR Your SQL Jobs en

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 which you need to be 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.

SSDT Tools and Features for SQL Server DevOps en

Meet SSDT (SQL Server Data Tools), that comes with the SQL Database Project as an effective tool for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD: SSDT comes with an answer for all.

In this session, the 3rd of a multi-part series, we will cover the rich tools, features, and concepts in SSDT that allow DBAs to implement a continuous database development lifecycle. We will also learn about solutions to common fears and objections coming from naysayers, common problems while starting with SSDT for the first time, and various problematic edge cases and how to solve them.

SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD - SSDT has it all - and it's completely free!

More details here:
https://eitanblumin.com/portfolio/ci-cd-ssdt-tools-and-features-for-db-devops/

Maximizing ROI and Reducing Costs of SQL Server Hardware en

In today's data-driven world, managing a production machine with SQL Server can be a costly endeavor, with expenses stemming from both hardware and licensing. Join us for an insightful webinar as we delve into the intricacies of optimizing your SQL Server hardware setup to maximize cost savings.

This webinar is designed for IT professionals, database administrators, and decision-makers who are responsible for SQL Server environments in their organizations. Whether you are working with on-premises infrastructure or cloud-based solutions, this session will provide valuable insights and strategies to help you optimize your SQL Server hardware, reduce costs, and enhance overall performance.

By attending this webinar, participants will gain the following key take-away objectives:

Identify Cost Inefficiencies: Learn how to pinpoint common cost inefficiencies in your SQL Server hardware setup and licensing.

Avoid Common Pitfalls: Discover the most prevalent pitfalls that can drain your budget and hinder performance, and gain insights into how to avoid them.

Licensing Insights: Gain a comprehensive understanding of SQL Server licensing models and how to make informed decisions to minimize licensing costs.

Cloud vs. On-Premises: Understand the unique challenges and opportunities for cost savings in both on-premises and cloud-based SQL Server environments.

Real-World Experience: Benefit from Eitan Blumin's expertise in successfully tackling cost-saving challenges in SQL Server environments.

More info here:
https://eitanblumin.com/portfolio/how-to-save-money-on-your-sql-server-hardware/

Contained Availability Groups in SQL Server 2022 en

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.

For more info: https://eitanblumin.com/portfolio/contained-availability-groups-in-sql-server-2022/

Troubleshooting Common SSDT Errors en

You want to implement DevOps for your SQL Server database. So, you created a SQL Server Database Project in Visual Studio or VSCode using SSDT. Maybe you even have a CI/CD pipeline all ready to go...

But now, you're starting to see all kinds of errors and problems that you're not sure how to tackle. Maybe you have some kind of edge case in your target environment. Maybe you need to store something in your project and you don't know how. Maybe you're having trouble with your unit tests. Maybe your project can't even be built properly without getting a bunch of errors.

You're starting to doubt... Was SSDT even the right choice?? CAN this even be done at all???

Join me in this important session for you to learn How To Do It Right. Based on my real-world experience of consulting and mentoring multiple organizations in their implementation of SQL Server DevOps.

Database DevOps for Leaders en he

Until recently, database development often lagged behind application development in adopting modern lifecycle techniques. This disparity leads to inefficiencies, errors, and communication issues between teams, and hurts the organization's time-to-market capabilities in both the short and long term.

In this session, we'll focus on the meaning of DB DevOps, the reasons to implement it or not, the motivations behind it, cost vs benefit considerations, best practices for the management level, etc.

Don't miss this opportunity to streamline your development process, enhance collaboration between teams, and ensure the reliability and efficiency of your software product.

More info:
https://eitanblumin.com/portfolio/ci-and-cd-with-ssdt-part-0-database-devops-for-leaders/

Database DevOps for Leaders en he

Until recently, database development often lagged behind application development in adopting modern lifecycle techniques. This disparity leads to inefficiencies, errors, and communication issues between teams, and hurts the organization's time-to-market capabilities in both the short and long term.

In this session, we'll focus on the meaning of DB DevOps, the reasons to implement it or not, the motivations behind it, cost vs benefit considerations, best practices for the management level, etc.

Don't miss this opportunity to streamline your development process, enhance collaboration between teams, and ensure the reliability and efficiency of your software product.

More info:
https://eitanblumin.com/portfolio/ci-and-cd-with-ssdt-part-0-database-devops-for-leaders/

Going Multi-Platform with SDK-style SQL Database Projects en he

In this session, we'll explore how to create and manage SQL database projects across different platforms, focusing on the differences between SDK-style projects and classic SSDT projects.

In this session, you'll learn:

- What are SDK-style SQL Database Projects: Basics and benefits, and how to handle SQL projects on various platforms.
- SDK-style vs. Classic SSDT Projects: Key differences and why they matter.
- Getting started with SDK-style SQL Database Projects: Step-by-step instructions for various scenarios.

This webinar will give you practical knowledge to make your SQL database projects more flexible and efficient, no matter the platform.

Going Multi-Platform with SDK-style SQL Database Projects en he

In this session, we'll explore how to create and manage SQL database projects across different platforms, focusing on the differences between SDK-style projects and classic SSDT projects.

In this session, you'll learn:

- What are SDK-style SQL Database Projects: Basics and benefits, and how to handle SQL projects on various platforms.
- SDK-style vs. Classic SSDT Projects: Key differences and why they matter.
- Getting started with SDK-style SQL Database Projects: Step-by-step instructions for various scenarios.

This webinar will give you practical knowledge to make your SQL database projects more flexible and efficient, no matter the platform.