Podcast appearances and mentions of brent ozar

I heard Brent Ozar recently talked a bit about the SQL Server platform and its future. He also mentioned that Fabric has distracted the data platform team and it isn't a great product. I tend to agree, and I see too many bugs, holes, and problems. However at the end of this short snippet, he talks about SQL Server with an interesting comment. Is SQL Server feature complete? Read the rest of Is SQL Server Feature Complete?

Well, not really the end. I doubt anyone running SQL Server 2019 is going to stop (or upgrade) just because mainstream support ended. Actually, I wonder how many of you know that SQL Server 2019 passed out of mainstream support on Feb 28, 2025. I do think the 6 or 7 of you running Big Data Clusters likely knew this was the end of any support. I saw a report in the Register on this, which includes a survey of which versions are still running. This is from an IT asset firm and matches Brent Ozar's Population report. 44% of you are running SQL Server 2019, which is the largest percentage. Since there's an additional 32% of you running versions older than 2019, I'm sure that upgrading isn't a priority. Read the rest of The End of SQL Server 2019

Most of us will have more than one job in our career. In fact many of us will likely find a new job in the next five years. I hope I'm not in that group, but I recognize that it's a possibility. We never know when our situation will change, or our employer's situation will change. That is one reason I recommend you keep your resume up to date and continue to work on improving your skills. I saw an office hours short recently from Brent Ozar, in which someone had asked him if they should apply for a job even though they didn't meet all of the requirements or know all of the desired technologies. Brent recommended the person apply, and his reasoning was that often a DBA (or other data pro) often gets asked to do a variety of tasks in an organization. The DBA job often crosses lots of boundaries and may end up working on a Active Directory issues, reporting, ETL, and more. When A DBA leaves a job, the organization looks for a replacement that can handle that same wide variety of things. Read the rest of Fifty Percent

Nikolay and Michael discuss a common question — why Postgres isn't using an index, and what you can do about it! Here are some links to things they mentioned:Why isn't Postgres using my index? (blog post by Michael) https://www.pgmustard.com/blog/why-isnt-postgres-using-my-index Why isn't Postgres using my functional index? (Stack Exchange question from Brent Ozar) https://dba.stackexchange.com/questions/336019/why-isnt-postgres-using-my-functional-index  enable_seqscan (and similar parameters) https://www.postgresql.org/docs/current/runtime-config-query.html Crunchy Bridge changed random_page_cost to 1.1 https://docs.crunchybridge.com/changelog#postgres_random_page_cost_1_1 Make indexes invisible (trick from Haki Benita) https://hakibenita.com/sql-tricks-application-dba#make-indexes-invisible ANALYZE https://www.postgresql.org/docs/current/sql-analyze.htmlStatistics used by the planner https://www.postgresql.org/docs/current/planner-stats.html Our episode on query hints https://postgres.fm/episodes/query-hints transaction_timeout (commit for Postgres 17) https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=51efe38cb92f4b15b68811bcce9ab878fbc71ea5 What's new in the Postgres 16 query planner / optimizer (blog post by David Rowley) https://www.citusdata.com/blog/2024/02/08/whats-new-in-postgres-16-query-planner-optimizer/ ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork 

In the Phoenix Project (worth a read), there is a character called Brent, who is to go-to person for everything in IT. I don't know if this character was modeled after Brent Ozar, but I always picture him when I re-read the book, and I suspect he was that person in previous positions. I've been that person as well, and it's both exciting, fulfilling, and very stressful. At Redgate, that person has been Robert C, who is my go-to person for many questions. In the DBA world, I think of Jeff Moden. He's been a prolific and incredible author over the years on many things SQL-related and is a huge proponent of others learning to write better code and better utilize the database platform more efficiently. I suspect in his company, he is the go-to person for most database-related questions and problems. I also suspect he solves most of them very well and has the influence (or power) to effect change. Read the rest of Do You Have a Jeff?

Last month Brent Ozar posted that September was community tools month. He had a number of posts that highlighted tools and a number of other people (Francesco, Erik, VladDBA ) did as well. I didn't do any blogging because, well, it was a busy month for me. I was gone from home for 21 days, so a bit harried in life. As a part of this effort, I saw Ken Fisher write about being a Script Magpie, which is an interesting analogy. A magpie is a bird that collects various shiny objects. Ken collects scripts in the same way. Things that catch his eye are added to his repo of scripts that he keeps handy. Read the rest of Assembling Your Own Toolbox

Knowing your SQL Server is patched when an issue occurs is worth the effort of keeping it patched. While I don't suggest a zero-day install for most folks, setting up a regular cadence to check is a reasonable ask if you have to manage a system. In this episode of the SQL Data Partners Podcast, we discuss the need for patching and how you might go about it. Special shoutout to Episode 112 with the late Robert Davis on the same subject. We would also like to thank the fine folks at dbatools.io for some nifty PowerShell to help us install patches and Brent Ozar for keeping up sqlserverupdates.com. If you have some additional ideas on how to best meet your patching needs, let us know via social media! The show notes and video for today's episode can be found at https://sqldatapartners.com/2022/08/24/episode-252-the-cumulative-update-dilemma. Have fun on the SQL Trail!

There are plenty of people changing jobs in this economy. In fact, I keep hearing that companies are struggling to find people, though many of them are holding off making offers and looking for qualified people. Unlike the early 90s when anyone with an MCSE got hired without too many questions, companies are being picky today about who they hire. I saw recently that Brent Ozar wrote his monthly post asking about who is hiring in the database community. There are a number of comments already with job listings, and I'm hoping there are more that appear when this publishes. If you know of a job, post a comment. The wider you spread the news, the better chance you'll get a person that best fits the position. Read the rest of Finding a New Job

A saw a tweet from Brent Ozar about USB ports on slot machines to charge your devices. There are also wireless charging pads. Convenient, but also potential security problems, especially for IT workers that hold privileged access to code or data. Please, don't use public USB ports for charging a device. You never know if there is any data access taking place. Yes, I know that most phones ask you to approve things, but have you ever hit the wrong button on your UI? Know how to turn it off? How quickly would data move or malware install? Just don't plug in. Read the rest of A Real World Security Reminder

I caught this link in a Brent Ozar newsletter. It's a post from Alice Goldfuss noting she's on the market for hiring. Not that she's looking for a job, but rather, saying she's willing to talk to you if you want to hire her. Quite a bold announcement, but she's quite a talent that many organizations might want. I don't know that many of us could post something and have companies come find you, but I did like the list of items she lays out for a hiring conversation. These are the types of questions that you might keep handy, even as notes, for your next interview. I've often had a series of questions like this that I ask when I go into an interview for a job. I've learned that I need to be curious and careful if I want a successful position for both me and the company. Both of us are trying to put our best foot forward, sometimes stretching the positives and minimizing the downsides. That means that both sides can be surprised later by how the relationship actually proceeds. Read the rest of An Active Job Search

I have seen a few people call for raising the RAM limit in the Standard Edition of SQL Server. In 2016, Aaron Bertrand voiced this, and for 2019, Glenn Berry asked that the limit be raised to 256GB. In the last newsletter of the year, Brent Ozar asked Santa for a 256GB limit. I wonder how many of you would really take advantage of that. In the Azure SQL Database pricing table, to get beyond 128GB of RAM, you need to go to 32 cores. For Azure VMs, you need to purchase even more cores.  AWS EC2 VMs require 32 cores to get to 256GB. Read the rest of The Need for 256GB

During the PASS Data Community Summit last week, Brent Ozar delivered the day 3 keynote, and it was great. I really enjoyed the format and topic, and I look forward to how someone else might be creative next year with the time. I'd certainly love to do the keynote, though not sure I'd be eligible. I'm hoping a few others get interested and compete for the slot in 2022. One of the things Brent mentioned was about looking for skills to focus on, primarily for "builder," or those that develop new applications. He used a quote from Wayne Gretzky: "I skate to where the puck is going to be, not where it has been." The reference is to pick things that will be relevant in the future (where the puck will be), not where things are today. Read the rest of Where is the Puck Going?

Every so often Brent Ozar releases a report of his Constant Care customers, showing the versions in use. While I don't know this client group is representative of the overall SQL Server customer base, I do think it's close enough to draw some rough conclusions. The top version adoption graph that the summer 2021 report shows has 33-34% of the installed based on 2016, about 34% newer (and under support) versions, leaving the last third running older versions. However, the graph I found interesting is the lower one, which shows the distribution over time. Read the rest of The Slow Upgrade of SQL Server Versions

In my career, I've had to manage many production database instances. In fact, there was a time when two of us were patching hundreds of instances (600?) when MS released patches. That wasn't too often back then, unlike the every other month(ish) schedule that we have with 2017/2019 and the Cumulative Updates. My process was often to test patches on QA/Test servers and then start to roll out the patches to production. We didn't quite follow what Brent Ozar recommends, in that we often patched development servers later. We didn't control those, and unless production was patched, we couldn't get developers to patch their systems. Read the rest of Patching Challenges

In this episode of Kasper On BI we are talking about SQL Server, the current state, history, and the future. Cloud vs on prem SQL and how to administration is...

How do you document your SQL Server environments? I can remember walking through Brent Ozar’s takeover script back in the day and how cumbersome it was to put all that information together. We have a few more options available to us now. In this episode, we discuss a listener question along with some options for doing server inventories. SQL Trail is coming on March 18th. Will we see you there? The show notes (and video) for today's episode can be found at https://sqldatapartners.com/2021/02/24/episode-219-sql-server-inventory. Have fun on the SQL Trail!

Last Week in .NET - February 6th, 2021No releases of note this week; but several updates in the .NET area that are useful, especially around Windows UI. Let's get to it.Microsoft News

Listen in on well known SQL expert and entrepreneur, Brent Ozar, talking about where to store data. Hint: It is not always SQL server… Guest: Brent…Continue readingWhere to Store Data with Brent Ozar

Databases are important during a crisis - how are yours? Richard talks to Brent Ozar about how the pandemic has effected workloads for databases and DBAs. While some businesses have wound-down during the crisis, many are busier than ever. How do you scale on short notice? What if bigger hardware isn't readily available? Even large cloud database instances are somewhat limited today, so clever techniques have to be found to keep things running. Brent also digs into the maintenance side of things - it's a great time to do the preventative work you always meant to do!

  This week the guys get some free Database Consulting from Brent Ozar. Brent makes Microsoft SQL Server go faster. He got his start in the late 1990s – first as a developer and systems administrator, then as a full time DBA. He's managed performance and reliability for truly tough servers: tens of terabytes, thousands of databases, and thousands of queries per second.   Links https://twitter.com/BrentO https://www.brentozar.com/ https://www.linkedin.com/in/brentozar/ https://www.twitch.tv/brentozar https://github.com/BrentOzarULTD   Resources SQLPerformance.com SQL Server Simple Talk SQL Server Central Stairways SQLBits.com The Secrets of Consulting   "Tempting Time" by Animals As Leaders used with permissions - All Rights Reserved   × Subscribe now! Never miss a post, subscribe to The 6 Figure Developer Podcast! Are you interested in being a guest on The 6 Figure Developer Podcast? Click here to check availability!  

Well known SQL expert and entrepreneur, Brent Ozar, talks passionately on building your career plan. Listen in as Brent shares some great questions to ask yourself…Continue readingBuilding your Career with Brent Ozar

What are SQL people concerned about at the end of 2019? While in Las Vegas at SQL Intersection, Richard hosts the semi-annual question and answer session for SQL at the end of the conference. Panelists include Bob Ward, Kim Tripp, Paul Randal, Brent Ozar, Glenn Berry, Kevin Farlee, Pam Lahoud, Pedro Lopes, Ben Miller and Tim Radney. Questions around SQL Server 2019, SQL in the cloud, new clustering services, challenges around working with developers and more!

We had a technical issue with this month’s recording, so instead we’re going back to one of our favorite shows – Big Mistakes with Brent Ozar. Enjoy, and we’ll be back with new stuff in a few weeks. Among other mistakes, we talk about: How did a company end up with a table named “C” Brent’s first database disaster ever Why Guy spent two weeks in Microsoft Belfast Fire in the data center How does a manager need to respond during a crisis How should you react when you mess up

What questions do you have for the SQL community? While in Orlando at SQL Intersection, Richard hosts the semi-annual question and answer session for SQL at the end of the conference. Panelists include Bob Ward, Kim Tripp, Paul Randal, Brent Ozar, Glenn Berry, Kevin Farlee, Pam Lahoud, Pedro Lopes, Ben Miller and Tim Radney. Questions around SQL Server 2019, reporting and integration services, running SQL in AWS and of course, the obligatory partitioning question.

In this episode of Data Driven, Frank and Andy catch up with Brent Ozar and have a laugh or two at Silverlight’s expense, NoLock, and playing country music backwards. Links (http://thedatadrivenbook.com) Sponsor: Audible.com (http://thedatadrivenbook.com) – Get a free audio book when you sign up for a free trial! Notable Quotes Season 3 opened with John Lee Dumas aka JLD (http://datadriven.tv/inspiration-john-lee-dumas-tech-intensity-data-soup/) ([01:30]) Data Soup Summit (http://www.datasoupsummit.com) ([02:00]) Introducting Brent Ozar (https://brentozar.com) ([05:00]) “Get out there!” – Brent Ozar ([08:30]) Data work pays better. ([13:45]) Brent started in hotel management ([15:00]) Data is the new oil… but we should avoid spills. ([16:15]) “The job is getting harder, not easier.” ([18:30]) The “Aha” moment and ER analogy. ([21:30]) Brent’s quote voice… ([22:00]) Brent’s “Bad News Doctor” voice ([22:45]) Andy throws NoLock under the bus. Brent helps. ([23:12]) On shrinking databases… ([24:30]) NoSQL ([26:30]) Name-drop: Buck Woody (https://twitter.com/BuckWoodyMSFT) ([28:30]) Name-drop: Scott Hanselman (https://twitter.com/shanselman) ([29:00]) Ballerina Princess (https://www.facebook.com/andy.leonard/posts/10155299392198669) ([32:20]) Brent likes to travel. ([34:45]) “No one comes to me for a good time…” ([36:20]) The data is the choke-point. Again. ([38:30]) On Google Glass (https://www.google.com/glass/start/) ([39:45]) On Past Brent… ([41:00]) Name-drop: Brian Kelley (https://twitter.com/kbriankelley) ([41:30]) “We’re published. It’s a license to spell.” ([42:10]) Book Reference: Down and Out in the Magic Kingdom (https://en.wikipedia.org/wiki/Down_and_Out_in_the_Magic_Kingdom) ([43:45]) Social Radar (https://www.crunchbase.com/organization/socialradar) ([44:45]) Regarding iTunes… ([45:00]) Brent is into restaurants. ([46:45]) Andy’s Brent Story… ([48:15]) Brent is here to help. ([50:00]) On paying it forward… ([51:30]) “This looks like an engineer built it” is not a compliment. ([52:30]) Learn more about Brent at BrentOzar.com (https://brentozar.com) ([53:00]) William B. Irvine (https://dailystoic.com/william_irvine/) ([54:30]) @donttrythis (https://twitter.com/donttrythis) )([55:30]) Titan (https://www.audible.com/pd/Titan-Audiobook/B00ECGLKLG) by Ron Chernow ([58:40]) Regarding Midgely… (https://en.wikipedia.org/wiki/Thomas_Midgley_Jr.) ([1:00:00]) Brent’s Epic Life Quest (https://ozar.me/quest/) ([1:02:00]) WordPress Plugins I Use to Sell Training Classes (https://ozar.me/2017/04/wordpress-plugins-i-use-to-sell-training-classes/) ([1:02:30]) Frank’s New Year starts 1 Nov. ([1:03:15]) Sometimes life resembles a country music song… ([1:04:00]) Frank wrote a book about Silverlight (https://smile.amazon.com/Microsoft-Silverlight-Business-Application-Development-ebook/dp/B0058CR2QU) . ([1:05:15]) One day there will be a country song about a self-driving pickup leaving… ([1:06:10])   Transcript (Experimental) The following transcript was automatically generated with AI. Hello and Welcome to data driven the podcast where we explore the emerging field of data science. We bring the best minds in data software engineering machine learning and artificial intelligence now hear your hosts Frank Lavigna and Andy Leonard. Hello and welcome back to data driven the podcasts are we explore the emerging field. Some data science machine learning and artificial intelligence. If you’d like to think of data as the new oil and you can consider us Car Talk because we focus on where the rubber meets Virtual Road and

In this episode, Frank and Andy talk to two guests, Ronald Schmelzer and Kathleen Walch, co-founders of  AI Today podcast (https://www.cognilytica.com/category/podcasts/) . Links (http://thedatadrivenbook.com) Sponsor: Audible.com (http://thedatadrivenbook.com) – Get a free audio book when you sign up for a free trial! Notable Quotes Cognilytica (https://www.cognilytica.com/) is amazing!([04:00]) All chatbots are dumb – for now. ([09:00]) Machine Learning vs. Machine Reasoning ([11:30]) The DIKUW Pyramid (https://en.wikipedia.org/wiki/DIKW_pyramid) ([11:55]) More about Knowledge Graph (https://en.wikipedia.org/wiki/Knowledge_Graph) … ([14:00]) More about Common Sense (https://en.wikipedia.org/wiki/Commonsense_knowledge_(artificial_intelligence)) … ([15:00]) On generalization ([16:05]) ML and the Elephant in the Room (https://www.quantamagazine.org/machine-learning-confronts-the-elephant-in-the-room-20180920/) ([16:22]) Movie reference: Guardians of the Galaxy (https://www.imdb.com/title/tt2015381/) ([17:00]) How did the AI Today (https://www.cognilytica.com/category/podcasts/) podcast get started? ([18:00]) AI Today podcast with Dragos Margineantu, AI Chief Technologist at Boeing (https://www.cognilytica.com/2018/05/23/ai-today-podcast-38-interview-with-dragos-margineantu-boeing/) ([19:44]) Is AI retro? ([22:50]) Movie Reference: Short Circuit (https://www.imdb.com/title/tt0091949/) ([23:30]) Did you find data or did data find you? (0[25:00]) Tech Breakfast DC (https://www.meetup.com/TechBreakfast/events/226841343/) ([28:30]) AOL (https://www.aol.com/) plug ([31:25]) What’s your favorite part of your current gig? ([32:00]) More about pseudo-AI (https://www.cognilytica.com/2018/07/17/does-fake-it-till-you-make-it-work-in-ai/) … ([33:45]) Shout-out to Brent Ozar (https://brentozar.com) (just not by name) ([38:00]) When I’m not working, I enjoy ___? ([39:45]) I think the coolest thing in technology is ___? ([41:12]) Bubble programming language (https://bubble.is/) ([42:15]) I look forward to the day when I can use technology to ___. ([45:00]) “Don’t overshare…” ([46:30]) The loneliest people (https://www.ajc.com/news/national/study-says-most-americans-feel-lonely-young-adults-are-the-loneliest/pIRVGfKilaPLGS3CtwG4WM/) ([47:00]) Warning: Do not watch movies while driving. ([48:30]) Also, eating tacos while driving is difficult. ([49:00]) “Lefties are alright…” – Kathleen ([49:30]) Ron may be a pool shark. ([51:30]) Forbes (https://www.forbes.com/sites/cognitiveworld/people/kathleenwalch/#44cf2cba6ee5) . ([53:00]) Ron’s book recommendation: Hackers: Heroes of the Computer Revolution (https://smile.amazon.com/dp/B003PDMKIY) ([56:00]) Kathleen’s book recommendation: My Not-So-Perfect Life (https://smile.amazon.com/dp/B01GYPY88Y) ([57:00]) Kathleen’s other book recommendation: The Glass Castle (https://smile.amazon.com/Glass-Castle-Memoir-Jeannette-Walls-ebook/dp/B000OVLKMM/) ([57:40]) You can Sandy River (https://www.sandyriveroutdooradventures.com/) in Farmville ([1:00:00])

Once more into the questions and answers! A twice-yearly event, SQLIntersection always closes with a great question and answer session with all of the SQLIntersection attendees asking questions of an amazing line up of SQL Server experts including Kim Tripp, Paul Randal, Bob Ward, Brent Ozar, Erin Stellato, David Pless, Aaron Bertrand and many more! Want a sense of what the SQL Server community is worried about and otherwise focused on? Have a listen!

What's new in SQL Server 2019? Richard chats with Brent Ozar about his take on the latest version of SQL Server. Is there any more to do? Apparently yes! Some features are a bit more questionable, like Java support in SQL Server. But others make a ton of sense, including more analytics, more insights and better support for containers. It all depends on what you want to do with SQL Server. Brent talks about how the culture of DBAs is changing and how that is reflected in SQL Server itself. There's more data to store than ever!

I haven't thought about this in some time, but Brent Ozar raises an interesting question: should index changes require change control? I've worked in an organization that didn't consider an index change to be an item that was presented as an official change. They were seen somewhat like adding new users or changing a firewall rule. These were ticket requests that could be triaged and made by an individual group without notifying the rest of IT. I've also worked in organisations where an index change was viewed as a deployment and subject to change control procedures. Not that the network or security people cared about the details of the index, though the help desk might. These just wanted to be aware as any deployment change could affect their departments. Read the rest of Are Indexes Actually Changes to the System?

The fortythird episode is up! We're talking Intelligent Cloud Copenhagen, ConfigMgr updates, Intune updates, Microsoft aquiring GitHub and using Power BI with Brent Ozar's first responder kit.We'll be doing webinars in the not-so-distant future, and we'd love for you to tell us what you want the webcast to be about!As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet Alexander (@arcticdba) or Simon (@bindertech)! See acast.com/privacy for privacy and opt-out information.

In this episode Frank and Andy celebrate a huge (yuge?) milestone, 100 uploads since launching in late May 2017. Links Sponsor: Audible.com (http://thedatadrivenbook.com) – Get a free audio book when you sign up for a free trial! Sponsor: Enterprise Data & Analytics (https://entdna.com) Notable Quotes It’s show #100! ([01:30]) On pop filters (https://en.wikipedia.org/wiki/Pop_filter) ([03:30]) On Azure.gov (https://docs.microsoft.com/en-us/azure/azure-government/documentation-government-welcome) ([04:30]) Spiderman reference ([05:00]) Azure CLI (https://docs.microsoft.com/en-us/cli/azure/install-azure-cli?view=azure-cli-latest) ([07:00]) Regarding the Microsoft Dublin Datacenter Case (https://redmondmag.com/articles/2017/10/16/microsoft-dublin-datacenter-case.aspx) ([09:30]) Data Law (Brad Smith, Microsoft) (https://blogs.microsoft.com/datalaw/category/brad-smith/?filter_post_type=post) ([12:00]) Brent Ozar’s post on GDPR (https://www.brentozar.com/archive/2017/12/gdpr-stopped-selling-stuff-europe/) ([23:00]) ClearDB deleted Frank’s data (http://datadriven.tv/special-5pm-know-data-is/) ([25:00]) Andy is not selling (https://biml.academy/stopping-sales-to-eu-starting-31-dec-2017/) in the EU ([26:40]) Soup nazi (https://www.youtube.com/watch?v=M2lfZg-apSA) reference ([30:20]) Microsoft’s German Data Centers (http://fortune.com/2016/09/21/microsoft-germany-data-centers/) ([32:50]) Frank’s “aha” moment regarding Hadoop ([34:50]) Microsoft Azure HDInsight Big Data Analyst (https://www.edx.org/xseries/microsoft-azure-hdinsight-big-data-analyst) at edX ([35:40]) The Last SSIS Book You Read (https://andyleonard.blog/2017/02/the-last-ssis-book-you-read/) ([37:15]) Frank has a lot of certifications (https://www.linkedin.com/in/frank-lavigne/) ([43:30]) On Dashboards (https://andyleonard.blog/2011/12/dashboards/) ([45:00]) Regarding IIoT (http://internetofthingsagenda.techtarget.com/definition/Industrial-Internet-of-Things-IIoT) … ([47:45]) Databricks ([50:00]) Regardign the tuple (https://en.wikipedia.org/wiki/Tuple) ([51:00]) Data Science training is available at Wintellect Now (https://www.wintellectnow.com/) ([1:02:45]) Khan Academy (https://www.khanacademy.org/) ([1:04:15]) Biml training is available at Biml Academy (https://biml.academy) ([1:05:30]) Frank had a rough 2016, but he came back strong in 2017! ([1:06:30]) Frank is on a mission from God (https://www.youtube.com/watch?v=-4YrCFz0Kfc) ([1:08:15]) Microsoft was founded 4 Apr 1975 (Frank was right and I was wrong) ([1:09:10])

Brent Ozar talks about himself, his passion, hobbies and carreer.Brent Ozar is one of the most known person in the SQL Server world. He is a Microsoft Certified Master (MCM) and Data Platform MVP. His passion and energy are shared among all people he works with. He is known as a very energetic speaker. He loves sharing his knowledge. He loves cars. He loves dogs.This talk was recorded during the SQLDay 2017 in Wrocław, on Wednesday 17th May, 8 am.

Brent Ozar talks about himself, his passion, hobbies and carreer.Brent Ozar is one of the most known person in the SQL Server world. He is a Microsoft Certified Master (MCM) and Data Platform MVP. His passion and energy are shared among all people he works with. He is known as a very energetic speaker. He loves sharing his knowledge. He loves cars. He loves dogs.This talk was recorded during the SQLDay 2017 in Wrocław, on Wednesday 17th May, 8 am.

More questions answered at SQLIntersection! Richard hosts a panel discussion of Kim Tripp, Paul Randal, Bob Ward, Brent Ozar and many other SQL speakers from SQLIntersection. The questions are far ranging this time around, talking about business intelligence, data science, reliability approaches and a record-setting answer on data partitioning from You-Know-Who!

Have you ever created something and wanted to share it with others with the hope they will contribute and make it better? Sites like the new defunct codeplex and GitHub are full of functionality people want to share and work with others on; however, many projects remain dormant.  What are the characteristics that create an environment where people want to contribute to your project?  Steve and I discuss a few ideas and we interview two very successful community project leaders in Brent Ozar and Chrissy LeMarie about how they got started and what it takes to put together a good community project. The shownotes for today’s episode is found at http://sqldatapartners.com/2017/05/10/community-tools/ and have fun on the SQL trail.

Time for another SQL Q and A! Richard moderates an hour long discussion at SQLintersection in Orlando with panelists Paul Randal, Kim Tripp and Brent Ozar as they tackle the questions and concerns of the attendees. A number of other SQL luminaries (including Microsoft SQL team members) chime in about topics ranging from data types to data recovery, noSQL vs RDBMS, query performance strategies, and more! Why should you upgrade to SQL 2016? How long does CheckDB take to run on SQL 2005? What is the longest answer to a question that Kim Tripp can give? All this and more in this show full of great answers and debates!

Continuing the show from two weeks ago, we have another show with Brent Ozar we recorded when he was in Israel a few weeks ago. This time, we talk about what a DBA needs to know in order to get a job in this day and age. What should you know if you're a junior DBA? what should you know if you're a senior DBA? what are some interesting interview questions you might face? We also spend a few minutes talking about SQL Server on Linux, whether it makes sense, what does it really mean, and what should any SQL Server professional know today.  Items mentioned in the show: Brent Ozar - Secret Meeting Minutes for the SQL Server on Linux Decision* About Brent Brent Ozar (Blog | Twitter) is the founder and owner of Brent Ozar Unlimited. Brent loves pushing SQL Server past the speed limit and showing other people how to drive it faster. He enjoys translating between programmers, sysadmins, SAN admins, and project managers. They find the root of the problem quickly, together, and get everyone working towards the same solutions. For the best conversation in your life, ask him about: Microsoft SQL Server performance tuning Making kCura Relativity faster VMware ESX/vSphere virtualization Storage and SANs Server hardware How Tim Gunn can make it work  

 Today on the SQL Trail I talk with Richie Rump, the podcaster, blogger, and now new hire at Brent Ozar. He and I discuss measuring query performance, using SET STATISTICS, and the story behind his Statistics Parser application.  He also talks about navigating the space between developer and DBA. The show notes for today's episode are at http://sqldatapartners.com/2016/04/02/statisticsparser/

What is coming in SQL Server 2016? Richard chats with Brent Ozar about his thoughts on the upcoming version of SQL Server. The conversation digs into how the cloud is impacting SQL Server - features like Query Store were available first in the cloud are now showing up in this new on-premise edition! Speaking of Query Store, who wouldn't want a record of query plans so you can find out exactly why a query in production took a long time? Brent discusses other features including the stretch table to azure, always encrypted, row level security... the list goes on! The question is, when do we get this great version?

We each have our way of going about things–this is what makes us unique.  When it comes to getting data out of the database, many times we might think that SQL Server would go about getting data the same way we would.  If you think about scanning a Microsoft Excel document, how would you find the record you are looking for?  How does that differ from SQL Server? My guest for this episode is Brent Ozar and we chat about internals and how SQL Server processes your request and what you need to consider as SQL Server returns your result. Our show notes for today's episode are available at http://sqldatapartners.com/2016/02/03/sqlserverthinks/

Time for another SQL Q and A! Richard moderates discussion between Kim Tripp, Paul Randal and Brent Ozar with the audience of SQLIntersection in Las Vegas, Oct 2015. The questions come fast, the answers almost as fast (but certainly longer) as the discussion ranges over a variety of disaster recovery approaches, federation, upgrading strategies and recovering from a lost quorum file (don't judge). Twice a year we capture an hour long conversation about concerns around SQL Server, and this one is no exception - have a listen!

Richie asks Brent what's a MCM (Microsoft Certified Master not Man Crush Monday) and what was his journey to becoming one. Cecil and Brent discuss the relevance of certifications today. Brent describes what it's like being a popular speaker and how it adds anxiety to every presentation. Brent tells he became a great speaker and describes his pre-speech rituals. Finally, Brent tells how he got married in Vegas in a red convertible Mustang. Links Brent Ozar Unlimited eater.com Bio Brent Ozar loves to make SQL Server faster and more reliable.  He created sp_Blitz® and sp_AskBrent®, and he loves sharing knowledge at BrentOzar.com. He holds ...

Brent answers the age old question "Who is Brent Ozar?". Cecil asks Brent how he went from developer to DBA to entrepreneur. Brent talks about what it's like to be your own boss and Richie shares why he's not an independent consultant. Cecil asks Brent what kind of skills Brent needed to grow in order to build his business. Brent shares what it was like hiring his first employee. Brent shares what's next for Brent Ozar Unlimited. Links Brent Ozar Unlimited Bio Brent Ozar loves to make SQL Server faster and more reliable.  He created sp_Blitz® and sp_AskBrent®, and he loves sharing knowledge ...

What burning questions do you have about SQL Server? Richard moderates a panel discussion with Paul Randal, Kim Tripp and Brent Ozar and a host of other folks at the SQL Intersection conference in Scottsdale Arizona. Taking questions from the audience, which are sometimes answered by other audience members (who happened to be speakers and/or Microsoft employees), the conversation ranges over SQL 2016, indexing, high availability, federation, data types, query governors and more!

While at the SQLIntersection conference in Las Vegas, Richard hosted a panel discussion of amazing SQL Server rockstars including Paul Randal, Kim Tripp and Brent Ozar to answer questions from the audience about SQL Server. Also listen in for comments and responses from some of the SQL Server team and a number of other great SQL personalities. Great discussions on replication, Always On, indexing, statistics, clustering, features in SQL 2014 and more!

Richard chats with Brent Ozar about the amazing new hardware coming out for SQL Server. Yeah, it's time to geek out on hardware. Brent discusses some of the amazing small form factor machines coming from Dell and Hewlett-Packard, including the Dell PowerEdge 13G R730xd. What's new there? 24 RAM slots permits up to 1.5TB of RAM! And that's not all, Brent talks about the power of having three stage storage - room of three PCIe based SSD storage, 18 1.8" SATA SSD slots and 8 3.5" hard drive bays. Not only is that a lot of storage, it also provides the flexibility to let SQL Server structure your data into ultra-fast storage, super-fast storage and plain old fast storage. While the cloud is only offering scale out solutions, the latest hardware shows that you can still scale up!

It's the Questions and Answers from SQL Intersection in Orlando! Richard moderates a panel of the usual suspects: Kim Tripp, Paul Randal, Brent Ozar and occasional contributions from some of the SQL Team, Kendra Little, Jeremiah Pesha and more! Lots of discussion around virtualization, different recovery and fail over strategies, the infamous heap-vs-clustering debate, using SSDs with SQL Server... the list goes on. It's a long show, but a good one!

While at SQLIntersection in Las Vegas, Richard moderates a panel of Kim Tripp, Paul Randal, Brent Ozar and Jonathan Kehayias. The panel takes questions from the audience about SQL Server and hilarity ensues.

Richard chats with Brent Ozar about his experiences deploying SQL Server 2012. The conversation digs into the challenges of running SQL 2012 on Windows 2008R2 - and why you'd want to upgrade to SQL 2012 in the first place. For Brent's projects, it came down to utilizing Always On technology, which depends on advanced clustering features that 2008R2 struggles with - so SQL 2012 is best on Server 2012! From there, Brent talks about the impact of the cloud on on-premise servers, the need for better instrumentation and understanding of your data when talking to business. It's a fun time to be a DBA!

Richard talks to Brent Ozar about the upcoming release of SQL Server 2012. While there's certainly lots to talk about around SQL Server 2012, Brent focuses on some of the odder features, like the ability to attach SQL Server to a database accessed over a NAS. Doesn't seem like the best idea, but Brent paints a few scenarios. The conversation also brushes over the NoSQL movement and how SQL Server still plays a role - Brent brings up the SQL Server Connector for Hadoop. Brent also talks about the SQL Server Certified Masters program, how it has evolved from a three week onsite class at Microsoft into a study-at-home, huge exam and six hour lab solution that has made it easier for more people to get certified.

Stack Exchange Podcast - Episode #28 w/ Brent Ozar by The Stack Overflow Podcast

Stack Exchange Podcast - Episode #28 w/ Brent Ozar by The Stack Overflow Podcast

While at SQLConnections, Richard sat down with Brent Ozar for a rolling discussion about the things Brent is working about these days - how SQLAzure is stacking up, and how many performance problems that can be solved by 10Gb iSCSI and SSD drives. The conversation also dives into disaster recovery strategies, thoughts around data loss vs. downtime, and more.

Richard and Greg talk to Brent Ozar about his experiences doing the Certified Masters in SQL Server 2008 program at Microsoft - a three week intensive course that stretches your knowledge in every aspect of SQL Server. The conversation also ranges into SQL Server 2008 R2 and the latest features of SQL Azure. Check out Brent's blog posts at http://www.brentozar.com/sql-mcm/.

Richard and Greg talk to Brent Ozar from Quest Software about running SQL in the cloud. Part of the conversation focuses on SQL Azure, but Amazon's EC2 running SQL on a virtual machine is also a version of the same concept. The larger topic is really around DBAs providing services to their organizations - because that's what the cloud is offering!