DevOps involves a whole organization - but what can Ops do to facilitate DevOps? Richard chats with Michael Levan about the role of Ops in the DevOps evolution of an organization. Michael talks about the need for culture change to make your DevOps practices successful, but at the same time, tools have gotten dramatically better. The conversation turns to Azure DevOps as an overarching tool for dealing with the continuous integration and continuous deployment of software for your organization. Th...
Apr 29, 2020•33 min•Ep. 686
Windows Server 2008 and 2008 R2 went out of support as of January 14, 2020. Now what? Richard talks to Sonia Cuff about what your options are to deal with your Windows 2008 Servers. The conversation dives into all the great things that have been added to Server in the past twelve years, and the various options to have to upgrade. Starting with - should you upgrade? Sonia talks about building new VMs for roles like DHCP, DNS and Active Directory - and shifting workloads gradually. There are lots ...
Apr 22, 2020•35 min•Ep. 685
If you care about mail, there are important things coming in 2020! Richard chats with Gareth Gudger about recent announcements from Microsoft that will have an impact on email both on-premises and in the cloud. First up is the end of Basic Authentication to Exchange Online this fall - old mail clients are going to break, time to upgrade! Next is the end of TLS 1.0 and 1.1 support - more client challenges! Gareth talks about upgrading, contracting out and other solutions for the on-going efforts ...
Apr 15, 2020•33 min•Ep. 684
What does it take to become a data scientist? Richard chats with Ginger Grant about her experience talking to DBAs about getting into data analysis and data science. The conversation starts out describing the difference between analysis and science - Ginger describes analysts as using querying to generate dynamic reports in tools like PowerBI. Data science is all about algorithms. But either way, your knowledge of data and domain are key skills. You have an advantage as a working DBA, add some a...
Apr 08, 2020•30 min•Ep. 683
How does IT Pros do their jobs during a pandemic? It may sound like an April Fools Day joke, but it's not. The Covid-19 pandemic is having a significant impact on how we work and play. Richard flies solo again to talk through various aspects of IT during the pandemic, including various efforts needed to help employees work from home, communicate effectively and maintain important operations. This is a time all about business continuity - how can you keep people productive and safe? We can get th...
Apr 01, 2020•17 min•Ep. 682
Teams in Office 365 is a hit - but should it be your intranet? Richard talks with Stephanie Donahue about the role that Teams can play in your organization. More than chat, teams is an effective collaboration tool, and a way to store and share institutional knowledge - how decisions are made, what roles people have in those decisions. Is it the first place you should look when you come into work in the morning? Probably. Is it the perfect place for everything in your organization? Stephanie says...
Mar 25, 2020•34 min•Ep. 681
What is Azure Sentinel, and how can it help protect your organization? Richard chats with Paul Keely about Azure Sentinel, a set of tools that provide Security Information Event Management (SIEM) and Security Orchestration Automated Response (SOAR). Paul talks about going beyond the firewall, into the analysis of behavior within your systems, including Office 365, Azure and more - and using machine learning, being able to detect what unusual behavior looks like and automatically respond to it....
Mar 18, 2020•43 min•Ep. 680
Power BI is a hit! Now what? Richard chats with Melissa Coates about the challenges of applying data governance to analytics tools like Power BI. Melissa describes various aspects of data governance, including security, organization/classification, documentation of data and education - you need training to understand the rules and responsibilities of data in an organization. If every company is a software company, then we're all data stewards as well!
Mar 11, 2020•33 min•Ep. 679
What's an intelligent substrate? Richard chats with Microsoft Technical Fellow Jeffrey Snover about his new role in Office 365. About a year ago Jeff changed jobs and jumped into one of the biggest, oldest (and most profitable) teams at Microsoft: Office. Today Office is totally cloud-focused, and Jeff talks about the intelligent substrate, a NoSQL data store that contains everything related to Office 365, including documents, spreadsheets, SharePoint lists, email... everything. This allows arti...
Mar 04, 2020•41 min•Ep. 678
How do you manage CosmosDB? Richard chats with Deborah Chen from the CosmosDB team about what it takes to care and feed the cloud-based NoSQL data storage solution. Deborah talks about the advantages of not having to manage the infrastructure of storage, with replication and fail-over solutions integrated into CosmosDB from the start - as well as at-rest and in-transmission encryption always on! The management tools are pretty straightforward too, with thorough logging and diagnostics tools inte...
Feb 26, 2020•37 min•Ep. 677
How can a deployment tool make your disaster recovery process easier? Richard chats with Michael Richardson of Octopus Deploy about Operations Runbooks. Octopus Deploy handles deployments very effectively, and with Runbooks, you can expand that functionality to include all sorts of other related processes, like backing up and restoring data, running failover scripts and more. Through deployment, Octopus already knows where all your resources live and the rights they need, making it easy to expan...
Feb 19, 2020•31 min•Ep. 676
It's 2020 - why are we still using passwords? Richard chats with Libby Brown about the on-going efforts to make passwordless authentication work great for everyone. The problems with passwords are well-known, but can we really get to a place where we don't have them at all? Libby talks about the challenges of using multi-factor authentication, including authenticator applications, FIDO keys, facial recognition and more. You need multiple methods of authentication and recovery strategies availabl...
Feb 12, 2020•43 min•Ep. 675
What does it take to get your team learning new skills? Richard chats with Don Jones about the entire learning process in the IT profession. Don discusses outcomes - why are we learning? What new skills will help the company? Answering these questions leads to budgets and times, but also commitment and deadlines. You can't just learn for fun (although you should), you have to provide value to the company. The good news is, we already learn all the time, we just have to remember that we do!...
Feb 05, 2020•36 min•Ep. 674
Links: SQL Server 2019 Query Tuning Assistant Learn T-SQL Querying Azure SQL Database SQL Workshops...
Jan 29, 2020•39 min•Ep. 673
Azure Sphere continues to evolve - what's the latest? While at Ignite in Orlando, Richard sat down with James Scott to talk about how Azure Sphere has progressed. Azure Sphere is a highly secure IoT solution that follows the seven properties of highly secure devices (check show notes for the white paper). James also talks about how Azure Sphere will be in general availability in February 2020 - and it should be your IoT solution!
Jan 22, 2020•34 min•Ep. 672
SharePoint custom solutions are powerful - but how do you get them into the cloud? Richard talks with Christina Wheeler about her work moving complex on-premises SharePoint applications into the Power Platform that includes Office 365, Power BI, Power Apps and more. Christina talks about the cultural shift that happens both to her and her customers as the cloud becomes a compelling option for business. That cultural shift opens up a world of best-of-breed options for CRM, CMS and other tools - a...
Jan 15, 2020•41 min•Ep. 671
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!
Jan 08, 2020•55 min•Ep. 670
Happy New Year! It's 2020 - the future is here! What is the career of an IT Professional going to look like in this decade? Richard flies solo, pulling together a summary of the past few decades and how they will shape this new decade just starting. Don't expect any crazy predictions - the IT industry moves carefully, with logical progressions. In some ways, you can expect more of the same - more computers that people rely on, more security challenges, and more of the new technology being used i...
Jan 01, 2020•38 min•Ep. 669
How do you share company data outside of the company? While at Ignite in Orlando, Richard talked to Joanna Podgoetsky about Azure Data Share, a new tool specifically designed to make it easy to share data outside your organization in a controlled and measurable way. Joanna talks about the various Azure data sources you can use to share data, and how to provide access to it for individuals and applications as well as being able to measure who has accessed the data.
Dec 25, 2019•32 min•Ep. 668
You know about DevOps - but what about MLOps? While at Ignite in Orlando, Richard talked to Damian Brady about how Machine Learning projects need to go through the same kind of lifecycle as any other software project. Damian emphasizes how important good instrumentation is for MLOps - because it can be hard to tell how well a given machine learning model is working. And good instrumentation often involves development, so get with your devs and talk through how you're going to measure success!...
Dec 18, 2019•37 min•Ep. 667
Python and SQL Server together? Julie Smith says yes! Richard chats with Julie about the strengths of Python in various tasks around databases including ETL. Julie talks about the tooling available for doing data extraction, transformation and loading - you can find existing Python implementations on most tasks you need to do! And as of SQL Server 2017, Python is directly supported, so you can call Python code from within T-SQL. And that's just the beginning - wait til you see Python in data ana...
Dec 11, 2019•39 min•Ep. 666
Gene Kim is out with a new book - The Unicorn Project! Richard chats with Gene about his latest book - a fictionalized story of an organization struggling to build software that is critical to the survival of the company. The conversation explores a core aspect of The Unicorn Project known as the Five Ideals. Think of these ideals as a Maslow's Hierarchy of Needs when it comes to teams building software - this is how you do it!
Dec 04, 2019•45 min•Ep. 665
Are you managing your infrastructure with code? Richard chats with Josh Duffney about his current toolset for writing infrastructure as code, including PowerShell, Chocolatey and Ansible. Ansible is an open-source project from Red Hat that includes some retail components if you need them. Josh dives into the playbook model, how Ansible helps make testing that infrastructure code easier, and the challenge of using virtual machine based application deployment in the modern world.
Nov 27, 2019•33 min•Ep. 664
Collaboration continues to evolve - how do you do it? Richard chats with Heather Newman about the tooling and techniques that have changed over the years to let teams work together remotely and in-person. SharePoint has been around a long time, but do you remember Groove? Heather talks about her current favorite stack including Teams, Planner, OneNote, OneDrive and SharePoint, all working together under the Office 365 banner. It's a great time to collaborate!
Nov 20, 2019•44 min•Ep. 663
What is Microsoft 365, and why do you need some? Richard chats with Stephen Rose about the superset that is Microsoft 365, encompassing Office 365, Windows, InTune and more. Stephen talks about how Microsoft is organizing the products that work together with the cloud to be productive, making it easier for folks to put them to work and take advantage of all the features. This includes the latest incarnation of Windows Virtual Desktop, allowing any device to act like a high-end Windows workstatio...
Nov 13, 2019•37 min•Ep. 662
Does DevOps make sense for DBAs? Richard chats with Kendra Little about how DevOps practices have spread throughout the development process - and yet somehow, in some organizations, the database folks aren't all that involved. Kendra talks about what practices work for those responsible for the care of feeding of data, including things like source control and automating deployments. Can it be done? Yes! Is it worth it? Also yes!
Nov 06, 2019•50 min•Ep. 661
How do you keep your groups and teams in Office 365 under control? Richard chats with Tony Redmond about Office 365 and how individual users can create their own groups, essentially on demand. In large organizations, this can lead to a huge proliferation of so-called dead groups - how do you manage them? Tony digs into the policy tools, and what really constitutes a dead group. The conversation also dives into how this keeps happening - making it easy for users to use a feature means it gets use...
Oct 30, 2019•39 min•Ep. 660
Your organization is using Azure - but is it under control? Richard chats with Phoummala Schmitt about policy, compliance, and governance in Azure. Often moving to the cloud starts as an experiment - and then suddenly it's live! While it's great to work through governance in advance, it's not always possible. So how do you get things right? Phoummala talks about account management, monitoring utilization, security and cost controls, all key parts of good governance. Azure gives you lots of tools...
Oct 23, 2019•41 min•Ep. 659
Can deploying software and updates enable a hack? Richard chats with Mikael Nyström about doing secure deployments - and this leads to a conversation about how modern hackers are exploiting systems today. Modern hackers can break into machines, but security restrictions limit their ability to exploit - until an administrator logs into the machine. Mikael talks about limiting your use of super-user accounts, including for deployment - and keeping your systems difficult for hackers to exploit!...
Oct 16, 2019•28 min•Ep. 658
Are you compliant? What does that even mean? Richard chats with Erica Toelle about the various security and compliance features in Office 365. Erica talks about regulated industries such as oil and gas that have very specific rules around reporting and regulations - but every organization can benefit from the security and compliance tooling! Document retention, inappropriate communications across email, chat and other tools are all part of compliance, and Office 365 can help!
Oct 09, 2019•33 min•Ep. 657
