How Do Developers and DBAs Collaborate in a DevOps World?

Dear SQL DBA

Player FM - Internet Radio Done Right

35 subscribers

הוסף לפני nine שנים

תוכן מסופק על ידי Kendra Little. כל תוכן הפודקאסטים כולל פרקים, גרפיקה ותיאורי פודקאסטים מועלים ומסופקים ישירות על ידי Kendra Little או שותף פלטפורמת הפודקאסט שלהם. אם אתה מאמין שמישהו משתמש ביצירה שלך המוגנת בזכויות יוצרים ללא רשותך, אתה יכול לעקוב אחר התהליך המתואר כאן https://he.player.fm/legal.

What Should I Do With My Money?

1
Can We Afford a Wedding, a Home and IVF? 26:12

לפני 22 ימים26:12

הפעל מאוחר יותר

רשימות

לייק

אהבתי

26:12

As a newly engaged couple, Jules and Shay have a lot to look forward to: a destination wedding, starting fertility treatments and the potential of buying a home. But their goals have a short horizon, are they able to save enough to accomplish three large milestones within a five-year period? In this episode, Jules and Shay sit down with Carolina, a Morgan Stanley Financial Advisor to discuss short- and long-term savings strategies, utilizing company benefits and how their families can help them save for a down payment . For more information about this episode and the topics covered, check out our episode page and explore how you can connect with a Morgan Stanley Financial Advisor . Important information about your relationship with your Financial Advisor and Morgan Stanley Smith Barney LLC when using a Financial Planning tool. When your Financial Advisor prepares a Financial Plan, they will be acting in an investment advisory capacity with respect to the delivery of your Financial Plan. To understand the differences between brokerage and advisory relationships, you should consult your Financial Advisor, or review our Understanding Your Brokerage and Investment Advisory Relationships brochure available at https://www.morganstanley.com/wealth-relationshipwithms/pdfs/understandingyourrelationship.pdf You have sole responsibility for making all investment decisions with respect to the implementation of a Financial Plan. You may implement the Financial Plan at Morgan Stanley Smith Barney LLC or at another firm. If you engage or have engaged Morgan Stanley, it will act as your broker, unless you ask it, in writing, to act as your investment adviser on any particular account. Morgan Stanley Smith Barney LLC (“Morgan Stanley”), its affiliates and Morgan Stanley Financial Advisors and Private Wealth Advisors do not provide tax or legal advice. Clients should consult their tax advisor for matters involving taxation and tax planning and their attorney for matters involving trust and estate planning and other legal matters. Residential mortgage loans/home equity lines of credit are offered by Morgan Stanley Private Bank, National Association, an affiliate of Morgan Stanley Smith Barney LLC. With the exception of the pledged-asset feature, a Residential mortgage loans/home equity lines of credit are offered by Morgan Stanley Private Bank, National Association, an affiliate of Morgan Stanley Smith Barney LLC. With the exception of the pledged-asset feature, an investment relationship with Morgan Stanley Smith Barney LLC does not have to be established or maintained to obtain the residential mortgage products offered by Morgan Stanley Private Bank, National Association. All residential mortgage loans/home equity lines of credit are subject to the underwriting standards and independent approval of Morgan Stanley Private Bank, National Association. Rates, terms, and programs are subject to change without notice. Residential mortgage loans/home equity lines of credit may not be available in all states; not available in Guam, Puerto Rico and the U.S. Virgin Islands. Other restrictions may apply. The information contained herein should not be construed as a commitment to lend. Morgan Stanley Private Bank, National Association is an Equal Housing Lender and Member FDIC that is primarily regulated by the Office of the Comptroller of the Currency. Nationwide Mortgage Licensing System Unique Identifier #663185. The proceeds from a residential mortgage loan (including draws and advances from a home equity line of credit) are not permitted to be used to purchase, trade, or carry eligible margin stock; repay margin debt that was used to purchase, trade, or carry margin stock; or to make payments on any amounts owed under the note, loan agreement, or loan security agreement; and cannot be deposited into a Morgan Stanley Smith Barney LLC or other brokerage account. Morgan Stanley Wealth Management is a business of Morgan Stanley Smith Barney LLC. This material has been prepared for informational purposes only. It does not provide individually tailored investment advice. It has been prepared without regard to the individual financial circumstances and objectives of persons who receive it. Morgan Stanley Smith Barney LLC (“Morgan Stanley”) recommends that investors independently evaluate particular investments and strategies, and encourages investors to seek the advice of a Morgan Stanley Financial Advisor. The appropriateness of a particular investment or strategy will depend on an investor’s individual circumstances and objectives. Important Risk Information for Securities Based Lending : Clients must be aware that: (1) Sufficient collateral must be maintained to support the loan and to take future advances; (2) Clients may have to deposit additional cash or eligible securities on short notice; (3) Some or all of the pledged securities may be sold without prior notice in order to maintain account equity at required collateral maintenance levels. Clients will not be entitled to choose the securities that will be sold. These actions may interrupt long-term investment strategy and may result in adverse tax consequences or in additional fees being assessed; (4) Morgan Stanley Bank, N.A., Morgan Stanley Private Bank, National Association or Morgan Stanley Smith Barney LLC (collectively referred to as "Morgan Stanley") reserve the right not to fund any advance request due to insufficient collateral or for any other reason except for any portion of a securities based loan that is identified as a committed facility; (5) Morgan Stanley reserves the right to increase the collateral maintenance requirements at any time without notice; and (6) Morgan Stanley reserves the right to call securities based loans at any time and for any reason. Morgan Stanley Smith Barney LLC, its affiliates and their employees are not in the business of providing tax or legal advice. These materials and any statements contained herein should not be construed as tax or legal advice. Individuals should consult their personal tax advisor or attorney for matters involving taxation and tax planning and their attorney for matters involving personal trusts and estate planning With the exception of a margin loan, the proceeds from securities based loan products may not be used to purchase, trade, or carry margin stock (or securities, with respect to Express CreditLine); repay margin debt that was used to purchase, trade or carry margin stock (or securities, with respect to Express CreditLine); and cannot be deposited into a Morgan Stanley Smith Barney LLC or other brokerage account. To be eligible for a securities based loan, a client must have a brokerage account at Morgan Stanley Smith Barney LLC that contains eligible securities, which shall serve as collateral for the securities based loan. Securities based loans are provided by Morgan Stanley Smith Barney LLC, Morgan Stanley Private Bank, National Association or Morgan Stanley Bank, N.A, as applicable. Morgan Stanley Wealth Management is a business of Morgan Stanley Smith Barney LLC. Morgan Stanley Smith Barney LLC is a registered Broker/Dealer, and not a bank. Where appropriate, Morgan Stanley Smith Barney LLC has entered into arrangements with banks and other third parties to assist in offering certain banking related products and services. Investment, insurance and annuity products offered through Morgan Stanley Smith Barney LLC are: NOT FDIC INSURED | MAY LOSE VALUE | NOT BANK GUARANTEED | NOT A BANK DEPOSIT | NOT INSURED BY ANY FEDERAL GOVERNMENT AGENCY © 2025 Morgan Stanley Smith Barney LLC. Member SIPC. CRC# 4766848 (09/2025)…

לפני 6 שנים 41:07

MP3•בית הפרקים

You're a DBA, and your development team is all-in on doing DevOps, and they want to include the database. Should your DBA team limit the permissions or options for automation? Or should you instead re-think how your two teams work together? In this episode, Kendra discusses DevOps team topologies, the changing role of DBA teams in DevOps, and the opportunities available in creating communities of practice around database development.

82 פרקים

#Tech News #Sqlserver #Sqlworkbooks #News #Web Development #Tech #Software Development #Kendra Littles #DBA #Database

Dear SQL DBA

How Do Developers and DBAs Collaborate in a DevOps World?

Dear SQL DBA

35 subscribers

published לפני 6 שנים

שתפו

MP3•בית הפרקים

82 פרקים

#Tech News #Sqlserver #Sqlworkbooks #News #Web Development #Tech #Software Development #Kendra Littles #DBA #Database

כל הפרקים

Dear SQL DBA

1
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques 1:04:36

לפני 1 year1:04:36

1:04:36

Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath) Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality estimator, Table Variables, Automatic Plan Correction, Batch Mode, index rebuilds, Hekaton, NOLOCK, page compression, partitioning, filtered indexes, columnstore, join hints, PSPO, indexed hints, indexed views, optimize for unknown, RCSI, adding more memory, restarting the damn thing, scalar UDFs, and Persisted Memory Grant Feedback.…

Dear SQL DBA

1
Power BI Performance Tuning with Eugene Meidinger 53:54

לפני 2 years53:54

53:54

Eugene Meidinger stops by to chat about Power BI Performance Tuning with Kendra. We talk about the various engines and languages used in Power BI and big-picture strategies for getting performance from the start. Eugene then talks about the community of tools and techniques that can be used to dig in and solve performance problems in Power BI. Eugene's new Pluralsight course on Perf tuning Power BI launches on February 5th, 2024. The first 50 sales will be only $20. If you don't get one of those lucky spots, use code RACOONS to get 50% off. Find more of Eugene's content at sqlgene.com.…

Dear SQL DBA

1
Automated Deployments and the Art of the Database with Database Michael J Swart 1:05:28

לפני 2 years1:05:28

1:05:28

In this episode, Michael J Swart joins the Dear SQL DBA podcast to talk about databases, automation, and how he’s come to illustrate some of the coolest blog posts ever to be written about data. Check out Michael’s art and blog posts at michaeljswart.com, and explore his posts by illustration at https://michaeljswart.com/browse-articles-by-illustration/ .…

Dear SQL DBA

1
Jer and Kendar Explore Optimized Locking 28:57

לפני 2 years28:57

28:57

SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking. Jeremiah Peschka joins the podcast to talk through the docs and nerd out on locks, blocks, and how to pronounce the acronym “LAQ”. Learn more about this feature online: Optimized locking article from Microsoft Learn Transaction locking and row versioning guide…

Dear SQL DBA

1
Advice for Technical Leaders with Alex Robson 1:00:28

לפני 2 years1:00:28

1:00:28

Ever wondered what it's like to be a VP or Director of Engineering? Kendra chats with Alex Robson about leadership in technology, what you can get out of coaching or an MBA program (should you be interested), and what makes a high performing team. We'll also chat about recommended content to hone your tech leadership skills. Alex Robson's site and blog: https://robsonconsulting.services Alex's content recommendations for folks who want to think more about technical leadership: "I believe Camille Fournier and Will Larson are wonderful writers with invaluable insights and advice. For product thinking, I recommend folks read The Lean Startup by Eric Ries, Principles of Lean Product Development Flow by Don Reinertsen, Safer Sooner Happier by Jonathan Smart, and Accelerate by Dr. Nicole Forsgren. Be sure to read books on leadership that are outside of engineering. Dan Pink’s Drive and Eliyahu Goldratt’s The Goal are two of my usual recommendations. Last but not least - read books that are about human behavior. Both economists and psychologists ask important questions that may help you unlock better ways to relate to and understand others. I love Daniel Kahneman’s Thinking Fast and Slow, and highly recommend Mistakes Were Made (but not by me) by Carol Tavins and Elliot Aronson."…

Dear SQL DBA

1
Erik Darling on Performance Tuning 52:45

לפני 2 years52:45

52:45

SQL Server performance tuning expert Erik Darling joins the podcast today to chat about how good queries can go bad, how bad queries can get better, and the question on everyone's mind: if he was a database, what database would he be? This episode contains some mildly explicit language. Erik's blog: https://erikdarlingdata.com/blog/ Erik's YouTube: https://www.youtube.com/@ErikDarlingData…

Dear SQL DBA

1
What's up with Tech Interviews in 2023? With Jeremiah Peschka. 29:06

לפני 2 years29:06

29:06

Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss.

Dear SQL DBA

1
Data Roles: DBA, DBRE, and Data Engineer 24:52

לפני 2 years24:52

24:52

There are lots of jobs for data folks. In this episode, I'm discussing three hot job titles: Database Administrator (DBA), Database Reliability Engineer (DBRE), and Data Engineer (DE) To see the venn diagrams I made for these roles, visit https://catalyzesql.com/blog/1/01/01/dear-sql-dba-data-roles-dba-dbre-de/…

Dear SQL DBA

1
When NOT to choose SQL Server to store your data 14:19

לפני 2 years14:19

14:19

I wrote a blog post inspired by Stephen Vakil 's excellent suggested interview question, but I inverted it: When should you NOT choose SQL Server to store your data? My thoughts: * When you don't actually need a database * When you're not using structured data * When you want pure analytics, or something other than a workload involving OLTP * When you need to write to multiple nodes for a single database * When your team wants a PAAS solution (lil pedantic on this, the hosted versions are slightly different) * When your team needs a cheap solution What do you think? This podcast is available in blog post form: https://littlekendra.com/2023/06/21/when-not-to-choose-sql-server/…

Dear SQL DBA

1
Down Tools Week 2020 9:52

לפני 5 years9:52

9:52

It's Down Tools Week at Redgate. I share what "Down Tools Week" is, what I'm working on this week, and why I think it's a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization, whether you are a developer, DBA, or have another role.…

Dear SQL DBA

1
3 Things That Shouldn't Be Normal in Database Development 28:12

לפני 5 years28:12

28:12

Many people use entrenched processes for database development that have been in place so long that it's hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development-- but which are incredibly common. This episode is inspired by the book, "The Unicorn Project", by Gene Kim.…

Dear SQL DBA

1
Everything I Never Wanted to Know about Collation 13:53

לפני 5 years13:53

13:53

I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more. One small localization correction: the default collation on a SQL Server install will be "the oldest available version that's associated with each specific locale." So if your Windows installation has a different localization than mine (which are generally English USA), then you'll see a different default collation -- but it still won't be the recommended collation for *new* development.…

Dear SQL DBA

1
The Manager's Guide to Git Training for DBAs 19:02

לפני 5 years19:02

19:02

Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful. The cheat sheet I mention in the episode is at https://littlekendra.com/2019/11/27/my-git-cli-cheat-sheet/…

Dear SQL DBA

לפני 8 years11:32

11:32

SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs, and the process of updating SQL Server.

ברוכים הבאים אל Player FM!

Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.