RunAs Radio

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. There are lots more tools needed and Michael gives time to many of them - but Azure DevOps is a great place to start!

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 of great examples online! Sonia also digs into the power of Windows Admin Center to painlessly migrate file storage roles - and improve server management as a whole!

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 to increase security to mail.

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 additional knowledge to your existing knowledge and experience to expand your career!

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 through this together!

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 no - but it can be part of the solution!

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.

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!

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 artificial intelligence technology to find relationships within that data to provide more value to companies using Office 365 - lots of value!

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 integrated into Azure. CosmosDB can make your life simpler!

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 expand your automation over all sorts of disaster recovery needs!

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 available before you can consider turning off passwords - but it is possible!

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!

Links:SQL Server 2019Query Tuning AssistantLearn T-SQL QueryingAzure SQL DatabaseSQL Workshops

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!

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 - all that can be integrated together with the Power Platform. SharePoint still plays a role, but evolved!

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!

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 in new ways we may not have considered. Your fundamental skills are still useful and important - keep improving them!

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.

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!

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 analytics and visualization!

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!

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.

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!

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 workstation - check it out!

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!

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 used, but when do you need governance to make sure it isn't over-used?

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 to get things right!

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!

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!

Are you using SysInternals? Richard chats with Sami Laiho about Mark Russinovich's masterwork. Sami talks a bit about the history of SysInternals and how Microsoft came to acquire them and Mark - and the tool development continues! Process Explorer and Monitor are the best known of the suite of over a hundred tools - and they focus on diagnostics. But once you know what an issue is, there are more tools to help you resolve them. Check out Sami's Pluralsight series on SysInternals - he considers it some of his best work!

Is your cloud secure? Richard chats with Paula Januszkiewicz about what it takes to secure your cloud - that is, the cloud services that you're paying for. Paula talks about how cloud services are not automatically secure, that many security features are off by default and it takes time to figure out how to configure them to help protect your accounts and services. And since cloud products are relatively new, there aren't many experts around - you have to figure out what is right for you and your organization!

How are you managing mobile device? Richard chats with Jeremy Moskowitz about the world of mobile device management and how it continues to evolve. Jeremy talks about the balancing act between supporting Windows-centric concepts that group policy did extremely well alongside what it takes to manage the broader diversity of devices today - and in the future! If you want to dig deep on MDM, check out Jeremy's new book!

It's 2019 - has DevOps 'crossed the chasm'? Richard chats with Nicole Forsgren and Dustin Smith about the latest DevOps report, showing that in all aspects of software development and operations, things are getting better - but not evenly! The conversation digs into the latest research showing that it is large enterprises today struggling the most to improve development and delivery of software, while retail operations seem to be leading the pack! There's a lot to explore in the DevOps report, take a look!

What is it to teach, and what is it to learn when you're in IT? Richard chats with Don Jones about his on-going work on his book Be The Master and how it has evolved since its first publication in 2018. Don talks about how readers connected with him around the book and discussed their own efforts in mastery and teaching - which encouraged Don to revise the book! Remembering how we learn helps inform how to teach, and teaching strengthens knowledge, so everyone benefits - and there's a lot to know!

Office 365 has a ton of features - how do you manage them effectively? Richard chats with Martina Grom about the various aspects of Office 365 that affect the way the folks in your organization collaborate with each other and get work done. As Martina explains, there are great tools inside Office 365 to make it easier to apply policies and governance around the various services that Office 365 provides, including onboarding and offboarding employees, self-service for collaboration, even policies for file storage and retention. Adding Office 365 to the mix can actually make your life easier when it comes to governance!

How much is the cloud costing you? Richard chats with Corey Quinn about his work as a consultant for cloud billing - finding ways to reduce the cost of cloud while maintaining the quality of service. Corey talks about his focus on AWS, but every cloud has similar problems - instances that aren't turned off, over-provisioning and more. In the end, you have to take the time to understand what your organization really needs from the cloud to optimize, but it is worth it!

What do you know about software-defined networking (SDN)? Richard chats with Claudia de Luna about her work in SDN, including implementing Cisco's Application-Centric Infrastructure (ACI). While the physical topology of your network isn't all that different when technology like ACI is in play, your apps see a much simpler network, and strict controls over what your applications can connect with. SDN is changing the networking game - are you playing?

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.

Does Windows still matter? Richard and Paul Thurrott spend the better part of an hour debating back-and-forth about the state of Windows and the need for Windows. Microsoft has split the Windows team and largely concealed its revenue from reporting, so we don't know how Windows is actually doing. What do we want from Windows today? Is it just part of the plumbing now?

Ready for a new Windows administration console? Richard chats with Haley Rowland about Windows Admin Center, a browser-based administration tool that puts a graphical console over top of PowerShell commands to your on-premises servers and workstations - and your Azure-based resources as well! Haley talks about making hybrid cloud easier, using Windows Admin Center to provide coherent connections between on-premises servers and their Azure-based backup solutions. Doing the same task in Windows Admin Center repeatedly? You can grab a copy of the PowerShell script it uses and automate!

Is it time for a new Windows Terminal? Richard talks to Richard Turner about the announcement at Build of the new Windows Terminal. The conversation starts with: Why? Richard explains that the ConHost.exe based console of Windows has hit its limits - the need for backward compatibility exceeds the ability to make changes to it effectively anymore. A new open source project has been developed to allow all the features you've always wanted in a terminal, like tabs, font choices, customization per environment and more - take a look!

Is DevOps only for startups? Rosalind Radcliffe says no! The largest enterprises can benefit from DevOps practices, the challenge is finding the right approach to changing practices. Rosalind talks about getting buy-in from senior leadership by focusing on reducing waste and improving efficiency. Picking the right project is important also - you want a project that is important, but not the crown jewels of the company. Understanding how work actually gets done in the enterprise helps lead you to where you can find improvements in deployment, testing and more. DevOps in the enterprise is possible - and worth it!

It's 2019 - what's new with the Internet of Things? While at the Build conference in Seattle, Richard sat down with Sam George to talk about the latest initiatives Microsoft is taking to bring IoT to the mainstream of business. As Sam explains, its starts with instrumentation - knowing what is happening in your business in more detail. That informs ways to make improvements and further roles for IoT. It's a digital feedback cycle, and it can transform your business!

What can PowerApps do for you? Richard chats with Sandy Ussia about her work with PowerApps and Flow to help organizations build custom applications that run in the browser, on the tablet and phone. On the backend, Flow provides access to many Software-as-a-Service platforms, including all of Office 365 and all sorts of other third-party services. Sandy calls PowerApps a low-code solution, and the code you write is more algorithmic like Excel than C++.

The cloud-based distributed database is a product you can buy by the minute! While at Build, Richard chats with Mark Brown about CosmosDB, Microsoft's high performance distributed database. The conversation turns to the modern thinking around storage - you have lots of space, you need speed and reliability. So what does your data storage architecture look like? Mark talks about how CosmosDB reflects this modern thinking, utilizing the cloud to provide fast data services anywhere you need them.

Machine learning has brought new terms and language to data - do you speak it? Richard chats with Jen Underwood about how machine learning has added capabilities to data analytics, but also a number of new terms that need to be understood to take this capability into the business. If you're coming from the DBA role and adding machine learning to your skills, you need to know the language well enough to teach it to others!

How do you maintain Windows Server Update Services? Richard chats with Adam Marshall about all the maintenance that WSUS needs over time - and the toolset he has built to automate it. This leads to a conversation about Windows Update in general... which hasn't been great lately. Can you really count on Windows as a Service? What about InTune? Adam also talks about Windows Update for Business which is a free option for managing updates without having an on-premises update server. Lots of choices!

Microsoft Teams is popular, but is it effective? Richard talks with Melissa Hubbard about how to get the most of out of Teams. Melissa talks about the natural chaos that comes from adding a new collaboration tool and how that can be a good thing for adoption but ultimately needs some governance. At the same time, too much governance up-front can stop people from using a new tool - so allow a little chaos! Teams is all about collaboration, and works with other Microsoft products like Yammer and SharePoint, offering a great combination!

Is it time to migrate to Server 2019? Richard chats with Dave Kawula who says YES! After a bit of a bumpy start, Server 2019 is good to go and offers a ton of great features - and some pretty painless in-place upgrades too. Dave points out that this is a version of Server 'born in the cloud' and since Microsoft does in-place upgrades, for certain roles, it makes sense for you to do it too. File servers and VM hosts are great for in-place upgrades, but domain controllers and app servers, you need to think things through more carefully - and they're likely virtual machines anyway, so build new... and use automation while you're at it!