show episodes
 
Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
 
SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.
 
The Ingeniously Simple podcast provides an under the hood look at how we design, build and manage Redgate's portfolio of products. We'll discuss all aspects of our product development process, with insights into how we approach research, design, engineering, product management and delivery; as part of a strong, cross-functional team culture that promotes agility, collaboration and learning.
 
Loading …
show series
 
YAML is a file format, and as with many formats, some of us love them and some of us hate them. It seems to be better than XML in many ways, and perhaps easier to deal with the JSON. It might not be better than csv/tsv/delimited formats for large transfers but for many of us, it's a nice format for configuration items. While the format felt fairly …
 
I saw two things recently. First, CU25 for SQL Server 2017 was released. I realized that I was CU8 locally, so I had work to do. Second, I noticed that SQL Server 2016 fell out of mainstream support on 13 Jul, 2021. Amazing that it's been around for 5 years already and has moved into Extended support. We'll still get security updates, but nothing w…
 
The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the name can be a bit misleading, (What? Microsoft have confusing names—that's a first), the major benefit to the tool is the assessment feature to alert y…
 
Our out of this world hosts are back on what is both Space Exploration, and Moon Day. In this galactic episode our space cowboys explore why standardization should be the centre of your universe to avoid crash landing. We launch into the news taking flight with an update on the BA breach and a black hole in VW data, plus upcoming events to transpor…
 
First we had the Solarwinds hack, and now we have a Kaseya ransomware epidemic. It seems the criminals are moving up the stack. We used to see physical attacks on tapes and keyboards, then we saw OS level attacks. Now we seem to be getting to the management layer for software that is used to help us run systems at scale. Since we often require some…
 
There are many of us that work with systems where data is processed in real-time and then used to make decisions. These might be humans viewing reports and then taking action, or some automated system that might react based on a value changing. In many cases, however, the amount of data, timing in which to react with a decision, and the implication…
 
I saw a job description recently for a DBA that asked for SQL Server experience, but also "other RDBMSes, like Cassandra and PostgreSQL". Not sure Cassandra fits there, or why this says like. I've seen some other ads that ask for C# or Python. Some asking for MDX/DAX knowledge along with AWS Cloud Formation and programming APIs. Some have a require…
 
As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consider as we attempt to prevent application issues. These techniques also go into the security space and could help prevent data loss. As we collect this…
 
We use a lot of automation at Redgate. As a company that builds software, we want to ensure that all the changes from our teams get integrated and tested in a timely manner. We have multiple teams on some products, and while we do have regular meetings between them, it can be easy for a developer to miss some update on a change others are making an…
 
Guy and Eitan shoot the breeze about several interesting topics that you wouldn't want to miss out on! Relevant links: SQL Server 2016 going out of mainstream support Intelligent Query Processing Capabilities in SQL Server Group by conference recordings on YouTube Dynamic search queries in T-SQL - THE NINJA WAY - by Eitan Blumin SQL Data Partners E…
 
We're coming up on the middle of the year, and I wonder if you are improving your career this year? Did you make plans and are you sticking to them? I've been tracking progress on my goals, and so far mediocre progress. It's tough to learn, but even tougher to learn when you don't have a specific focus. Choosing to "get better at T-SQL" isn't a goo…
 
It seems not too long ago that NoSQL was the hottest thing on the market. MongoDB was leading the charge, with tremendous growth as a company and many developers looking to adopt their platform. I remember years ago going to visit a number of customers in New York City, where Mongo had just grown their offices. Every company was considering migrati…
 
Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in this episode Eitan Blumin, a co-host at sqlserverradio.com, brings us up to speed on the latest features of SQL Server Data Tools with some thoughts …
 
On World Giraffe Day, our tower of Chris’s look at how taking a top level, giraffe’s eye, view of your data protection is not enough. Our hosts outline how to do a Proper Job of classifying and cataloguing your data to prevent things going a bit sour, like Chris’s beer. In The News we talk sports, from Excel-ing at Data Modelling to the theft of FI…
 
Half of all advertising dollars are wasted. We just don't know which half. That's a common view from people purchasing advertising, and it's why I expect that this saying is what has led to complaints from Google, Facebook, and other large firms that track people across different sites and apps. They have built frameworks that make it easy to add m…
 
Let’s say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don’t have to worry about the hardware, managing the software can be problematic. The SQL Server IaaS Agent Extension can offer some PaaS-like services and make it easier to manage the database environment. In this episode we chat with …
 
Alex Yates has become quite the DevOps consultant in the last few years. I used to work with Alex at Redgate before he left to start his own consulting firm. I hear nothing but good things about his work, and if you are looking for someone to help guide your database development team, he'd be a good choice. He wrote a piece on the Octopus Deploy bl…
 
Today we go over a list written by Kevin Chant about a year ago, and add some of our own insights. Relevant links: Ten comments I think every SQL Server DBA wants to say | Kevin Chant Eitan's T-SQL Tuesday blog posts about automation and productivity: T-SQL Tuesday #123 – Life hacks to make your day easier T-SQL Tuesday #127 – Tips and Tricks to Au…
 
The three themes for speakers at this year's PASS Data Community Summit are: Back to Basics, Reach for the Clouds, and Level Up. The goal here is content that covers a wide variety of areas, with many fewer restrictions from previous years. Perhaps the big thing to note for this year's event is: Free. That's right, this year's Summit is free for th…
 
I was listening to Kendra present at Redgate recently and she said this: Working predictable hours makes me better at my job. Actually, she said she was not better at her job by working longer. Kendra has been very successful, she's driven and a bit of a workaholic. I used to think I was, but after spending a few years at Redgate with her, she can …
 
Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the report and have the recipient go “What am I looking at?” I don’t think I am the only one and, in this episode, we explore some of the rookie mistakes I…
 
It’s officially “I need a patch for that day” and to celebrate our hosts have gone all out, quaffing the West Country’s finest cocktail. Talking all things patching, Chris and Chris tackle the million $ debate: hot fixes- hero or villain? In The News we hear how delays reporting a data breach can cost you a Booking, and it’s no longer just your ema…
 
Loading …

Quick Reference Guide

Copyright 2021 | Sitemap | Privacy Policy | Terms of Service
Google login Twitter login Classic login