Skip to content
Home » Projects

Projects

CI and CD with SSDT and living to tell about it

CI and CD with SSDT Part 5 – Going Multi-Platform with SDK-style SQL Database Projects

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.

Read More »CI and CD with SSDT Part 5 – Going Multi-Platform with SDK-style SQL Database Projects
CI and CD with SSDT and living to tell about it

CI and CD with SSDT Part 0 – Database DevOps for Leaders

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, the prelude for a multi-part series, we’ll focus on the meaning of DevOps in general and DB DevOps specifically, the reasons to implement it or not, the motivations behind it, cost vs benefit considerations, best practices for the management level, and more.

Read More »CI and CD with SSDT Part 0 – Database DevOps for Leaders

SQL Server Multi-Tenancy in the Real World

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.

Read More »SQL Server Multi-Tenancy in the Real World
CI and CD with SSDT and living to tell about it

CI and CD with SSDT Part 4 – Troubleshooting Common SSDT Errors

So, you want to implement DevOps for your SQL Server database, huh? So you went ahead and created a SQL Server Database Project in 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???

In this session, the 4th of a multi-part series, we will 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, dealing with common problems while starting with SSDT for the first time, and various problematic edge cases and how to solve them.

Read More »CI and CD with SSDT Part 4 – Troubleshooting Common SSDT Errors

Contained Availability Groups in SQL Server 2022

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.
Read More »Contained Availability Groups in SQL Server 2022

How to Save Money on Your SQL Server Hardware

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.

Read More »How to Save Money on Your SQL Server Hardware
CI and CD with SSDT and living to tell about it

CI and CD with SSDT Part 3 – SSDT Tools and Features for DB DevOps

Meet SSDT (SQL Server Data Tools), which 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.

Read More »CI and CD with SSDT Part 3 – SSDT Tools and Features for DB DevOps
CI and CD with SSDT and living to tell about it

CI and CD with SSDT Part 2 – SSDT Methodologies for DB DevOps

In this session, the second of a multi-part series, we will cover the concepts and methodologies in SSDT that allow DBAs to work with source control, implement a continuous database development lifecycle, and implement proper change automation.

In this session, you will learn the methodologies and best practices of working with database development lifecycle and change automation (specifically using SSDT), understand the differences between state-based and migration-based deployments, learn how to strategically tackle common edge cases, and more.

Read More »CI and CD with SSDT Part 2 – SSDT Methodologies for DB DevOps

Performance Monitoring with Azure SQL Analytics

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.

Read More »Performance Monitoring with Azure SQL Analytics

Cosmos DB to SQL Server Migration

Wherever you look, you find tools and resources to help you migrate from something that is not Cosmos DB, to Cosmos DB. The Cosmos DB migration utility tool can only export a JSON file at most, but that can rarely be good enough if you need to move around more than a handful of documents.

Assume that you decided to move your data out of Cosmos DB. I ain’t asking you why. Either way, you’re gonna have a very hard time finding a ready made solution for this.

Read More »Cosmos DB to SQL Server Migration