RunAs Radio

What can you automate in the cloud? Everything! Richard chats with Dana Epp about how the tooling in Azure allows for automating a huge range of tasks, starting with Dana's personal focus - security. Dana talks about using automation to catch whenever security rules change anywhere, just for logging if not for direct action. The combination of Azure ARM Templates, Automation and Azure Functions is hugely powerful. The challenge is in managing that tooling, which leads to a conversation around source control, just enough administration and DevOps!

What does it take to build a great cybersecurity team? Richard chats with Paula Januszkiewicz about the work she's doing to create more cybersecurity professionals. The challenge is that cybersecurity still isn't really a profession - there are no certifying bodies out there that take on responsibility for their members. Paula talks about different certifications you can get, but in the end, doing the work is the most important thing - and how you approach security problems. It's a full-time task - if you can't think about security all the time, it's hard to keep up!

So many collaboration offerings - what's the right way to go? Richard chats with Tom Arbuthnot about his experiences around the modern digital collaboration world - using technologies like Slack, WebEx and Skype. Today, Microsoft is pouring its energy into Office 365 Teams. Tom discusses what the strengths of Teams are and the choices moving forward. The conversation also dives into the etiquette of these new tools. For those that grew up with them, it's easy to do the right thing. But people are new to these collaboration tools make mistakes - training is worthwhile!

What does modern service management look like? Richard talks to ex-Microsoft Carroll Moon about his experiences modernizing service management at Microsoft, and now for his customers at CloudFit. The cloud has made compute and infrastructure effectively unlimited for the right price - how does a great IT group take advantage of this? Carroll talks about applying DevOps principles effectively in the operations space to focus on the applications that cause you the most grief, and where improvements can have the biggest impact. You have to measure to know where to work!

Spring in Orlando - time for a SQL Server Questions and Answer panel! Richard hosts a panel of Kim Tripp, Paul Randal, Bob Ward, Aaron Bertrand, David Pless, Tim Radney and many more to answer the questions that the SQL Intersection attendees have. The conversation ranges over challenges around partitioning, scaling, various disaster recovery strategies, the advantages of upgrading to the latest version and providing direct feedback to the SQL team members in the room! These question and answers shows provide a snapshot about the thinking around SQL Server and database administration - have a listen!

Your developers want to do some DevOps - what does it mean to you? Richard chats with Tim Warner about what operations needs to care about and learn when the organization wants to roll out software faster. DevOps is an umbrella term for a lot of different technical changes, but also procedural and culture changes too. Tim hits on the key points for operations folks, including understanding source control (and learning to value it), automating all the things, and being able to get to a known reliable state. Better systems faster!

After email, what's the next thing you want from Office 365? Peter Schmidt says its OneDrive for Business. Starting with the ability to get rid of file attachments in email and instead make the files links to OneDrive for Business - but it goes both ways. Peter talks about how Office 365 Flow can automate the process of moving incoming attachments into OneDrive for Business folders automatically. And then there's the new versioning and backup/restore features in OneDrive for Business. This is not your grandfather's cloud storage solution!

Why should you care about containers? Richard chats with Jennelle Crothers about what container technology does for operations. Like virtualization before it, containers allow you to densify your infrastructure into fewer machines and VMs - and all container tech focuses on configuration-as-code. Containers make sense when you have services that are regularly updated or need to scale elastically. And they work on-premises as well as in the cloud. There are some tricky bits to containers, but if you're looking to provide more services to your customers in less time and at a lower cost, they are certainly worth the look!

What can Microsoft Graph do for you? Richard talks to Sahil Malik about his experiences working with Microsoft Graph - starting with rationalizing all the different versions of Graph that have come along in recent years. While largely they're back to a single version, there still are aspects that are more Active Directory oriented as opposed to broader mobile mindsets. But the issues of identity with users, devices that users use and the rights that applications have with those users and devices is the key - can you keep track of what rights are out there, what is appropriate and contain them? The tools are getting better, but there's still a lot to do!

What does it mean to be a System or Network Administrator? Richard talks to Tom Limoncelli about his experiences and book around the subject. Tom talks about how networking and sysadmin roles have evolved recently, where all the roles are being impacted by automation and DevOps practices - nobody is immune, nor should they want to be! The conversation dives into providing value to the organization, both in the form of keeping the employees productive, as well as safe and secure. It's not just about plugging cables and spinning screwdrivers, today, more than ever, the role of the sysadmin is understanding the needs of the organization and helping to achieve those needs!

The challenge of hiring new people into the world of IT is getting harder every day - what does it take to grow your skilled staff? Richard talks with Don Jones about his book Be the Master, where Don focuses on the fact that there are plenty of apprentices out there, but not enough masters to teach them well. And the masters exist - it's just easy to forget that you know things that others don't know, and need to know. The conversation spans around where learning responsibilities lie - it's not going to be the tools vendors like Microsoft, and while organizations that need skilled people need to support learning, ultimately it comes down to us - we need to want to learn and grow!

If you're writing PowerShell, you're writing code - now debug it! Richard chats with Josh Duffney about tools and techniques for debugging your PowerShell code. The conversation starts out with the admission that as PowerShell coders, you really are doing development work, just for sysadmin tasks. That means you need source control, testing, coding practices and hopefully, a continuous integration pipeline - DevOps all the things! Josh talks about how VSCode has made his life of debugging PowerShell easier with color coding, breakpoints, code formatting and more. It's all code in the end!

Modern security is complex - how can the cloud help? Richard chats with Paul Keely about his work with organizations helping to secure workstations and using the cloud to get insight into the kind of attacks going on and how to mitigate them. Paul talks about security starting with administrators, who are now the key vector to exploits in the modern cybersecurity age. Just Enough Administration, where there are individual accounts for each service that an admin uses and the accounts are logged, emailed and meant for short-term use only. There is a large array of tools provided by Microsoft both on-premises and in Azure - it takes awhile to sort them out, but they are powerful!

How do you ETL? Richard chats with Tom Kerkhove about Azure Data Factory, now previewing V2 features. We've had Extract-Transform-Load workflows since databases were first invented, but the concept was really formalized back in the data warehouse days. With the cloud, there are more tools, more data sources and more compute to enhance your ETL experiences. Tom talks about how V2 of Data Factory adds SQL Server Integration Service functionality so that you can put your SSIS packages directly into Azure. Data Factory is tied in with Logic Apps, including supporting features like Azure Key Vault. This leads to a great conversation about data-centric vs. application-centric workflows. Your company is sure to have both!

Ready to manage SQL Server with PowerShell? Richard chats with Rob Sewell about dbatools, an open source effort to build an amazing set of PowerShell commands for SQL Server. Yes, Microsoft has a few PowerShell commands implemented, but when you see the dbatools set, you'll see what PowerShell can really do for you! Rob talks about the focus on migration for continuous integration purposes, upgrading from one version of SQL Server to another, even into the cloud. If you wanted to get to a place where you can experiment with SQL Server configurations, settings and performance, you need dbatools!

What's a company intranet look like in 2018? Richard chats with Susan Hanley about her work helping companies find value in their internal information management systems - after all, it's where you keep a lot of company value! The conversation starts out with a discussion around search, the bane of most intranet implementations. Sure people want Google, but do they really? The indexing system that Google relies on doesn't make sense in an internal website. Susan points out that today's modern intranet is typically in the cloud, taking advantage of great tools like Office 365. That helps with search, but it starts with culture - does your organization value finding existing things? Without culture, the tech can't save you!

SQL Server keeps getting smarter! Richard talks to Erin Stellato about Query Store and Automatic Tuning. First introduced in SQL Azure, these features showed up in SQL Server 2016 and improved substantially in 2017. Erin describes Query Store as a kind of black box for databases, similar to an aircraft, but you don't need to wait for a crash to value the data stored in it. Query Store is a real-time record of the queries happening in your database, along with the query plan and what caused the query to wait. This leads to a ton of tuning opportunities, including automated tuning, where SQL Server will recommend indexes and other performance features for itself!

SharePoint has never been more manageable! Richard chats with Andrew Connell about his experiences around using the latest programming models for SharePoint and how they stick to more standardized client-side development models that are easier to secure, audit and don't mess with your servers quite so much. The conversation starts out with a discussion around the Office 365 APIs and the programmability they bring to Office 365 as a whole, while also sticking to good secure standards - this is the stuff that Microsoft itself depends on! Andrew talks about how the cloud-first approach to SharePoint has strengthened and simplified SharePoint on-premises, so we all benefit!

How does Office 365 help teams collaborate? Richard chats with Tony Redmond about his insights into Microsoft's on-going effort to make Office 365 the most efficient place for people to work together. Tony talks about two primary hubs of team work - collaboration around email and collaboration around chat. The chat product is, of course, the new Office 365 Teams. The conversation dives into how different people like to collaborate in different ways, and that Office 365 has carved out spaces so that all those styles of collaboration can work together. Some conversations are best suited to Teams, some are best suited to Outlook, and you don't have to choose one or the other. Just don't store files in email!

Your company is sold on the idea of data analytics, but is it ready for it? Richard talks to Jen Stirrup about her experiences getting organizations started with data analytics, which means really focusing on the quality of the data that a company is collecting. Jen discusses her process of figuring out how data is collected, how often it needs to be corrected and how much gets missed and stays incorrect inside the data stores. The conversation also explores the other locations of important data for analysis like weblogs. As Jen says, some data problems are business puzzles and some are business mysteries - and it takes different tools and techniques to answer them!

Desired State Configuration now works boths ways! Richard talks to fellow Canadian Nik Charlebois, a Microsoft Premier Field Engineer, about his work building ReverseDSC. The open source tool is available in the PowerShell Gallery and opens the door to a ton of interesting possibilities. Nik talks about how his work as a PFE is made much easier when he can use ReverseDSC to create a copy of the configuration of a system he is trying to troubleshoot so that he can explore and experiment with no risk. But there's so much more that ReverseDSC can do, especially when you start thinking about continuously deployed infrastructure - creation, deployment, testing and debugging of infrastructure all facilitated by ReverseDSC!

How do you make your work visible to your team, your division, your entire organization? Richard talks to Dominica DeGrandis about her book 'Making Work Visible' and the challenges that IT folks have showing workloads and flow. The discussion turns to the Kanban board, both digital and physical. Dominica talks about methods for identifying work items, showing them flow and making it easy for everyone to see the huge scope of work the average IT team handles.

Office macros need security? Yes! Richard chats with Karim El-Melhaoui about the issues around Office macros. With default settings, VBA macros in the Office suite are incredibly powerful and are an effective malware vector. While Microsoft has some built-in capabilities to warn users about enabling macros, modern malware makers have been socially engineering users to bypass those protections. You can go heavy handed and disable macros with group policy, but what if you need them? Karim talks about some of the latest features coming in the Windows 10 Creators Update to provide more granular security for Office macros. But maybe it's time to move away from them entirely?

Data analytics has evolved - have you kept up? Richard chats with Andrew Brust about the revolution taking place in data analytics in general and Microsoft efforts in the space specifically. Andrew talks about how tools like SQL Server OLAP Services renamed to become Analytics Services, and then moved into the cloud. Not that you need to be in the cloud to do analytics - there are plenty of on-premises tools as well, but it sure does help to be in the cloud. Data analytics workloads are very bursty and well suited to the utility computing offered by the cloud. Lots of links in the show notes, check them out!

Can SQL Server be part of a DevOps practice? It has to be! While at Connect in New York, Richard sat down with Michael Upton to discuss the role of SQL Server in the DevOps practice and the tooling that can make your life easier. The conversation digs into the hard bit - not destroying data. Michael works at Red Gate, who have been building SQL Server data management tools for decades. And they know you can't afford to lose data, so the process of updating has to be done carefully. It can be done, and the effort is worth it - your database can also continuously deploy!

Service Fabric is not just for Azure! While at Connect in New York, Richard sat down with Mikkel Mork Hegnhoj to talk about what Service Fabric can do for your applications. Mikkel talks about the ability to host both Windows and Ubuntu VMs in Service Fabric, on Azure and on-premises. Think of Service Fabric as software to facilitate the architecture of cloud as much as the product - you can configure failover rules, scaling settings and more. And it will run on pretty much anything!

Have you looked into CosmosDB? While at Connect in New York, Richard sat down with Kirill Gavrylyuk of the CosmosDB team to talk about the latest features. CosmosDB an update to Azure DocumentDB that focuses on global distribution and ultra-high performance. On top of that, CosmosDB has different API layers you can call through, including MongoDB and now the Apache Cassandra API. Kirill talks about being a drop-in replacement for these existing data stores, typically when confronted with an application that needs to scale substantially. And you only pay for what you use!

How do you do your business intelligence? While at DevIntersection in Las Vegas, Richard sat down with Jason Himmelstein to talk about PowerBI, the latest reporting and analytics tool from Microsoft. Jason talks about how PowerBI fits into Azure and Office365, but today there is also the PowerBI Reporting Server, which is an advanced version of SQL Server Reporting Services that runs on-premises. This leads to a discussion about how you build a hybrid reporting solution between the cloud and your own data services. Lots of good thinking around business intelligence!

Fall in Vegas - time for a SQL Server Questions and Answer panel! Richard hosts a panel of Kim Tripp, Paul Randal, Aaron Bertrand, Jes Borland, David Pless and Tim Radney to answer the questions that the SQL Intersection attendees have. The conversation ranges over SQL 2017, containers, partitioning, mirroring and what the modern DBA will be doing in the future. SQL continues to evolve and there's a lot to explore!

Are you using SysInternals? Richard chats with Aaron Margosis about the venerable SysInternals tools originally developed by Mark Russinovich. But first, a discussion about Aaron's main job at Microsoft, developing security baseline guidance for operating systems. Aaron talks about the recommended security configurations for operating systems and how you can check the workstations you're responsible for to put those configurations in place. SysInternals also has a role in security, understanding exactly what is running on workstations and more. Aaron talks about a session he did at Ignite on using SysInternal to be better at your job - check it out!

Hybrid Cloud is the new normal! Richard chats with Scott Hoag about his experiences migrating organizations onto Office 365 and embracing the reality that no one is ever 'pure' cloud - on-premises hardware is here to stay and necessary. Scott talks about what services make more sense in the cloud and what works best on-premises, and how to connect the different elements together. The key part of the equation is identity, whether you're using Active Directory or not, working with mobile devices - it's all about identity!

What IT certifications do you hold? Richard chats with Greg Shields about the value proposition behind various IT certifications. In the fast moving software industries, it's pretty difficult to effectively measure the capabilities of someone. The conversation digs into the purpose behind an IT exam, and the dangers of focusing purely on an exam, rather than the body of work the exam represents. Greg discusses Microsoft certifications and the latest software for helping to talk broadly about your skills - and what it means for your work and opportunities!

In May 2018, the EU General Data Protection Regulation laws take effect. Are you ready? Richard chats with Seb Matthews about what IT Pros can do to get ready for the GDPR. The regulations are broad, covering personally identifiable information, data breaches, the right to be forgotten and more. Whether you're an EU company or just do business with EU residents, the GDPR can affect you. Seb talks about the six Ps to compliance: Placement, Process, People, Products, Privacy and Protection. And he also digs into how Microsoft can help with a number of great tools as part of Azure, Office 365 and more. Yet another reason to get to the cloud!

What's next for SharePoint? While at Ignite in Orlando, Richard sat down with Todd Klindt to talk about the next version of SharePoint - announced at Ignite as Office 2019. Todd talks about the recurring nightmare of the end of on-premises versions of SharePoint, and the ever-increasing call of the cloud - Office 365 just gets more compelling every month. What form of SharePoint makes sense for you? There's still a ton of choices to make!

Microsoft has a DevOps practice too! While at Ignite in Orlando, Richard sat down with Donovan Brown and Martin Woodward to talk about their experiences helping various Microsoft teams move along the DevOps journey. The conversation starts out on Visual Studio Team System (VSTS), Microsoft's source and project management software running in Azure, that also builds Azure, as well as many other Microsoft products, including Windows! Donovan and Martin talk about pressing against the edges of what their tools can do - so that you know when you get there, they will be ready!

Databases still need to be reliable, but what does that look like in 2017? Richard chats with Allan Hirt about how he makes databases reliable today. The conversation also turns to how reliability works with the Linux version of SQL Server - clustering is definitely different when you change operating systems! Alan also digs into what the cloud brings to the table - on-premises databases are never going away, and have certain advantages in some scenarios, but you better have a plan for how the cloud fits in, even if only for disaster recovery. The importance of data in an organization isn't going away any time soon!

Desired State Configuration continues to evolve, are you? Richard chats with Missy Januszko about her work (with Don Jones) on The DSC Book. DSC is short for Desired State Configuration, and a key part of PowerShell and the Windows Management Framework. Missy talks about how DSC is a key part of creating 'cattle' style infrastructure, where servers can be replaced on demand and changes are handled through code, not mouse-clicks. The conversation digs into the limits of the 'cattle-ness' of servers and what moves easily to the model and what doesn't. The DSC Book is a 'forever' book from LeanPub and is routinely updated!

Here come the acronyms! Richard chats with Cameron Fuller about Microsoft Operations Management Suite (OMS), the cloud-based instrumentation, diagnostics and automation tool from Microsoft that is all the rage - and not just for cloud related products! Cameron talks about being able to feed any kind of log data into OMS for analysis. The conversation then turns to the on-premises System Center Operations Manager and its role in providing deep analytics into specific Microsoft products, and able to push that data to OMS for a comprehensive view. All these products work together!

Still on the fence about moving services to the cloud? Richard chats with Tim Warner about the on-going evolution of the cloud and the increasing pressure that IT folks feel to incorporate it into the infrastructure strategy of an organization. The conversation starts out with budgeting when it is time to talk about buying new hardware and renewing co-lo space. How does the cloud fit in? Tim talks about what services move easily to the cloud but admits that hybrid is permanent. Is the cloud eliminating IT jobs? It sure doesn't seem like it!

So what is a reporting ecosystem? Richard chats with David Pless about the modern Microsoft reporting ecosystem, which can involve SQL Server Reporting Servers, Excel and the new Power BI tools. David talks about how you can work from the space you're most familiar with, and still be able to move data and reports between the different tools. But they aren't the same - different tools for different purposes. Power BI is the relative new comer and brings the power of the cloud to reporting, but the latest offerings are also available on-premises as well. Lots of reporting choices!

Turn off SMB1! Richard talks to Ned Pyle about the ongoing battle to retire SMB1, a 30-year-old file transfer protocol at the heart of recent malware attacks. While there are patches to eliminate the vulnerability, the best patch is removing the protocol entirely. Already on the schedule for deprecation, Ned talks about how ransomware like WannaCry has accelerated the process. Windows hasn't depended on SMB1 since 2006, the challenge other devices and software - some are current. Patch your systems, be safe and turn off SMB1!

Azure is growing, and Azure Stack is taking orders! Richard chats with Aidan Finn about his work with companies implementing Azure and looking at Azure Stack. Azure Stack is Azure, but it's your own private Azure - you run it where you want. What you don't choose is what hardware (just how much) and any of the configuration, since that is handled by Microsoft. You're always patched at the same level that public Azure is. Does Azure Stack make sense for you? Aidan digs into the various reasons why you might need your own private hybrid cloud!

Lots of news around NanoServer - what's it all mean? Richard chats with Jason Helmick about NanoServer - but first, a quick discussion around a comment from a listener on the ongoing evolution of PowerShell. This ties nicely into the broader topic of Microsoft getting opinionated about how NanoServer should be used, which is to say, designed for containers. Jason talks about containers being light-weight virtual machines with configuration-as-code at their core. Microsoft is picking containers as a key approach to delivering services, does it make sense for you to jump aboard?

Windows 10 has been out for two years now, are you ready to move? Richard chats with Steve Thomas about the latest tools Microsoft provides to help you migrate your clients over to Windows 10. Steve talks about the Windows Upgrade Readiness tools that are part of Operations Management Suite. Not using OMS? Don't worry, there's a free version available for Windows Readiness. OMS brings your readiness evaluation to the cloud, checking against all sorts of hardware configurations and the organization's software library. But as always, it's the homegrown apps that represent the biggest challenge - and there are an array of options for solving that!

Change is scary, how do you keep people from resisting? While at the DevOps Enterprise Summit in London, Richard sat down with fellow Kiwi Rob England to talk about his experiences bringing DevOps practices to very conservative organizations - like the New Zealand government! The conversation starts out with the idea that DevOps is not just for unicorns, that is, companies that are all about leading edge technologies. DevOps works for horses too, it just has to be approached the right way.

Ready to go off the IT rails? Mark Minasi is back! Richard chats with Mark about his favorite subject at the moment - automated vehicles. Mark takes a humorous poke at the role of computing, cloud and sensors that should bring automated driving to fruition. Are we really ready for this tech? That's a big shift in the workforce, a change in the cost of technology and a change in how we all travel. What comes next? Meantime, Mark's life is changing too, what's next for him?

DevOps for Mainframes? Really? Yes really! While at DevOps Enterprise Summit in London, Richard sat down with Rosalind Radcliffe and David Rizzo to talk about how mainframes can be part of a DevOps practice! The conversation starts out with Rosalind talking about the modern mainframe, which in IBM parlance is all about z/OS operating system and hardware. It's not just CICS anymore; Java runs there too! And with z/OS available for IBM Linux, you can run the same operating system setup on traditional PC hardware as well. This leads to all sorts of options in the modern DevOps practice with mainframes!

How can PowerShell improve your help desk? Richard chats with David das Neves about his work improving the efficiency of a help desk by writing PowerShell scripts. Not the most obvious role for PowerShell, but David walks through the process of finding common tech support requests that can benefit significantly from automation, rather than mouse click - like uninstalling and reinstalling Java! This leads to a conversation about creating mature, shareable and maintainable PowerShell scripts that multiple people can use reliably and safely. Think bigger with PowerShell!

ITIL and DevOps together? Yes! While at the DevOps Enterprise Summit in London, Richard sat down with Akshay Ananad and Kaimar Karu of AXELOS to talk about how the DevOps practices apply to service management. ITIL was born in a slower time for IT, but the core axioms are still relevant - you just need to focus on service rather than technology. The conversation also goes to including your service management folks in the conversations around software, the same way that operations, infosec and bizdev need to be involved. Devops is all about service, and so is ITIL!

How is DevOps evolving? While at the DevOps Enterprise Summit in London, Richard sat down with Nicole Forsgren to talk about her latest data finding and analysis on DevOps. The conversation starts with a discussion about making good reports, including who the data is collected from. Ideally you'd want a fully random data set, but as Nicole explains, that's not possible - you have to go with as large a set as possible. In the case of the 2017 report, that's 3200 survey responses. And what do they say? DevOps works for everyone! It's not always easy, but it's worth it!