Introduction to Azure Data Studio and the Plan Explorer Extension

Webinar Recap Azure Data Studio (ADS) is a lightweight, browser-based query tool that enables access to all Microsoft on-premises and cloud data platforms from clients running Windows, macOS, and Linux. SentryOne Plan Explorer, the free and wildly popular SQL Server query tuning tool, now has a powerful extension for ADS, giving you the ability to run as a standalone application, from SSMS, and from ADS.  I recently teamed up with Warwick Rudd (@Warwick_Rudd), Data Platform MVP and Principal Consultant at SQL Masters Consulting, for the webinar, “Introduction to Azure Data … [Read more...]

What’s Step 1 in a Cloud Migration? Data Cleansing

When planning a successful cloud migration, several different things need to happen in a specific order. The first step—and possibly the most critical—is to make sure you have clean data to migrate. It’s the perfect time to take a good, hard look at your data and make some assessments. Why assess and cleanse your data? Because storage of data in the cloud has a variable cost. The more there is to store, the more it costs. But if you don’t need or can’t use portions of your data, then performing an assessment literally means you will save money. Click HERE to read more. … [Read more...]

Join Me at These Midwest SQL Server User Group Meetings, Oct. 8-11!

Just a quick note that I’m speaking in Iowa and Nebraska this week. If you’re nearby, I hope you can join us! Plus, I’ve added details for two bonus webinars - one is presented by PASS and the other by my friends at Apex Systems. Click HERE to read more. … [Read more...]

History of PASS, Part 3: Bylaws Version 1

Kevin Kline shares the initial PASS Bylaws, how they came to be, what they focused on, and the first rounds of changes that we made to them as a team. Click HERE to read more. … [Read more...]

DBTA – The Surprising Value and Utility of Azure Notebooks

Even if you have been working in the database industry for a long time, there is a good chance that you have never heard of notebooks. Meanwhile, your colleagues down the hall in the data science or business intelligence department may have been enjoying the powerful utility of notebooks their entire multi-decade career. Click HERE to read more … [Read more...]

DBTA – Whether IT Infrastructure is On-Prem or in the Cloud, You Still Need Architects

The big cloud vendors tout many reasons for running IT infrastructure in the cloud. A very prominent benefit is “accelerated innovation and delivery.” That’s a powerful selling point because every IT manager I have ever known wants to deliver better results, faster, and at lower cost. However, it seems that the less IT managers know about doing actual hands-on IT work, the more demanding they are. They just don’t grasp how hard these projects can be. Conversely, my experience has taught me that most IT managers who came up through the ranks as software developers, system administrators, and … [Read more...]

Expert Q&A: Consolidating Your SQL Server Environment to the Cloud

In this blog post, Kevin Kline answers questions from our webinar “Consolidating Your SQL Server Environment to the Cloud.” Click HERE to read more. … [Read more...]

The Top 4 Data Technology Trends in 2019 Every Data Professional Should Know

Continuous learning is essential to keeping up with new and changing technologies that will impact all businesses and data professionals’ jobs in the coming years. During our free webinar, The Top 4 Data Technology Trends Every DBA Should Know About in 2019, I was part of a panel of data technology experts, including dbatools.io Creator Chrissy LeMaire (@cl), Sabin.io DevOps Data Engineer Mark Allison (@dataguzzle), and Heraflux Technologies Founder David Klee (@kleegeek), who discussed the following four data technology trends: DevOps for databasesCloud computing, administrated by … [Read more...]

Consolidating Your SQL Server Environment On-Premises: Q&A

In this blog post, we answer questions from our webinar “Consolidating Your SQL Server Environment On-Premises.” Click HERE to read more. … [Read more...]

5 Surprising Lessons Every SQL Server Generalist Has to Learn

Webinar Recap Maybe you are an accidental DBA who has recently been assigned responsibility for the SQL Server, on-premises or in the cloud. Maybe you are a generalist who can keep the SQL Server up and running, but don’t know much about how it works. Or maybe you are just starting in your career and want to learn more. Whatever situation applies to you, there are a handful of very important lessons you will have to learn if you administrate a SQL Server. I recently teamed up with Denny Cherry (@mrdenny), of Denny Cherry & Associates Consulting (DCAC, @dcacco), for a … [Read more...]