Best Tsql podcasts we could find (Updated April 2019)
Related podcasts: Sqlserver Database Developer Training Community Tech Science Education Featured FM Prog Languages Software Development  
Tsql public [search 0]
×
Join millions of Player FM users today to get Tsql news and insights whenever you like, even when you're offline. Podcast smarter with the podcast app that refuses to compromise … it's free and easy.
Podcast smarter! Player FM is free and easy.
show episodes
 
Welcome to SQL Server 101. I’m Phillip Burton from sqlserver101.com. This podcast is an audio version of the video courses that I created for Microsoft SQL Server. They aim to get you from beginner level to that needed for the 70-461 certification, and beyond. Learn the skills that could you need to get your next dream job. The 70-461 certification, called “Querying Microsoft SQL Server”, is intended for SQL Server database administrators, system engineers and developers with two or more yea ...
 
GroupBy.org is free technical training by the community, for the community. Volunteer speakers submit abstracts at GroupBy.org and you – the attendee – vote to pick the sessions. Want to present your own session or just vote on others? Join us at GroupBy.org.
 
Loading …
show series
 
Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions. In this session, we will discu ...…
 
Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there are whole execution plans behind those Index Scans ? Did you ever ask yourself, what are those strange and weird HT_* waits stand for ? Why do we wait for seconds/minutes for something like HTBUILD while it seems that nothing happens ? Why d ...…
 
The optimizer has options. Not every option is optimal. Optimistic query tuners hope that the optimizer will make optimal choices. Often, the optimizer will stick an optional operator in a plan that just doesn’t belong. Sorts, Spools, Lookups, Tops, Aggregates, and Bitmaps can all end up where they don’t belong. Opt out of bad powerpoint decks ...…
 
What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I'm living my dream. In this session, we'll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing my journey, I'll give some helpful tricks to getting your next job. You'll learn how to write a ...…
 
Whether you love or hate buzzwords, the big ones signify critical cultural changes. In this session, Kendra Little will explain what executives mean when they describe a 'digital transformation', why this transformation is happening across all industries, and how understanding this gives developers and database administrators an advantage in bu ...…
 
Topics in this episode: Updating data Objectives of Session 3 Problems What are constraints?
 
A new release of SQL Server is like a new season of your favorite TV show. Some releases in the past were lacking; I always felt like SQL Server 2008 R2 was about as exciting as the Seinfeld finale. But Microsoft hasn't disappointed in recent years, and SQL Server 2019 is no exception. There are some really exciting features here. Some are big- ...…
 
This mainly demo-based session will cover the following: An introduction to partitioning, core concepts, and benefits. Choosing a Partitioning Key Creating Partition Functions & Schemes Indexing Considerations Splitting, Merging & Switching Partitions Implementing Partition Sliding Windows Filegroup Restores with Partitioning After the session, ...…
 
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? I know I did. It is how I stumbled into my career in performance tuning. In this session, you will learn some T-SQL performance tuning tips that can be used in the office immediately. You will learn how to identify top offender queries ...…
 
One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems. In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your ETL workflows: Brute Force Log shipping/Read Only standby Ro ...…
 
Topics in this episode: Missing data; Deleting data
 
There seems to be a common misconception that once you move from on premises SQL Server to Azure PaaS offerings a DBA is no longer required. This perception is wrong and in the session I’ll show you why. As a business intelligence consultant I develop data platform solutions in Azure that once productionised need administration. As the title su ...…
 
Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It's not easy to form indexes for a large and complicated query, and things only get more complicated when queries can come from vendor applications, ORM tools like LINQ, or any number of other sources. When it's time to create the perfect index, there ...…
 
Topics in this episode: Creating a third table; JOINing three tables
 
I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvements that won’t change a lot of code, won’t generate weeks of testing and validation for your colleagues and can be relatively quick to implement. But most of all, they’ll make the code prettier and easier to ...…
 
Topics in this episode: Writing a JOIN queryl different types of JOIN
 
Topics in this episode: Designing a connection; Importing data and showing tables graphically
 
Topics in this episode: Exercise; Designing second table
 
Topics in this episode: WHERE and GROUPING; HAVING
 
Topics in this episode: WHERE queries
 
As the DBA for an Agile, Sprint-based team, you may feel like the bottleneck at every turn. You’ve stuck with the existing processes and tools because it’s what you know. After all, “If it ain’t broke, don’t fix it!” Right? I have good news! With only a few new skills and free tools from Microsoft, you can join the Agile & DevOps revolution to ...…
 
You've been writing T-SQL queries for a few years now, and when you have performance issues, you've been updating stats and using OPTION (RECOMPILE). It's served you well, but every now and then, you hit a problem you can't solve. Your data's been growing larger, your queries are taking longer to run, and you're starting to wonder: how can I st ...…
 
Topics in this episode: Creation of the Employee Table; Objectives for Session 2; Adding additional columns
 
You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what? In this session we will analyze common use cases of poorly performing queries, such as im ...…
 
Today's applications are not using monolithic approach anymore and evolving into micro-services architecture. Monitoring tools are also evolving, micro-services approach have stepped into this area as well. What you should do if you have several technologies under your responsibility? SQL Server and MySQL? Maybe Hadoop or PostgreSql? Should you ...…
 
Topics in this episode: More date functions; date offsets; converting from dates to strings
 
The incredible Columnstore Indexes can increase your analytical query processing speed multiple times, they are updatable (Clustered from SQL Server 2014 and Nonclustered from SQL Server 2016 respectively), but they keep on supporting different sets of the functionalities – such as Change Data Capture (Nonclustered Columnstore) or LOBs (Cluster ...…
 
Topics in this episode: Joining a string to a number; Date data types; Setting dates and date extraction
 
Topics in this episode: NULL - an introduction; Joining two strings together
 
Topics in this episode: Strings and String Functions
 
Topics in this episode: Mathematical functions; converting between number types
 
Topics in this episode: Integer and non-integer numbers
 
Topics in this episode: Retrieving data; deleting data and table; creating table and temporary variables.
 
Topics in this episode: Creating our first queries; creating a table; entering data
 
Topics in this episode: Curriculum; Opening SQL Server; Looking at Management Studio; Create a database
 
Topics in this episode: Introduction; Installing SQL Server and Visual Studio
 
Microsoft emphasizes use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database cloning for the full range of the SQL Server family. We’ll explore use of containers for delivery of container environments, and their pros and cons. We’ll also look ...…
 
Will cover all new SQL 2017 features that the Data Platform Community has requested and Microsoft has included in the next major version of SQL Server. 200 level
 
This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such as read-only routing and backup off-loading. In addition, ...…
 
SQL injection is one of the most common ways that hackers gain access to your SQL server. Do you know how to harden your queries and protect your data from malicious users? This session will provide an overview of how SQL injection works and how to write injection-proof queries through a series of T-SQL demos. We’ll also take a look at why some ...…
 
You’ve just been given a server that is having problems and you need to diagnose it quickly. This session will take you through designing your own toolkit to help you quickly diagnose a wide array of problems. We will walk through scripts that will help you pinpoint various issues quickly and efficiently. This session will take you through; Wha ...…
 
There are tools available from Microsoft, as well as from a number of third party vendors, to ease the process of integrating database unit testing into your development environments and your continuous delivery pipeline. This session isn't about any of those tools, but is an attempt to get back to basics - with the open source tSQLt framework ...…
 
Do you work for an institution that fears its DBAs could go rogue on their production databases? Do you want to revoke continuous sysadmin permissions from your DBA team in an attempt to avoid being the next WikiLeak? Do you have concerns that the DBA team is querying sensitive databases? Then you need Uptight Database Security. Come to this se ...…
 
Congratulations on your recent move into the world of SQL Server development! You've got a handle on the basics -- SELECT, INSERT, UPDATE, and DELETE -- but now what? How do you know what's important to learn next, and what's most likely a waste of time? In this session, we're going to answer these questions and more. You'll discover why set-ba ...…
 
You’re a DBA or Developer, and you have a gut feeling that these simple queries with an egregious number of columns in the SELECT list are dragging your server down. You’re not quite sure why, or how to index for them. Worst of all, no one seems to be okay with you returning fewer columns. In this session, you’ll learn why and when queries like ...…
 
I’m going to look into the basics of how encryption works and then we’ll learn how we can go about writing our own encryption routines within SQL Server. When we’re happy that those routines are secure, we’ll look at ways that we can go about cracking those routines.
 
SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). But when mission-critical databases go offline, bringing them back online could be a nerve-wracking experience. This session will look at understanding how the underlying WSFC platform works to help us maintain a ...…
 
You’ve just been handed a SQL Server, and you need to make sure there aren’t any skeletons in the closet. What things should you check to make sure everything is healthy? In this presentation, we’ll run you through the checklist I use when I provide a health check to a customer. First, I check for any resume generating events (RGEs) like broken ...…
 
Google login Twitter login Classic login