Deborah Melkin's Speaker Profile @ Sessionize

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Deborah Melkin's Speaker Profile @ Sessionize</title> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0">  <link rel="stylesheet" href="/landing/stylesheets/style.css?ver=1.0.9199.39817">  <link href="https://fonts.googleapis.com/css2?family=Playfair+Display:ital,wght@0,700;0,800;0,900;1,700;1,800;1,900&display=swap" rel="stylesheet"> <link href="/ClientPlugins/fontawesome/css/all.min.css" rel="stylesheet"> <link href="/ClientPlugins/fontawesome/css/v4-shims.min.css" rel="stylesheet"> <script type="text/javascript"> function consoleLog(...parameters) { } </script> <link rel="icon" type="image/svg+xml" href="/favicon"> <link rel="alternate icon" href="/landing/images/favicon/favicon.png"> <link rel="mask-icon" href="/landing/images/favicon/favicon-safari.svg" color="#1AB394"> <link rel="apple-touch-icon" href="/landing/images/favicon/apple-touch-icon.png"> <link rel="manifest" href="/landing/manifest.webmanifest">  <script async src="https://www.googletagmanager.com/gtag/js?id=G-9RSMQ9D5LK"></script> <script> window.dataLayer = window.dataLayer || []; function gtag() { dataLayer.push(arguments); } gtag('js', new Date()); gtag('config', 'G-9RSMQ9D5LK'); </script> <script type="text/javascript"> (function (c, l, a, r, i, t, y) { c[a] = c[a] || function () { (c[a].q = c[a].q || []).push(arguments) }; t = l.createElement(r); t.async = 1; t.src = "https://www.clarity.ms/tag/" + i; y = l.getElementsByTagName(r)[0]; y.parentNode.insertBefore(t, y); })(window, document, "clarity", "script", "pu667el35e"); window.clarity("identify", "", "83e1869cf40f290490fa7de267a5a040", "SpeakerProfile/PublicProfile", null) </script> <script type="text/javascript"> !function (T, l, y) { var S = T.location, k = "script", D = "connectionString", C = "ingestionendpoint", I = "disableExceptionTracking", E = "ai.device.", b = "toLowerCase", w = "crossOrigin", N = "POST", e = "appInsightsSDK", t = y.name || "appInsights"; (y.name || T[e]) && (T[e] = t); var n = T[t] || function (d) { var g = !1, f = !1, m = { initialize: !0, queue: [], sv: "5", version: 2, config: d }; function v(e, t) { var n = {}, a = "Browser"; return n[E + "id"] = a[b](), n[E + "type"] = a, n["ai.operation.name"] = S && S.pathname || "_unknown_", n["ai.internal.sdkVersion"] = "javascript:snippet_" + (m.sv || m.version), { time: function () { var e = new Date; function t(e) { var t = "" + e; return 1 === t.length && (t = "0" + t), t } return e.getUTCFullYear() + "-" + t(1 + e.getUTCMonth()) + "-" + t(e.getUTCDate()) + "T" + t(e.getUTCHours()) + ":" + t(e.getUTCMinutes()) + ":" + t(e.getUTCSeconds()) + "." + ((e.getUTCMilliseconds() / 1e3).toFixed(3) + "").slice(2, 5) + "Z" }(), name: "Microsoft.ApplicationInsights." + e.replace(/-/g, "") + "." + t, sampleRate: 100, tags: n, data: { baseData: { ver: 2 } } } } var h = d.url || y.src; if (h) { function a(e) { var t, n, a, i, r, o, s, c, u, p, l; g = !0, m.queue = [], f || (f = !0, t = h, s = function () { var e = {}, t = d.connectionString; if (t) for (var n = t.split(";"), a = 0; a < n.length; a++) { var i = n[a].split("="); 2 === i.length && (e[i[0][b]()] = i[1]) } if (!e[C]) { var r = e.endpointsuffix, o = r ? e.location : null; e[C] = "https://" + (o ? o + "." : "") + "dc." + (r || "services.visualstudio.com") } return e }(), c = s[D] || d[D] || "", u = s[C], p = u ? u + "/v2/track" : d.endpointUrl, (l = []).push((n = "SDK LOAD Failure: Failed to load Application Insights SDK script (See stack for details)", a = t, i = p, (o = (r = v(c, "Exception")).data).baseType = "ExceptionData", o.baseData.exceptions = [{ typeName: "SDKLoadFailed", message: n.replace(/\./g, "-"), hasFullStack: !1, stack: n + "\nSnippet failed to load [" + a + "] -- Telemetry is disabled\nHelp Link: https://go.microsoft.com/fwlink/?linkid=2128109\nHost: " + (S && S.pathname || "_unknown_") + "\nEndpoint: " + i, parsedStack: [] }], r)), l.push(function (e, t, n, a) { var i = v(c, "Message"), r = i.data; r.baseType = "MessageData"; var o = r.baseData; return o.message = 'AI (Internal): 99 message:"' + ("SDK LOAD Failure: Failed to load Application Insights SDK script (See stack for details) (" + n + ")").replace(/\"/g, "") + '"', o.properties = { endpoint: a }, i }(0, 0, t, p)), function (e, t) { if (JSON) { var n = T.fetch; if (n && !y.useXhr) n(t, { method: N, body: JSON.stringify(e), mode: "cors" }); else if (XMLHttpRequest) { var a = new XMLHttpRequest; a.open(N, t), a.setRequestHeader("Content-type", "application/json"), a.send(JSON.stringify(e)) } } }(l, p)) } function i(e, t) { f || setTimeout(function () { !t && m.core || a() }, 500) } var e = function () { var n = l.createElement(k); n.src = h; var e = y[w]; return !e && "" !== e || "undefined" == n[w] || (n[w] = e), n.onload = i, n.onerror = a, n.onreadystatechange = function (e, t) { "loaded" !== n.readyState && "complete" !== n.readyState || i(0, t) }, n }(); y.ld < 0 ? l.getElementsByTagName("head")[0].appendChild(e) : setTimeout(function () { l.getElementsByTagName(k)[0].parentNode.appendChild(e) }, y.ld || 0) } try { m.cookie = l.cookie } catch (p) { } function t(e) { for (; e.length;)!function (t) { m[t] = function () { var e = arguments; g || m.queue.push(function () { m[t].apply(m, e) }) } }(e.pop()) } var n = "track", r = "TrackPage", o = "TrackEvent"; t([n + "Event", n + "PageView", n + "Exception", n + "Trace", n + "DependencyData", n + "Metric", n + "PageViewPerformance", "start" + r, "stop" + r, "start" + o, "stop" + o, "addTelemetryInitializer", "setAuthenticatedUserContext", "clearAuthenticatedUserContext", "flush"]), m.SeverityLevel = { Verbose: 0, Information: 1, Warning: 2, Error: 3, Critical: 4 }; var s = (d.extensionConfig || {}).ApplicationInsightsAnalytics || {}; if (!0 !== d[I] && !0 !== s[I]) { var c = "onerror"; t(["_" + c]); var u = T[c]; T[c] = function (e, t, n, a, i) { var r = u && u(e, t, n, a, i); return !0 !== r && m["_" + c]({ message: e, url: t, lineNumber: n, columnNumber: a, error: i }), r }, d.autoExceptionInstrumented = !0 } return m }(y.cfg); function a() { y.onInit && y.onInit(n) } (T[t] = n).queue && 0 === n.queue.length ? (n.queue.push(a), n.trackPageView({})) : a() }(window, document, { src: "https://js.monitor.azure.com/scripts/b/ai.2.min.js", // The SDK URL Source // name: "appInsights", // Global SDK Instance name defaults to "appInsights" when not supplied // ld: 0, // Defines the load delay (in ms) before attempting to load the sdk. -1 = block page load and add to head. (default) = 0ms load after timeout, // useXhr: 1, // Use XHR instead of fetch to report failures (if available), crossOrigin: "anonymous", // When supplied this will add the provided value as the cross origin attribute on the script tag // onInit: null, // Once the application insights instance has loaded and initialized this callback function will be called with 1 argument -- the sdk instance (DO NOT ADD anything to the sdk.queue -- As they won't get called) cfg: { // Application Insights Configuration connectionString: "InstrumentationKey=ba35a242-e5fe-43ee-8c84-4a7a79591411;IngestionEndpoint=https://westeurope-5.in.applicationinsights.azure.com/;LiveEndpoint=https://westeurope.livediagnostics.monitor.azure.com/", disableCookiesUsage: true /* ...Other Configuration Options... */ } }); </script> <meta name="twitter:card" content="summary" /> <meta name="twitter:site" content="@SessionizeCom" /> <meta name="twitter:creator" content="@dgmelkin" /> <meta property="og:image" content="https://sessionize.com/image/8678-400o400o2-d3-ea7e-4f27-a774-46031c7ba283.6a49f680-3a85-4344-95a1-be6e00211344.jpg" /> <meta property="og:url" content="https://sessionize.com/dgmelkin/" /> <meta property="og:title" content="Deborah Melkin's Speaker Profile" /> <link rel="canonical" href="https://sessionize.com/dgmelkin/" /> <meta property="og:description" content="Deborah Melkin has been working as a database professional with SQL Server for over 20 years. She spends her days helping programmers with all aspects..." /> <meta name="description" content="Deborah Melkin has been working as a database professional with SQL Server for over 20 years. She spends her days helping programmers with all aspects..." /> </head> <body> <div class="c-skip-links"> <a href="#navigation" class="c-skip-links__link">Jump to navigation</a> <a href="#main" class="c-skip-links__link">Jump to content</a> </div> <div class="l-site l-site--speaker">  <header class="l-header c-header l-header--relative" role="banner"> <div class="l-container"> <div class="c-header__branding"> <div class="c-header__logo"> <a href="/"> <img src="/landing/images/sessionize-logo.svg" alt="Sessionize"> </a> </div> </div> <button class="c-header__menu" role="button"> <span class="o-label">Menu</span> <svg class="o-icon o-icon-menu" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-menu"></use></svg> <svg class="o-icon o-icon-close" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-close"></use></svg> </button> <div class="c-header__content"> <nav class="c-nav-header" id="navigation1"> <ul class="c-nav-header__items"> <li class="c-nav-header__item "> <a class="c-nav-header__link" href="/speakers-directory">Speakers Directory</a> </li> <li class="c-nav-header__item "> <a class="c-nav-header__link" href="/speakers-directory/favorites"> Favorites <span id="fav-count" style="display: none;" class="c-nav-header__value"></span> </a> </li> </ul> <div class="c-nav-header__actions"> <a href="/app" class="c-button c-button--sm c-button--outline"> <span class="c-button__label">Login</span> </a> <a href="/app/speaker/profile" class="c-button c-button--sm"> <span class="c-button__label">Join for Free</span> </a> </div> </nav> </div> </div> </header>   <div class="l-main c-main vue-speaker-profile" id="main"> <div class="c-block "> <div class="l-container"> <div class="l-content l-content--swap"> <div class="l-content__primary">  <div class="c-s-section" id="speaker"> <div class="c-s-section__header c-s-section__header--most-active"> <h2 class="c-s-section__title"> <a class="c-s-section__anchor" href="#speaker">Most Active Speaker</a> </h2> <div class="c-s-section__more"> <button class="c-button c-button--icon c-button--sm c-s-report" data-a11y-dialog-show="dialog-report"> <span class="o-label">Report profile</span> <svg class="o-icon o-icon-flag-alt" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-flag-alt"></use></svg> </button> </div> </div> <div class="c-s-speaker-info c-s-speaker-info--full"> <div class="c-s-speaker-info__media"> <figure class="c-s-speaker-info__avatar"> <img src="https://sessionize.com/image/8678-400o400o2-d3-ea7e-4f27-a774-46031c7ba283.6a49f680-3a85-4344-95a1-be6e00211344.jpg" alt="Deborah Melkin" /> </figure> </div> <h1 class="c-s-speaker-info__name">Deborah Melkin</h1> <p v-if="activeLanguage.speaker == 'en'" class="c-s-speaker-info__tagline">Data Engineer, Microsoft MVP - Data Platform</p> <p class="c-s-speaker-info__location"> <svg class="o-icon o-icon-map-marker-alt" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-map-marker-alt"></use></svg> Boston, Massachusetts, United States </p> <div class="c-s-speaker-info__group c-s-speaker-info__group--actions"> <h3 class="c-s-speaker-info__group-title">Actions</h3> <div class="c-s-actions"> <button class="c-button c-button--sm c-button--toggle c-button--favorite " onclick="favoriteSpeaker(this, '582617d3-ea7e-4f27-a774-46031c7ba283')"> <svg class="o-icon o-icon-star" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-star"></use></svg> <svg class="o-icon o-icon-star-fill" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-star-fill"></use></svg> <span class="c-button__label">Favorite</span> </button> <button class="c-button c-button--sm" onclick="contactSpeaker(this, '582617d3-ea7e-4f27-a774-46031c7ba283')"> <svg class="o-icon o-icon-envelope" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-envelope"></use></svg> <span class="c-button__label">Contact</span> </button> </div> </div> <div v-if="activeLanguage.speaker == 'en'" class="c-s-speaker-info__bio"> <p>Deborah Melkin has been working as a database professional with SQL Server for over 20 years. She spends her days helping programmers with all aspects of database design, queries, performance, and deployment. In 2016, she began her blog, Deb the DBA. Soon after that, she began speaking at SQL Saturdays and user groups. Deborah is a co-leader of the Data Platform Women in Tech (WIT) Virtual User Group and co-founder of WITspiration, a WIT mentorship circle. She is a former board member of the New England SQL Server User Group. She was named as One to Watch as part of the #Redgate 100 in 2022 and won Speaker Idol at PASS Summit 2019. Deborah is also a Microsoft MVP for the Data Platform (2020- ). <br /><br />In her spare time, Deborah can usually be found doing something musical or something geeky with her husband, Andy, and their dog, Sebastian.</p> </div> <div class="c-s-speaker-info__group c-s-speaker-info__group--links"> <h3 class="c-s-speaker-info__group-title">Links</h3> <ul class="c-s-links c-s-links--inline "> <li class="c-s-links__item"> <a class="c-s-links__link" href="https://twitter.com/dgmelkin" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-twitter" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-twitter"></use></svg> <span class="o-label">@dgmelkin</span> </a> </li> <li class="c-s-links__item"> <a class="c-s-links__link" href="http://linkedin.com/in/deborah-melkin" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-linkedin" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-linkedin"></use></svg> <span class="o-label">LinkedIn</span> </a> </li> <li class="c-s-links__item"> <a class="c-s-links__link" href="https://debthedba.wordpress.com/" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-pen" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-pen"></use></svg> <span class="o-label">Blog</span> </a> </li> </ul> </div> <div class="c-s-speaker-info__group c-s-speaker-info__group--awards"> <h3 class="c-s-speaker-info__group-title">Awards</h3> <ul class="c-s-awards"> <li class="c-s-awards__item"> <a href="/most-active-speakers-2024/"><img src="/Assets/speaker-certificate/Most_Active_Speaker2024.svg" style="height: auto;" alt="Most Active Speaker 2024" /></a> </li> <li class="c-s-awards__item"> <a href="/most-active-speakers-2023/"><img src="/Assets/speaker-certificate/Most_Active_Speaker2023.svg" style="height: auto;" alt="Most Active Speaker 2023" /></a> </li> <li class="c-s-awards__item"> <a href="https://mvp.microsoft.com/en-US/MVP/profile/09d44726-ef18-eb11-a813-000d3a8dfe0d" target="_blank"> <img src="/Assets/speaker-certificate/msmvp.png" style="height: auto;" alt="Microsoft MVP" /> </a> </li> </ul> </div> <div class="c-s-speaker-info__group c-s-speaker-info__group--industry"> <h3 class="c-s-speaker-info__group-title"> Area of Expertise </h3> <ul class="c-s-tags"> <li class="c-s-tags__item"> <svg class="o-icon o-icon-star" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-star"></use></svg> Information & Communications Technology </li> </ul> </div> <div class="c-s-speaker-info__group"> <h3 class="c-s-speaker-info__group-title">Topics</h3> <ul class="c-s-tags"> <li class="c-s-tags__item">SQL Server</li> <li class="c-s-tags__item">SQL Server Data Tools</li> <li class="c-s-tags__item">SQL Server Developer</li> <li class="c-s-tags__item">SQL Server Development</li> <li class="c-s-tags__item">SQL Server Indexes</li> <li class="c-s-tags__item">Microsoft SQL Server and Azure Data SQL</li> <li class="c-s-tags__item">Microsoft SQL Server</li> <li class="c-s-tags__item">SQL Server DBA</li> <li class="c-s-tags__item">Azure SQL Server</li> </ul> </div> </div> </div>   <div class="c-s-section" id="sessions"> <div class="c-s-section__header"> <h2 class="c-s-section__title"> <a class="c-s-section__anchor" href="#sessions">Sessions</a> </h2> </div> <div class="c-s-timeline"> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/the-benefits-of-mentoring/130663">The Benefits of Mentoring</a> </h3> <p class="c-s-session__summary">They say “it takes a village” to achieve your goals. The hardest part of that advice is finding your village. One way to do this is to find a mentor and be one. <br /><br />Join me as we will explore the benefits of mentorship. We'll talk about how to find mentors or mentees. We will discuss setting expectations and goals. We'll also look into ways of structuring communication to create a successful mentoring relationship.<br /><br />When you leave, you will have the information and encouragement to find and cultivate a successful mentoring relationship. Remember, you don't have to do your career alone. </p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/single-statement-many-changes-how-one-statement-ca/84982">Single Statement, Many Changes: How One Statement Can Modify Multiple Tables</a> </h3> <p class="c-s-session__summary">You can only insert into, update, or delete from one table at a time. At least that’s what we’re told when we first learn to write SQL statements. However, the truth is that one data change could affect many other tables.<br /><br />In this session, we will example how one data modification statement can affect numerous tables. We'll break these down into two different approaches: implicit & explicit. We will explore syntax, performance gains, and gotchas of these different methodologies.<br /><br />Our goal is to not only understand how to implement these different techniques but ask why (and where) we may want to use them.</p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/choosing-the-right-tool-for-the-job/84981">Choosing the Right Tool for the Job</a> </h3> <p class="c-s-session__summary">There’s a saying about using the right tool for the right job. After all, you don't want to use a hammer when you need a screwdriver. We have many tools available to us to do our job as data professionals - some work better as development tools and other for admin tasks while some can handle either. So how do you decide which to use when? <br /><br />In this session we’ll cover the most commonly used tools. We’ll look at where they work well and when we may need to look for a different tool. We’ll discuss areas where the tools intersect and work directly with each other. Some of the tools we will look at include Management Studio, Azure Data Studio, and Plan Explorer.<br /><br />At the end, you should be able to go back to work with a better understanding of the tools available to us, when to use them, and how they can make your job easier to do.</p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/data-integrity-demystified/84980">Data Integrity Demystified</a> </h3> <p class="c-s-session__summary">When we talk about “knowing our data,” we don’t seem to refer to the term “data integrity” anymore as part of that conversation. After all, that phrase can be very intimidating. But at its heart, it’s very simple – guaranteeing our data has meaning. The good news is much of what we already do creates data integrity in our databases.<br /><br />In this session, we will explore how the basic constructs in our database design enforce data integrity. We will look at this from table design down through details, like data types and constraints. Additionally, we will discuss the difference between objects that support data integrity and those that support database performance.<br /><br />At the end of the session, you will have a better understanding of what data integrity is, how to implement and enforce it in your databases, and why it is so important for our data.</p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/mastering-dynamic-sql/84979">Mastering Dynamic SQL</a> </h3> <p class="c-s-session__summary">Dynamic SQL has a bad reputation. Some of it is even deserved. However, dynamic SQL can be a great tool to have in your toolbox when used correctly.<br /><br />In this session, we'll dive into creating and troubleshooting dynamic SQL syntax. We will start by examining various scenarios that would be good candidates for implementation. Then we'll take a look at how it executes under the covers. We'll discuss ways of smarter and safer ways of crafting our SQL statements. And of course, we will discuss various ways to debug the statements as well as add error handling.<br /><br />You will leave this session with a better understanding and appreciation for how dynamic SQL works as well as why and when to use it.</p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/database-deployment-methods-demystified/84978">Database Deployment Methods Demystified</a> </h3> <p class="c-s-session__summary">If you had to describe the database deployment process, you may say: We make changes in dev, magic happens, and then they appear in production. The technical part of that magic is what we’ll discuss.<br /><br />In this session, we will explore the different ways that database changes can be applied - state based or migration scripts. We’ll look at how this impacts the various parts of the development lifecycle. We’ll examine some of the unexpected implications of how we deploy changes, including source control and database projects. This session isn’t just about implementing DevOps but about technical considerations regardless of how you deploy changes.<br /><br />By the end of this session, you should have a clear understanding of the different ways to deploy your database changes, how they work, and most importantly, why you may want to implement those options.<br /></p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/back-to-the-basics-t-sql-101/84977">Back to the Basics: T-SQL 101</a> </h3> <p class="c-s-session__summary">Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for querying data. We'll break down the fundamental statements to look at the different parts to see how they work together. <br /><br />This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.</p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/a-practical-starter-guide-to-sql-notebooks/84976">A Practical Starter Guide to SQL Notebooks</a> </h3> <p class="c-s-session__summary">Have you been hearing about SQL Notebooks in Azure Data Studio but haven't worked with them yet? Or have you played around with notebooks but not been able to figure out how to make them work for you?<br /><br />Let's jump into SQL Notebooks together as we figure out how we can use them in our day-to-day work! We will start by looking at the different options that are available to us in SQL Notebooks. Then we will examine real world scenarios and create notebooks for them. Finally, we will learn how we can share the notebooks with our coworkers.<br /><br />When you leave, you will have the practical knowledge and comfort level to use SQL Notebooks in your day-to-day work.</p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/beyond-the-basic-select/84975">Beyond the Basic SELECT</a> </h3> <p class="c-s-session__summary">The SELECT statement is one of the most used tools in our SQL toolbelt. While it’s the basis for what we do with data, it’s anything but basic. In this presentation, we will first explore how SELECT statements are processed. Then we will discuss various ways we build on to our SELECTs. We'll also examine how and why we may or may not want to use them. At the end of the session, we will have a greater understanding of how SELECTS work and how we can approach them so we can be smarter as we write more complex statements.</p> <p> <small></small> </p> </div> </div> <div class="c-s-timeline__item" v-if="activeLanguage.sessions == 'en' || (activeLanguage.sessions == '' && true)"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-presentation" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-presentation"></use></svg> </span> </div> <div class="c-s-session"> <h3 class="c-s-session__title"> <a href="/s/dgmelkin/conquering-the-monster-proc-how-to-combat-legacy-c/84984">Conquering the Monster Proc - How to Combat Legacy Code</a> </h3> <p class="c-s-session__summary">We all have that one monster stored procedure: incredibly complex and integral to the application. But performance has been getting worse, and now it can no longer be ignored. You finally got the green light to make improvements but upon opening the code, you realize there's a bigger problem: Where do you begin? Is a full rewrite is appropriate? Do you have enough time to resolve all the issues? Are there any easy fixes to improve performance? <br /><br />In this session, we'll answer these questions and more. By the end, you will leave with a smart tactical plan of attack to conquer that monster proc.</p> <p> <small></small> </p> </div> </div> </div> </div>   <div class="c-s-section" id="events"> <div class="c-s-section__header"> <h2 class="c-s-section__title"> <a class="c-s-section__anchor" href="#events">Events</a> </h2> </div> <div class="c-s-timeline"> <div class="c-s-timeline__item"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-calendar" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-calendar"></use></svg> </span> </div> <div class="c-s-event"> <h3 class="c-s-event__title"> <a class="c-s-event__name" href="https://sqlsaturday.com/2025-03-08-sqlsaturday1102/" rel="nofollow" target="_blank">SQL Saturday Atlanta 2025 - AI & BI</a> <span class="c-s-event__type" title="Sessionize Event"> <span class="u-screen-reader-text">Sessionize Event</span> <svg class="o-icon o-icon-sessionize" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-sessionize"></use></svg> </span> </h3> <span class="c-s-event__meta c-s-event__meta--date"> March 2025 </span> <span class="c-s-event__meta c-s-event__meta--location">Alpharetta, Georgia, United States</span> </div> </div> <div class="c-s-timeline__item"> <div class="c-s-timeline__indicator"> <span class="c-s-timeline__icon"> <svg class="o-icon o-icon-calendar" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-calendar"></use></svg> </span> </div> <div class="c-s-event"> <h3 class="c-s-event__title"> <a class="c-s-event__name" href="https://www.dataweekender.com/" rel="nofollow" target="_blank">#DataWeekender 7.0</a> <span class="c-s-event__type" title="Sessionize Event"> <span class="u-screen-reader-text">Sessionize Event</span> <svg class="o-icon o-icon-sessionize" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-sessionize"></use></svg> </span> </h3> <span class="c-s-event__meta c-s-event__meta--date"> March 2025 </span> </div> </div> </div> </div>  </div> <div class="l-content__secondary"> <div class="c-speaker-info c-s-speaker-info--compact"> <div class="c-s-speaker-info__media"> <figure class="c-s-speaker-info__avatar"> <img src="https://sessionize.com/image/8678-400o400o2-d3-ea7e-4f27-a774-46031c7ba283.6a49f680-3a85-4344-95a1-be6e00211344.jpg" /> </figure> </div> <h1 class="c-s-speaker-info__name">Deborah Melkin</h1> <p class="c-s-speaker-info__tagline">Data Engineer, Microsoft MVP - Data Platform</p> <p class="c-s-speaker-info__location"> <svg class="o-icon o-icon-map-marker-alt" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-map-marker-alt"></use></svg> Boston, Massachusetts, United States </p> <div class="c-s-speaker-info__group c-s-speaker-info__group--links"> <h3 class="c-s-speaker-info__group-title">Links</h3> <ul class="c-s-links c-s-links--inline1 "> <li class="c-s-links__item"> <a class="c-s-links__link" href="https://twitter.com/dgmelkin" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-twitter" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-twitter"></use></svg> <span class="o-label">@dgmelkin</span> </a> </li> <li class="c-s-links__item"> <a class="c-s-links__link" href="http://linkedin.com/in/deborah-melkin" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-linkedin" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-linkedin"></use></svg> <span class="o-label">LinkedIn</span> </a> </li> <li class="c-s-links__item"> <a class="c-s-links__link" href="https://debthedba.wordpress.com/" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-pen" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-pen"></use></svg> <span class="o-label">Blog</span> </a> </li> </ul> </div> <div class="c-s-speaker-info__group c-s-speaker-info__group--actions"> <h3 class="c-s-speaker-info__group-title">Actions</h3> <div class="c-s-actions"> <button class="c-button c-button--sm c-button--toggle c-button--favorite " onclick="favoriteSpeaker(this, '582617d3-ea7e-4f27-a774-46031c7ba283')"> <svg class="o-icon o-icon-star" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-star"></use></svg> <svg class="o-icon o-icon-star-fill" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-star-fill"></use></svg> <span class="c-button__label">Favorite</span> </button> <button class="c-button c-button--sm" onclick="contactSpeaker(this, '582617d3-ea7e-4f27-a774-46031c7ba283')"> <svg class="o-icon o-icon-envelope" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-envelope"></use></svg> <span class="c-button__label">Contact</span> </button> </div> </div> </div> </div> </div> </div> </div> <div class="c-block c-block--compact c-block--center"> <div class="l-container"> <p class="u-text-xs">Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please <a href="#">let us know</a>.</p> <a href="#main" class="c-scroll-top c-scroll-top--speaker-profile c-scroll-top--fixed js-scrollToTop"> <svg class="o-icon o-icon-arrow-up" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-arrow-up"></use></svg> <svg viewBox="0 0 48 48" class="c-scroll-indicator"> <circle class="c-scroll-indicator__progress" cx="24" cy="24" r="23" style="stroke-dasharray: 144.44px; stroke-dashoffset: 50px;"> </circle> </svg> <span class="u-screen-reader-text">Jump to top</span> </a> </div> </div> </div> <div class="c-modal" id="dialog-report" aria-labelledby="dialog-report-title" aria-hidden="true" data-a11y-dialog="dialog-report"> <div class="c-modal__overlay" data-a11y-dialog-hide></div> <div class="c-modal__dialog" role="document"> <button class="c-button c-button--icon c-modal__close" type="button" data-a11y-dialog-hide aria-label="Close dialog"> <svg class="o-icon o-icon-close" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-close"></use></svg> </button> <div class="c-modal__header"> <h1 class="c-modal__title" id="dialog-report-title">Report this profile</h1> </div> <div class="c-modal__content"> <iframe style="width: 10px; height: 10px; visibility: hidden; position: absolute;" name="form-iframe"></iframe> <form action="/report-page" id="report-form" method="post" role="form"><input name="__RequestVerificationToken" type="hidden" value="Hcs89vc-R1RTDxOgQCQHuWark0ylqBqgLo2iyEfxsIhWm5pZeEdpQcBbXo7OT0KsR0NiExuvwFmOiULO02z12VeAMbjFkAO9S1MFoQq8pyE1" /><input id="url" name="url" type="hidden" value="/dgmelkin" /> <div class="c-fields l-fields"> <div class="c-field l-fields__item"> <label class="c-field__label" for="field-radio"> Select a reason </label> <div class="c-field__group"> <div class="o-radio"> <input type="radio" id="r1" name="reason" value="Not private"> <label for="r1"> Does not belong to a private person </label> </div> <div class="o-radio"> <input type="radio" id="r2" name="reason" value="Not speaker"> <label for="r2"> Does not represent a speaker </label> </div> <div class="o-radio"> <input type="radio" id="r3" name="reason" value="Inappropriate content"> <label for="r3"> Info and/or images include abusive or hateful content </label> </div> <div class="o-radio"> <input type="radio" id="r4" name="reason" value="Spam"> <label for="r4"> Spam profile </label> </div> <div class="o-radio"> <input type="radio" id="r5" name="reason" value=""> <label for="r5"> Other reason (contact form will open) </label> </div> </div> </div> <div class="c-field l-fields__item"> <div class="c-field__group"> <button class="c-button c-button--primary c-button--large"> <span class="c-button__label">Report</span> </button> </div> </div> </div> </form> <div class="c-message is-success" id="js-thanks"> <h3 class="c-message__title">Thanks.</h3> <p class="c-message__description"> We will evaluate your report and take appropriate actions. </p> </div> </div> </div> </div> <div class="c-modal" id="dialog-contact" aria-labelledby="dialog-contact-title" aria-hidden="true" data-a11y-dialog="dialog-contact" aria-modal="true" tabindex="-1" role="dialog"> <div class="c-modal__overlay" data-a11y-dialog-hide=""></div> <div class="c-modal__dialog" role="document"> <button class="c-button c-button--icon c-modal__close" type="button" data-a11y-dialog-hide="" aria-label="Close dialog"> <svg class="o-icon o-icon-close" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-close"></use></svg> </button> <div class="c-modal__header"> <h1 class="c-modal__title" id="dialog-contact-title">Contact Deborah</h1> </div> <div class="c-modal__content"> <div class="c-field l-fields__item c-field--label-hidden"> <label class="c-field__label" for="field-radio"> Contact type </label> <div class="c-field__group"> <div class="o-radio"> <input type="radio" id="contact-invite" name="contact-type" value="invite"> <label for="contact-invite"> Invite to your Sessionize event </label> </div> <div class="o-radio"> <input type="radio" id="contact-directly" name="contact-type" value="directly"> <label for="contact-directly"> Contact directly </label> </div> </div> </div> <div id="contact-invite-holder" style="display: none;"> <h2 class="u-heading-section">Invite to your event</h2> <div class="c-message is-warning"> <p class="c-message__description">Please login to invite Deborah to your event.</p> </div> <a href="/login?returnUrl=%2Fdgmelkin" class="c-button c-button--primary"> <span class="c-button__label">Login</span> </a> </div> <div id="contact-directly-holder" style="display: none;"> <h2 class="u-heading-section">Contact directly</h2> <p>You can contact the speaker through their preferred channels. Tell speakers how you found them to kickstart the conversation.</p> <div> <ul class="c-s-links c-s-links--inline1 "> <li class="c-s-links__item"> <a class="c-s-links__link" href="https://twitter.com/dgmelkin" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-twitter" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-twitter"></use></svg> <span class="o-label">@dgmelkin</span> </a> </li> <li class="c-s-links__item"> <a class="c-s-links__link" href="http://linkedin.com/in/deborah-melkin" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-linkedin" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-linkedin"></use></svg> <span class="o-label">LinkedIn</span> </a> </li> <li class="c-s-links__item"> <a class="c-s-links__link" href="https://debthedba.wordpress.com/" rel="nofollow" target="_blank"> <svg class="o-icon o-icon-pen" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-pen"></use></svg> <span class="o-label">Blog</span> </a> </li> </ul> </div> <div class="c-fields l-fields"> <div class="c-field"> <label for="field-copy-message" class="c-field__label">Copy message</label> <div class="c-field__group"> <div class="o-textarea o-textarea--copy"> <textarea id="field-copy-message" readonly="">Hey Deborah, I found your speaker profile at https://sessionize.com/dgmelkin and I wanted to...</textarea> </div> </div> </div> </div> </div> </div> </div> </div> </div> <script src="/landing/scripts/libraries.es5.min.js?ver=1.0.9199.39817"></script> <script src="/landing/scripts/site.es5.min.js?ver=1.0.9199.39817"></script> <script type="text/javascript" id="cookiebanner" src="/Scripts/cookiebanner.min.js" data-position="bottom" data-bg="#F4F4F4" data-fg="#333" data-font-size="11px" data-text-align="left" data-moreinfo="/privacy-policy/" data-linkmsg="Details" data-close-style="float:left;padding-left:5px;padding-right:5px;color: #179D82;" data-message="We use cookies to improve your browsing experience."> </script> <div class="c-modal" id="dialog-generic" aria-labelledby="dialog-generic-title" aria-hidden="true" data-a11y-dialog="dialog-generic" aria-modal="true" tabindex="-1" role="dialog"> <div class="c-modal__overlay" data-a11y-dialog-hide></div> <div class="c-modal__dialog" role="document"> <button class="c-button c-button--icon c-modal__close" type="button" data-a11y-dialog-hide aria-label="Close dialog"> <svg class="o-icon o-icon-close" focusable="false"><use xlink:href="/landing/images/symbol-defs.svg#o-icon-close"></use></svg> </button> <div class="c-modal__header"> <h1 class="c-modal__title" id="dialog-generic-title"></h1> </div> <div class="c-modal__content"> </div> </div> </div> <script src="/landing/scripts/libraries/vue.global.prod.js?ver=1.0.9199.39817"></script> <script type="text/javascript">function updateInfoWidth(){var n=$(".l-content__secondary").width();$(".c-s-speaker-info--compact").width(n)}$(window).scroll(function(){var n=$(window).scrollTop(),t=$(".l-content__secondary").offset().top;n>=t?($(".c-s-speaker-info--compact").addClass("c-s-speaker-info--sticky"),$(".c-s-speaker-info--compact .c-s-links").addClass("c-s-links--icon")):($(".c-s-speaker-info--compact").removeClass("c-s-speaker-info--sticky"),$(".c-s-speaker-info--compact .c-s-links").removeClass("c-s-links--icon"))});$(window).scroll(updateInfoWidth);$(window).resize(updateInfoWidth);var speakerProfileVueApp=Vue.createApp({data(){return{activeLanguage:{speaker:"en",sessions:"en"}}},methods:{changeLanguage(n){var t=n.srcElement.dataset.type;return this.activeLanguage[t]=n.srcElement.dataset.language,!1}},mounted(){smoothScroll()}});speakerProfileVueApp.mount(".vue-speaker-profile");$("#dialog-report")[0].addEventListener("show",function(){$("#report-form").show();$("#js-thanks").hide()});$("#report-form").submit(function(){var n=$("#report-form"),t=n.find('input[name="reason"]:checked').val();return t!=undefined?(t==""?n[0].target="":($("#report-form").hide(),$("#js-thanks").fadeIn(),n[0].target="form-iframe"),$('*[data-a11y-dialog-show="dialog-report"]').hide(),!0):!1})</script> <script type="text/javascript">function favoriteSpeaker(){genericDialogShow("Favorite speaker",'<p>To favorite a speaker, please <a href="/login?returnUrl=%2Fdgmelkin">log in<\/a>.<\/p><p>If you don\'t have an account yet, you can <a href="/create-account?returnUrl=%2Fdgmelkin">create one<\/a>. It\'s quick, free, and there are no strings attached. We just need an account to link your favorites to.<\/p>')}</script> <script type="text/javascript">function contactSpeaker(){contactDialog.show();updateContactType();eventChanged()}function updateContactType(){var n=$('*[name="contact-type"]:checked').val();n=="directly"?($("#contact-invite-holder").slideUp(),$("#contact-directly-holder").slideDown()):n=="invite"?($("#contact-invite-holder").slideDown(),$("#contact-directly-holder").slideUp()):($("#contact-invite-holder").hide(),$("#contact-directly-holder").hide())}function eventChanged(){var i=$("#invite-event"),r=i.closest("form"),n=i.find(":selected"),t=$(".invite-left"),u,f;n.length!=0&&(u=n.data("closed"),f=n.data("closing"),u?($(".invite-celebrity-msg-holder").show(),$(".invite-celebrity-msg-soon-holder").hide(),$(".invite-celebrity-checkbox-holder").slideDown()):f?($(".invite-celebrity-msg-holder").hide(),$(".invite-celebrity-msg-soon-holder").show(),$(".invite-celebrity-checkbox-holder").slideDown()):$(".invite-celebrity-checkbox-holder").slideUp(),t.css("opacity",0),$.post(r.attr("action")+"?checkOnly=true",r.serialize(),function(n){$(".invite-already").hide();$(".invite-limit-today").hide();$(".invite-limit-month").hide();n.alreadyInvited?($(".invite-already").show(),$(".invite-enabled").slideUp(),$(".invite-disabled").slideDown()):n.leftToday<=0?($(".invite-limit-today").show(),$(".invite-enabled").slideUp(),$(".invite-disabled").slideDown()):n.leftMonth<=0?($(".invite-limit-month").show(),$(".invite-enabled").slideUp(),$(".invite-disabled").slideDown()):($(".invite-enabled").slideDown(),$(".invite-disabled").slideUp());t.find(".today").text(n.leftToday);t.find(".month").text(n.leftMonth);t.animate({opacity:1})},"json").fail(function(){alert("An error occurred. Please refresh the page and try again.")}),$("#invite-celebrity").prop("checked",!1),sessionStorage.setItem("invite-eventid",n.val()))}function eventLoadLast(){var n=sessionStorage.getItem("invite-eventid");n&&($("#invite-event").val(n),$("#invite-event").val()==null&&($("#invite-event option:first").prop("selected",!0),eventChanged()))}var contactDialog=new A11yDialog(document.getElementById("dialog-contact"));$('*[name="contact-type"]').on("change",updateContactType);$("#invite-event").on("change",eventChanged);eventLoadLast();$("#invite-form").on("submit",function(n){n.preventDefault();var t=$(this);return t.css("opacity",.5).css("pointer-events","none"),$.post(t.attr("action"),t.serialize(),function(n){n.error?genericDialogShow("Error","<p>"+n.error+"<\/p>"):(contactDialog.hide(),genericDialogShow("Invitation sent!","<p>We've sent the email notification to the speaker.<\/p>"))},"json").fail(function(){alert("An error occurred. Please refresh the page and try again.")}).always(function(){t.css("opacity",1).css("pointer-events","auto")}),!1})</script> </body> </html>

CINXE.COM

Deborah Melkin's Speaker Profile @ Sessionize