ºÝºÝߣshows by User: BrentOzar / http://www.slideshare.net/images/logo.gif ºÝºÝߣshows by User: BrentOzar / Mon, 08 Feb 2021 12:30:31 GMT ºÝºÝߣShare feed for ºÝºÝߣshows by User: BrentOzar Fundamentals of TempDB /BrentOzar/fundamentals-of-tempdb fundamentalsoftempdb-210208123031
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files. You’re wondering what exactly goes on behind the scenes.]]>
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files. You’re wondering what exactly goes on behind the scenes.]]> Mon, 08 Feb 2021 12:30:31 GMT /BrentOzar/fundamentals-of-tempdb BrentOzar@slideshare.net(BrentOzar) Fundamentals of TempDB BrentOzar You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files. You’re wondering what exactly goes on behind the scenes. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/fundamentalsoftempdb-210208123031-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files. You’re wondering what exactly goes on behind the scenes.
Fundamentals of TempDB from Brent Ozar
]]> 273 0 https://cdn.slidesharecdn.com/ss_thumbnails/fundamentalsoftempdb-210208123031-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Fundamentals of Columnstore - Introductions /BrentOzar/fundamentals-of-columnstore-introductions-242318189 fundamentalsofcolumnstoreintroductions-210205132704
Brent Ozar's class on Microsoft SQL Server columnstore indexes. Learn more: https://brentozar.com/go/columnfund]]>
Brent Ozar's class on Microsoft SQL Server columnstore indexes. Learn more: https://brentozar.com/go/columnfund]]> Fri, 05 Feb 2021 13:27:03 GMT /BrentOzar/fundamentals-of-columnstore-introductions-242318189 BrentOzar@slideshare.net(BrentOzar) Fundamentals of Columnstore - Introductions BrentOzar Brent Ozar's class on Microsoft SQL Server columnstore indexes. Learn more: https://brentozar.com/go/columnfund <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/fundamentalsofcolumnstoreintroductions-210205132704-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Brent Ozar&#39;s class on Microsoft SQL Server columnstore indexes. Learn more: https://brentozar.com/go/columnfund
Fundamentals of Columnstore - Introductions from Brent Ozar
]]> 140 0 https://cdn.slidesharecdn.com/ss_thumbnails/fundamentalsofcolumnstoreintroductions-210205132704-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Top 10 Developer Mistakes That Won't Scale with SQL Server /slideshow/top-10-developer-mistakes-that-wont-scale-with-sql-server/237260870 top10developermistakes-200726144704
You're a C# or Java developer building an application that stores data in Microsoft SQL Server, and you want to avoid common pitfalls that will cause you scalability problems down the road. In this session from my live stream, you'll learn why you probably want to avoid triggers, SELECT *, user-defined functions, dynamic SQL, big datatypes, heaps, storing binaries in the database, old indexes, TempDB, and SQL Server's v1 features.]]>
You're a C# or Java developer building an application that stores data in Microsoft SQL Server, and you want to avoid common pitfalls that will cause you scalability problems down the road. In this session from my live stream, you'll learn why you probably want to avoid triggers, SELECT *, user-defined functions, dynamic SQL, big datatypes, heaps, storing binaries in the database, old indexes, TempDB, and SQL Server's v1 features.]]> Sun, 26 Jul 2020 14:47:04 GMT /slideshow/top-10-developer-mistakes-that-wont-scale-with-sql-server/237260870 BrentOzar@slideshare.net(BrentOzar) Top 10 Developer Mistakes That Won't Scale with SQL Server BrentOzar You're a C# or Java developer building an application that stores data in Microsoft SQL Server, and you want to avoid common pitfalls that will cause you scalability problems down the road. In this session from my live stream, you'll learn why you probably want to avoid triggers, SELECT *, user-defined functions, dynamic SQL, big datatypes, heaps, storing binaries in the database, old indexes, TempDB, and SQL Server's v1 features. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/top10developermistakes-200726144704-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> You&#39;re a C# or Java developer building an application that stores data in Microsoft SQL Server, and you want to avoid common pitfalls that will cause you scalability problems down the road. In this session from my live stream, you&#39;ll learn why you probably want to avoid triggers, SELECT *, user-defined functions, dynamic SQL, big datatypes, heaps, storing binaries in the database, old indexes, TempDB, and SQL Server&#39;s v1 features.
Top 10 Developer Mistakes That Won't Scale with SQL Server from Brent Ozar
]]> 329 0 https://cdn.slidesharecdn.com/ss_thumbnails/top10developermistakes-200726144704-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Deadlocks: Lets Do One, Understand It, and Fix It /slideshow/deadlocks-lets-do-one-understand-it-and-fix-it/228922835 deadlocksbrentozar-200222224220
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. I'm Brent Ozar, and I can help. I'll show you how to build a deadlock in just a few lines of T-SQL so you can see how SQL Server reacts. You'll be more comfortable with the decisions SQL Server takes, and when you can safely ignore 'em. When you can't ignore 'em, you'll learn how to analyze them with free tools (sp_BlitzLock and SentryOne Plan Explorer), and how to fix them with index and code changes.]]>
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. I'm Brent Ozar, and I can help. I'll show you how to build a deadlock in just a few lines of T-SQL so you can see how SQL Server reacts. You'll be more comfortable with the decisions SQL Server takes, and when you can safely ignore 'em. When you can't ignore 'em, you'll learn how to analyze them with free tools (sp_BlitzLock and SentryOne Plan Explorer), and how to fix them with index and code changes.]]> Sat, 22 Feb 2020 22:42:19 GMT /slideshow/deadlocks-lets-do-one-understand-it-and-fix-it/228922835 BrentOzar@slideshare.net(BrentOzar) Deadlocks: Lets Do One, Understand It, and Fix It BrentOzar You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. I'm Brent Ozar, and I can help. I'll show you how to build a deadlock in just a few lines of T-SQL so you can see how SQL Server reacts. You'll be more comfortable with the decisions SQL Server takes, and when you can safely ignore 'em. When you can't ignore 'em, you'll learn how to analyze them with free tools (sp_BlitzLock and SentryOne Plan Explorer), and how to fix them with index and code changes. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/deadlocksbrentozar-200222224220-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> You keep getting warnings and emails about deadlocks, but let&#39;s be honest: you&#39;re not really sure how they happen or what to do about it. I&#39;m Brent Ozar, and I can help. I&#39;ll show you how to build a deadlock in just a few lines of T-SQL so you can see how SQL Server reacts. You&#39;ll be more comfortable with the decisions SQL Server takes, and when you can safely ignore &#39;em. When you can&#39;t ignore &#39;em, you&#39;ll learn how to analyze them with free tools (sp_BlitzLock and SentryOne Plan Explorer), and how to fix them with index and code changes.
Deadlocks: Lets Do One, Understand It, and Fix It from Brent Ozar
]]> 4245 0 https://cdn.slidesharecdn.com/ss_thumbnails/deadlocksbrentozar-200222224220-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Help! SQL Server 2008 is Still Here! /slideshow/help-sql-server-2008-is-still-here/154464648 help-sqlserver2008isstillhere-190709110144
Your company is ignoring the news: SQL Server 2008 and 2008R2 are officially out of support as of today, but nothing's changing at your company. You still have SQL Server 2008 in production, and you're a little nervous. How should you approach the conversations with management? Brent Ozar will help: he's been there too, fighting managers who want to leave an old server hiding in the corner. We'll role play: you be the manager, and Brent will show his techniques for convincing management to take the plunge and move to a newer SQL Server version.]]>
Your company is ignoring the news: SQL Server 2008 and 2008R2 are officially out of support as of today, but nothing's changing at your company. You still have SQL Server 2008 in production, and you're a little nervous. How should you approach the conversations with management? Brent Ozar will help: he's been there too, fighting managers who want to leave an old server hiding in the corner. We'll role play: you be the manager, and Brent will show his techniques for convincing management to take the plunge and move to a newer SQL Server version.]]> Tue, 09 Jul 2019 11:01:44 GMT /slideshow/help-sql-server-2008-is-still-here/154464648 BrentOzar@slideshare.net(BrentOzar) Help! SQL Server 2008 is Still Here! BrentOzar Your company is ignoring the news: SQL Server 2008 and 2008R2 are officially out of support as of today, but nothing's changing at your company. You still have SQL Server 2008 in production, and you're a little nervous. How should you approach the conversations with management? Brent Ozar will help: he's been there too, fighting managers who want to leave an old server hiding in the corner. We'll role play: you be the manager, and Brent will show his techniques for convincing management to take the plunge and move to a newer SQL Server version. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/help-sqlserver2008isstillhere-190709110144-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Your company is ignoring the news: SQL Server 2008 and 2008R2 are officially out of support as of today, but nothing&#39;s changing at your company. You still have SQL Server 2008 in production, and you&#39;re a little nervous. How should you approach the conversations with management? Brent Ozar will help: he&#39;s been there too, fighting managers who want to leave an old server hiding in the corner. We&#39;ll role play: you be the manager, and Brent will show his techniques for convincing management to take the plunge and move to a newer SQL Server version.
Help! SQL Server 2008 is Still Here! from Brent Ozar
]]> 19523 8 https://cdn.slidesharecdn.com/ss_thumbnails/help-sqlserver2008isstillhere-190709110144-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 An Introduction to GitHub for DBAs - Brent Ozar /slideshow/an-introduction-to-github-for-dbas-brent-ozar/131055297 brentozar-anintroductiontogithubfordbas-190208193044
Distributed source control is really intimidating: branches, pull requests, merges - will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved? I'm with you: I'm Brent Ozar, and I hated GitHub. For years, I struggled with it, but I've come to a gradual truce. I'm not a GitHub pro by any means, but in the span of one session, I can explain the most important terms to you in a way that'll make sense for non-developers. I'll show you how to contribute to someone else's open source project, and how to get started putting your own scripts under source control.]]>
Distributed source control is really intimidating: branches, pull requests, merges - will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved? I'm with you: I'm Brent Ozar, and I hated GitHub. For years, I struggled with it, but I've come to a gradual truce. I'm not a GitHub pro by any means, but in the span of one session, I can explain the most important terms to you in a way that'll make sense for non-developers. I'll show you how to contribute to someone else's open source project, and how to get started putting your own scripts under source control.]]> Fri, 08 Feb 2019 19:30:44 GMT /slideshow/an-introduction-to-github-for-dbas-brent-ozar/131055297 BrentOzar@slideshare.net(BrentOzar) An Introduction to GitHub for DBAs - Brent Ozar BrentOzar Distributed source control is really intimidating: branches, pull requests, merges - will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved? ��I'm with you: I'm Brent Ozar, and I hated GitHub. For years, I struggled with it, but I've come to a gradual truce. I'm not a GitHub pro by any means, but in the span of one session, I can explain the most important terms to you in a way that'll make sense for non-developers. I'll show you how to contribute to someone else's open source project, and how to get started putting your own scripts under source control. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/brentozar-anintroductiontogithubfordbas-190208193044-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Distributed source control is really intimidating: branches, pull requests, merges - will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved? ��I&#39;m with you: I&#39;m Brent Ozar, and I hated GitHub. For years, I struggled with it, but I&#39;ve come to a gradual truce. I&#39;m not a GitHub pro by any means, but in the span of one session, I can explain the most important terms to you in a way that&#39;ll make sense for non-developers. I&#39;ll show you how to contribute to someone else&#39;s open source project, and how to get started putting your own scripts under source control.
An Introduction to GitHub for DBAs - Brent Ozar from Brent Ozar
]]> 1355 12 https://cdn.slidesharecdn.com/ss_thumbnails/brentozar-anintroductiontogithubfordbas-190208193044-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 How to Think Like the SQL Server Engine /slideshow/how-to-think-like-the-sql-server-engine/129231635 howtothinklikethesqlserverengine-190125145230
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this series of videos, you’ll learn how the SQL Server engine looks at your indexes and builds your query results.]]>
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this series of videos, you’ll learn how the SQL Server engine looks at your indexes and builds your query results.]]> Fri, 25 Jan 2019 14:52:30 GMT /slideshow/how-to-think-like-the-sql-server-engine/129231635 BrentOzar@slideshare.net(BrentOzar) How to Think Like the SQL Server Engine BrentOzar You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this series of videos, you’ll learn how the SQL Server engine looks at your indexes and builds your query results. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/howtothinklikethesqlserverengine-190125145230-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this series of videos, you’ll learn how the SQL Server engine looks at your indexes and builds your query results.
How to Think Like the SQL Server Engine from Brent Ozar
]]> 1582 8 https://cdn.slidesharecdn.com/ss_thumbnails/howtothinklikethesqlserverengine-190125145230-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 SQL Query Optimization: Why Is It So Hard to Get Right? /slideshow/sql-query-optimization-why-is-it-so-hard-to-get-right/103439568 sqlqo-180628124507
By Dr. David J. DeWitt, MIT]]>
By Dr. David J. DeWitt, MIT]]> Thu, 28 Jun 2018 12:45:07 GMT /slideshow/sql-query-optimization-why-is-it-so-hard-to-get-right/103439568 BrentOzar@slideshare.net(BrentOzar) SQL Query Optimization: Why Is It So Hard to Get Right? BrentOzar By Dr. David J. DeWitt, MIT <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlqo-180628124507-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> By Dr. David J. DeWitt, MIT
SQL Query Optimization: Why Is It So Hard to Get Right? from Brent Ozar
]]> 4779 5 https://cdn.slidesharecdn.com/ss_thumbnails/sqlqo-180628124507-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Dynamic SQL: How to Build Fast Multi-Parameter Stored Procedures /slideshow/dynamic-sql-how-to-build-fast-multiparameter-stored-procedures/90569443 howtobuildfastmulti-parameterstoredprocedures-180313230303
ou're comfortable writing T-SQL, and you've built a lot of stored procedures that have a bunch of parameters. For example, you have that "product search" stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of 'em. So how do we make those go fast? And how can we get 'em to use indexes? In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You'll learn how to write dynamic SQL that's easy to tune, manage, and troubleshoot.]]>
ou're comfortable writing T-SQL, and you've built a lot of stored procedures that have a bunch of parameters. For example, you have that "product search" stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of 'em. So how do we make those go fast? And how can we get 'em to use indexes? In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You'll learn how to write dynamic SQL that's easy to tune, manage, and troubleshoot.]]> Tue, 13 Mar 2018 23:03:03 GMT /slideshow/dynamic-sql-how-to-build-fast-multiparameter-stored-procedures/90569443 BrentOzar@slideshare.net(BrentOzar) Dynamic SQL: How to Build Fast Multi-Parameter Stored Procedures BrentOzar ou're comfortable writing T-SQL, and you've built a lot of stored procedures that have a bunch of parameters. For example, you have that "product search" stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of 'em. So how do we make those go fast? And how can we get 'em to use indexes? In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You'll learn how to write dynamic SQL that's easy to tune, manage, and troubleshoot. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/howtobuildfastmulti-parameterstoredprocedures-180313230303-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> ou&#39;re comfortable writing T-SQL, and you&#39;ve built a lot of stored procedures that have a bunch of parameters. For example, you have that &quot;product search&quot; stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of &#39;em. So how do we make those go fast? And how can we get &#39;em to use indexes? In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You&#39;ll learn how to write dynamic SQL that&#39;s easy to tune, manage, and troubleshoot.
Dynamic SQL: How to Build Fast Multi-Parameter Stored Procedures from Brent Ozar
]]> 2040 3 https://cdn.slidesharecdn.com/ss_thumbnails/howtobuildfastmulti-parameterstoredprocedures-180313230303-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Headaches of Blocking, Locking, and Deadlocking /slideshow/headaches-of-blocking-locking-and-deadlocking/88688066 headachesofblockinglockinganddeadlocking-180223055749
It strikes fear in your heart: "Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim." Learn the basics of how SQL Server handles blocking, locking, and deadlocking.]]>
It strikes fear in your heart: "Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim." Learn the basics of how SQL Server handles blocking, locking, and deadlocking.]]> Fri, 23 Feb 2018 05:57:49 GMT /slideshow/headaches-of-blocking-locking-and-deadlocking/88688066 BrentOzar@slideshare.net(BrentOzar) Headaches of Blocking, Locking, and Deadlocking BrentOzar It strikes fear in your heart: "Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim." Learn the basics of how SQL Server handles blocking, locking, and deadlocking. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/headachesofblockinglockinganddeadlocking-180223055749-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> It strikes fear in your heart: &quot;Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim.&quot; Learn the basics of how SQL Server handles blocking, locking, and deadlocking.
Headaches of Blocking, Locking, and Deadlocking from Brent Ozar
]]> 798 4 https://cdn.slidesharecdn.com/ss_thumbnails/headachesofblockinglockinganddeadlocking-180223055749-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 "But It Worked In Development!" - 3 Hard SQL Server Problems /slideshow/but-it-worked-in-development-3-hard-sql-server-problems-81550635/81550635 brentozarbutitworkedindevelopment-171103110403
Warning: this is not an introductory session. These are going to be tough problems. You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they're very hard to detect in a development environment. In a very fast-paced session, I'll show these three performance problems pop up under load. I won't be able to teach you how to fix them for good - not inside the span of 75 minutes - but at least you'll be able to recognize the symptoms when they strike, and I'll show you where to go to learn more.]]>
Warning: this is not an introductory session. These are going to be tough problems. You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they're very hard to detect in a development environment. In a very fast-paced session, I'll show these three performance problems pop up under load. I won't be able to teach you how to fix them for good - not inside the span of 75 minutes - but at least you'll be able to recognize the symptoms when they strike, and I'll show you where to go to learn more.]]> Fri, 03 Nov 2017 11:04:03 GMT /slideshow/but-it-worked-in-development-3-hard-sql-server-problems-81550635/81550635 BrentOzar@slideshare.net(BrentOzar) "But It Worked In Development!" - 3 Hard SQL Server Problems BrentOzar Warning: this is not an introductory session. These are going to be tough problems. You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they're very hard to detect in a development environment. In a very fast-paced session, I'll show these three performance problems pop up under load. I won't be able to teach you how to fix them for good - not inside the span of 75 minutes - but at least you'll be able to recognize the symptoms when they strike, and I'll show you where to go to learn more. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/brentozarbutitworkedindevelopment-171103110403-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Warning: this is not an introductory session. These are going to be tough problems. You&#39;ve been performance tuning queries and indexes for a few years, but lately, you&#39;ve been running into problems you can&#39;t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they&#39;re very hard to detect in a development environment. In a very fast-paced session, I&#39;ll show these three performance problems pop up under load. I won&#39;t be able to teach you how to fix them for good - not inside the span of 75 minutes - but at least you&#39;ll be able to recognize the symptoms when they strike, and I&#39;ll show you where to go to learn more.
"But It Worked In Development!" - 3 Hard SQL Server Problems from Brent Ozar
]]> 8035 2 https://cdn.slidesharecdn.com/ss_thumbnails/brentozarbutitworkedindevelopment-171103110403-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Columnstore Customer Stories 2016 by Sunil Agarwal /slideshow/columnstore-customer-stories-2016-by-sunil-agarwal/76826261 columnstore-customer-stories2016-170610161021
Uploaded for the GroupBy.org conference for Sunil.]]>
Uploaded for the GroupBy.org conference for Sunil.]]> Sat, 10 Jun 2017 16:10:21 GMT /slideshow/columnstore-customer-stories-2016-by-sunil-agarwal/76826261 BrentOzar@slideshare.net(BrentOzar) Columnstore Customer Stories 2016 by Sunil Agarwal BrentOzar Uploaded for the GroupBy.org conference for Sunil. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/columnstore-customer-stories2016-170610161021-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Uploaded for the GroupBy.org conference for Sunil.
Columnstore Customer Stories 2016 by Sunil Agarwal from Brent Ozar
]]> 1876 7 https://cdn.slidesharecdn.com/ss_thumbnails/columnstore-customer-stories2016-170610161021-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 500-Level Guide to Career Internals /slideshow/500level-guide-to-career-internals-67759935/67759935 500-levelguidetocareerinternals-161028032714
This is not yet another career session that tells you to be friendly and network. Forget that - this is about using your IT skills to reinvent the way you get paid. Brent will explain how he went from DBA to MVP to MCM to business founder. Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore. It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results.]]>
This is not yet another career session that tells you to be friendly and network. Forget that - this is about using your IT skills to reinvent the way you get paid. Brent will explain how he went from DBA to MVP to MCM to business founder. Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore. It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results.]]> Fri, 28 Oct 2016 03:27:14 GMT /slideshow/500level-guide-to-career-internals-67759935/67759935 BrentOzar@slideshare.net(BrentOzar) 500-Level Guide to Career Internals BrentOzar This is not yet another career session that tells you to be friendly and network. Forget that - this is about using your IT skills to reinvent the way you get paid. Brent will explain how he went from DBA to MVP to MCM to business founder. Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore. It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/500-levelguidetocareerinternals-161028032714-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> This is not yet another career session that tells you to be friendly and network. Forget that - this is about using your IT skills to reinvent the way you get paid. Brent will explain how he went from DBA to MVP to MCM to business founder. Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore. It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results.
500-Level Guide to Career Internals from Brent Ozar
]]> 952 15 https://cdn.slidesharecdn.com/ss_thumbnails/500-levelguidetocareerinternals-161028032714-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Introduction to SQL Server Internals: How to Think Like the Engine /slideshow/introduction-to-sql-server-internals-how-to-think-like-the-engine/67657307 howtothinkliketheengine-161026044001
When you pass in a query, how does SQL Server build the results? Time to role play: Brent will be an end user sending in queries, and you will play the part of the SQL Server engine. Using simple spreadsheets as your tables, you will learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.]]>
When you pass in a query, how does SQL Server build the results? Time to role play: Brent will be an end user sending in queries, and you will play the part of the SQL Server engine. Using simple spreadsheets as your tables, you will learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.]]> Wed, 26 Oct 2016 04:40:01 GMT /slideshow/introduction-to-sql-server-internals-how-to-think-like-the-engine/67657307 BrentOzar@slideshare.net(BrentOzar) Introduction to SQL Server Internals: How to Think Like the Engine BrentOzar When you pass in a query, how does SQL Server build the results? Time to role play: Brent will be an end user sending in queries, and you will play the part of the SQL Server engine. Using simple spreadsheets as your tables, you will learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/howtothinkliketheengine-161026044001-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> When you pass in a query, how does SQL Server build the results? Time to role play: Brent will be an end user sending in queries, and you will play the part of the SQL Server engine. Using simple spreadsheets as your tables, you will learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.
Introduction to SQL Server Internals: How to Think Like the Engine from Brent Ozar
]]> 19843 19 https://cdn.slidesharecdn.com/ss_thumbnails/howtothinkliketheengine-161026044001-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Building a Fast, Reliable SQL Server for kCura Relativity /slideshow/building-a-fast-reliable-sql-server-for-kcura-relativity/66928525 it88221ozar-161009211412
You want Relativity to run as fast as possible, but you don't have an unlimited budget. Microsoft Certified Master Brent Ozar will give you real-life stories from shops with high-performance environments. You’ll learn how to choose between virtual and physical servers, understand different high-availability methods, and discover why clustering is such a no-brainer.]]>
You want Relativity to run as fast as possible, but you don't have an unlimited budget. Microsoft Certified Master Brent Ozar will give you real-life stories from shops with high-performance environments. You’ll learn how to choose between virtual and physical servers, understand different high-availability methods, and discover why clustering is such a no-brainer.]]> Sun, 09 Oct 2016 21:14:12 GMT /slideshow/building-a-fast-reliable-sql-server-for-kcura-relativity/66928525 BrentOzar@slideshare.net(BrentOzar) Building a Fast, Reliable SQL Server for kCura Relativity BrentOzar You want Relativity to run as fast as possible, but you don't have an unlimited budget. Microsoft Certified Master Brent Ozar will give you real-life stories from shops with high-performance environments. You’ll learn how to choose between virtual and physical servers, understand different high-availability methods, and discover why clustering is such a no-brainer. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/it88221ozar-161009211412-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> You want Relativity to run as fast as possible, but you don&#39;t have an unlimited budget. Microsoft Certified Master Brent Ozar will give you real-life stories from shops with high-performance environments. You’ll learn how to choose between virtual and physical servers, understand different high-availability methods, and discover why clustering is such a no-brainer.
Building a Fast, Reliable SQL Server for kCura Relativity from Brent Ozar
]]> 1256 5 https://cdn.slidesharecdn.com/ss_thumbnails/it88221ozar-161009211412-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 How to Make SQL Server Go Faster /slideshow/how-to-make-sql-server-go-faster/66928352 it88222ozar-161009210800
You host Relativity data in SQL Server, and you can't just go buy a new server. You need to figure out where your server's bottleneck is, and find the easiest workaround to make it go faster. Microsoft Certified MasterBrent Ozar will show you how to check your SQL Server's vital stats with free tools, and then determine whether you need indexes, memory, or different config settings.]]>
You host Relativity data in SQL Server, and you can't just go buy a new server. You need to figure out where your server's bottleneck is, and find the easiest workaround to make it go faster. Microsoft Certified MasterBrent Ozar will show you how to check your SQL Server's vital stats with free tools, and then determine whether you need indexes, memory, or different config settings.]]> Sun, 09 Oct 2016 21:08:00 GMT /slideshow/how-to-make-sql-server-go-faster/66928352 BrentOzar@slideshare.net(BrentOzar) How to Make SQL Server Go Faster BrentOzar You host Relativity data in SQL Server, and you can't just go buy a new server. You need to figure out where your server's bottleneck is, and find the easiest workaround to make it go faster. Microsoft Certified MasterBrent Ozar will show you how to check your SQL Server's vital stats with free tools, and then determine whether you need indexes, memory, or different config settings. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/it88222ozar-161009210800-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> You host Relativity data in SQL Server, and you can&#39;t just go buy a new server. You need to figure out where your server&#39;s bottleneck is, and find the easiest workaround to make it go faster. Microsoft Certified MasterBrent Ozar will show you how to check your SQL Server&#39;s vital stats with free tools, and then determine whether you need indexes, memory, or different config settings.
How to Make SQL Server Go Faster from Brent Ozar
]]> 2457 20 https://cdn.slidesharecdn.com/ss_thumbnails/it88222ozar-161009210800-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 500-Level Guide to Career Internals /BrentOzar/500level-guide-to-career-internals session14-24hopbrentozar500-levelguidetocareerinternals-160909122418
This is not yet another career session that tells you to be friendly and network. Forget that - this is about using your IT skills to reinvent the way you get paid. Brent will explain how he went from DBA to MVP to MCM to business founder. Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore. It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results.]]>
This is not yet another career session that tells you to be friendly and network. Forget that - this is about using your IT skills to reinvent the way you get paid. Brent will explain how he went from DBA to MVP to MCM to business founder. Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore. It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results.]]> Fri, 09 Sep 2016 12:24:18 GMT /BrentOzar/500level-guide-to-career-internals BrentOzar@slideshare.net(BrentOzar) 500-Level Guide to Career Internals BrentOzar This is not yet another career session that tells you to be friendly and network. Forget that - this is about using your IT skills to reinvent the way you get paid. Brent will explain how he went from DBA to MVP to MCM to business founder. Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore. It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/session14-24hopbrentozar500-levelguidetocareerinternals-160909122418-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> This is not yet another career session that tells you to be friendly and network. Forget that - this is about using your IT skills to reinvent the way you get paid. Brent will explain how he went from DBA to MVP to MCM to business founder. Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore. It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results.
500-Level Guide to Career Internals from Brent Ozar
]]> 9190 17 https://cdn.slidesharecdn.com/ss_thumbnails/session14-24hopbrentozar500-levelguidetocareerinternals-160909122418-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 What I Learned About SQL Server at Ignite 2015 /BrentOzar/what-i-learned-about-sql-server-at-ignite-2015 whatilearnedaboutsqlserveratignite2015-150507124618-lva1-app6892
A recap of what's new with Microsoft SQL Server 2016 from the Microsoft Ignite conference sessions.]]>
A recap of what's new with Microsoft SQL Server 2016 from the Microsoft Ignite conference sessions.]]> Thu, 07 May 2015 12:46:18 GMT /BrentOzar/what-i-learned-about-sql-server-at-ignite-2015 BrentOzar@slideshare.net(BrentOzar) What I Learned About SQL Server at Ignite 2015 BrentOzar A recap of what's new with Microsoft SQL Server 2016 from the Microsoft Ignite conference sessions. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/whatilearnedaboutsqlserveratignite2015-150507124618-lva1-app6892-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> A recap of what&#39;s new with Microsoft SQL Server 2016 from the Microsoft Ignite conference sessions.
What I Learned About SQL Server at Ignite 2015 from Brent Ozar
]]> 12816 6 https://cdn.slidesharecdn.com/ss_thumbnails/whatilearnedaboutsqlserveratignite2015-150507124618-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 https://cdn.slidesharecdn.com/profile-photo-BrentOzar-48x48.jpg?cb=1715427507 Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com. He holds a bunch of certifications and awards including the rare Microsoft Certified Master. www.brentozar.com https://cdn.slidesharecdn.com/ss_thumbnails/fundamentalsoftempdb-210208123031-thumbnail.jpg?width=320&height=320&fit=bounds BrentOzar/fundamentals-of-tempdb Fundamentals of TempDB https://cdn.slidesharecdn.com/ss_thumbnails/fundamentalsofcolumnstoreintroductions-210205132704-thumbnail.jpg?width=320&height=320&fit=bounds BrentOzar/fundamentals-of-columnstore-introductions-242318189 Fundamentals of Column... https://cdn.slidesharecdn.com/ss_thumbnails/top10developermistakes-200726144704-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/top-10-developer-mistakes-that-wont-scale-with-sql-server/237260870 Top 10 Developer Mista...