New Options for Training and Learning

In 2008, I managed to achieve the goal of becoming a Microsoft Certified Trainer. Once I achieved the status, Microsoft shipped me a binder with dozens of DVDs containing lab VMs and class materials for all the current classes. At some point, instead of receiving DVDs, you were expected to download images which was quite difficult with my slow connection. Unfortunately, while I did teach a lot of classes, I only taught one Microsoft Official Curriculum class and let the certification drop after a few years.

With the prevalence of cloud services and virtualization, there are new ways to provide learning environments for students. One example is Katacoda, now owned by O’Reilly. You can create virtualized environments based on templates that students start up with a few commands all within a browser. Docker uses Katacoda for their tutorials, so you may have used it.

I recently taught a class using a similar technology from Microsoft called Azure Lab Services. All I had to do was create a template VM loaded with the software and labs. At class time, each student had their own VM to use based on the template. The class went well, so I’ll use this method again.

Two of my favorite ways to learn from Microsoft are no longer available. The Microsoft Professional Program, which retired in 2019, was a way to take classes on EdX towards a certificate. The first certificate was Data Science with several other disciplines added later, and quite a few data platform community members took the Data Science track before it went away.

Another way to learn, which I am sad to see go, was the Microsoft Hands-On Labs in VMs. The labs allowed you to spin up a VM on demand with everything you needed to complete a module. You could follow the lab or just experiment with the VM.

Not to fear, Microsoft has some new high-quality offerings to help you learn their technologies. Microsoft Learn has several modules with virtual hands-on learning based on job roles. The classes are tied to certifications if you are interested. You can also learn GitHub in the GitHub labs or take a class on LinkedIn Learning. Of course, there are many other great sites with training and resources as well.

Microsoft recently announced 30 Days to Learn It. This program is also role based, and you have a month to complete a set of role-based modules to receive a 50% off certification exam. The clock starts counting down once you click “Get Started” so you can’t see what’s in the track if you are not ready. I began the DevOps challenge this week. One of the modules set up a sandboxed Azure subscription to use for the class. This way, you don’t burn through credits or have to pay for the services you use during the lab. I’m not sure how this works under the hood, but it’s a great platform and I look forward seeing it in future modules.

Technology has changed our lives in many ways, and learning is no exception.

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

Redgate has just published the 5th annual State of Database DevOps report, In this blogpost, Andrea Giardina explores key insights across four trends: DevOps adoption, performance & DevOps, the rise of cloud & cross-database, and the impact of the pandemic.

There are certain checks that need to be done after a database migration is complete. One good example of this is the check that a migration script, such as one that merges changes from a branch into main, doesn't cause 'invalid objects' (a.k.a. 'missing references') in your databases. I'll show you how to run this check, using sp_RefreshSQLModule, and incorporate it into a Flyway "after" migration script.

Phil Factor explains the uses and limitations of native SSMS templates and snippets, and then demonstrates the extra versatility that SQL Prompt snippets provide.

Dave Poole explains the need for high quality database documentation and then demonstrates how to document the SQL Server database for a data catalog, in both HTML and Git Markdown, using SQL Doc, SQL Data Catalog, PowerShell, and a few helper scripts to ensure consistency and correctness.

The “Prod-Server Casino“ A production environm...

I talked a few posts ago about Automatic Sample Si...

Synonyms inside SQL Server are one of those useful...

Anyone who’s experienced database corruption knows they do not want it to happen again. Corruption repair is stressful and could require money and downtime you can’t afford. In some...

Occasionally you need to take inventory of how much free space each database has. You can find this quickly and easily in Database Health Monitor, but if you want...

           Azure Cosmos DB announced Continuous Backup in Cosmos DB on March 2021. This feature is currently in public preview mode and It is not recommended...

I always follow a contained user model when settin...

Click to learn more about author Ciaran Hourican. The term “big data” has become widespread within the digital community, referring to everything from predicting long-term weather forecasts to appreciating...

A persona is an imaginary figure representing a segment of real people, and it is a communicative design technique aimed at enhanced user understanding. Through several decades of use,...

I am excited to share an important milestone in my...

Spreadsheets’ main purpose is data: storing, man...

BrentOzar.com is 20 years old, so I’m spending 20 days reflecting. Yesterday, I wrote about how my online classes are available to Europeans now, and today I’m going to...

As we celebrate International Women’s Day, I’v...

This month is hosted by Brent Ozar (t | b). Brent asked us talk about our favorite or least favorite data type this month. You can check out the invitation here.

There is a list of data types over in the docs, and most of them have a use.

In his original invitation title, Brent did open the possibility for us to write about our least-favorite type, so that’s the route I’m going.

It is time for the March T-SQL Tuesday blog party. For some time now I have been planning to blog about data types,..

This month the #TSQL2SDAY invitation comes from Br...

It has been a while since I wrote a blog post for ...

It’s that time of the month again, and this time...

Over on Curated SQL today, I linked to Deborah Melkin’s review of the different date and time data types available in SQL Server. As I was reading that, I...

There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.

Transparent Data Encryption (TDE) with a Customer ...

Seagate recently published its long-term technology roadmap revealing plans to produce ~50 TB hard drives by 2026 and 120+ TB HDDs after 2030. In the coming years, Seagate is...

We are proud to announce great news for DAX Guide! Starting today, every DAX function has its own dedicated video. Moreover, we added new examples that you can try...

I’m so thrilled to join Taiob Ali (t | w) in presenting Kusto Query Language and Azure Log Analytics at Columbus, OH PASS User Group session this Thursday March 11 at 6pm ET...

How SQL Server actual execution plan operator timi...

Indexing the database tables is one of the ways to up your game in tuning queries. How do you do it?...

But My Tempdb Using the scenario from yesterday’s post as an example of why you might want to think about rewriting queries with Table Spools in them to use...

If you’re using the new Parquet connector in Pow...

Watch the replay...

Until now, one common knowledge about Power BI was...

Below is the Power Query Syntax where I wanted to ...

Want to try things out with Power BI Embedded? Wan...

This book aims to improve the performance of your SQL Server, how does it fare? Benjamin Nevarez concentrates on improving the performance of your SQL server largely from a configuration perspective, rather than looking at how to improve specific queries. The premise being that if you improve your system settings, your queries should run faster.

Click to learn more about author Anne Hardy. When dealing with gender inequality in the IT industry, the problem must be acknowledged, understood, and ultimately fixed by creating an...

This series of posts introduces the recipes in the...

Tomorrow, March 9, 2020, at 3 PM EST, I will be gi...

It's not always DNS... sometimes it's printers.

Another month has passed; time for another T-SQL T...

Itzik Ben-Gan continues working with several reade...

In database systems in general and in SQL Server in particular, functions are pieces of code that take zero or one input and return a single output or an array...

Growler Well over 500 years ago, Paul White wrote ...

First, please, please, please, avoid NoLock. You c...

When paginating results in SQL, we use standard SQL OFFSET .. FETCH or a vendor specific version of it, such as LIMIT .. OFFSET. For example: As always, we’re...

One of the weirder things about graph tables in SQ...

If you are curious about how to easily determine if your SQL is following best practices guidelines, you can watch the Data Exposed Live episode we did recently. We demo'ed SQL Assessment API and SQL Assessment Extension for Azure Data Studio (ADS).

Recently, with the help of a colleague at work, I’ve started to dabble a little with containers. I had a customer that requested some specific code to be tested, and I realized that I didn’t have my own local instance of SQL running (always good to have a local one)...