PASS Pro Now Available

Welcome to the next evolution of PASS. Unlock exclusive training, discounts, and networking opportunities designed to accelerate your data career. Learn More >

The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

Leverage Power BI Automation Using Power Automate and API

Introduction

For a Power BI tenant’s administrator, it's a challenging task to admin and maintain the environment. Many changes are taking place every day. New users are added, workspaces are created/deleted, datasets are refreshed, etc. How can we keep everything under control? What’s needed is automation. Through the joint use of APIs and Power Automate, it’s possible to leverage some common tasks automatically.

Read more 2 Comments

WorkFlows – What Are They? “The Book Definition”

WorkFlows – What Are They? – “The Book Definition”

Windows PowerShell Workflows are designed for scenarios where these attributes are required:

  • Long-running activities.
  • Repeatable activities.
  • Frequently executed activities.
  • Running activities in parallel across one or more machines.
  • Interruptible activities that can be stopped and re-started, which includes surviving a reboot of the system against which the workflow is executing.

Read more

Power BI Dataflows – Enabling BI Professionals and Data Scientists

Recently, I was reading an excellent article titled “Agile Digital Transformation for Data-Driven CEOs with Power BI” by Jen Stirrup (t|b) on why Power BI is a valuable tool for data driven CEOs to change the culture of their organizations. One of my favorite features to come to Power BI is Power BI dataflows and I believe it will improve the data management and usage in organizations.

Read more

Parameter Sniffing and Performance

If you were using SQL Server in 2008, you would have heard about parameter sniffing at that time. If you are using SQL Server now, I am very confident that you may have encountered this topic as it is quite common in the SQL Server environment. Parameter Sniffing has been an evergreen topic for discussion for SQL Server Performance Tuning experts.

Before we continue talking more about parameter sniffing, let us understand what parameter sniffing is and how it affects SQL Server performance.

Read more

Design for the Future, Not the Past!

Every organization that manages data fights the same battle on a regular basis. Should systems be architected quickly to solve a current problem, or should they be built to withstand the test of time?

This question sounds like a no-brainer. Who wouldn’t want to build systems that scale, are well-documented, easy to maintain, and can manage the inevitably massive torrent of data that will flood it in the future?

As is often the case in software development, theory and reality differ greatly. Oftentimes building a system or feature correctly the first time is seen as expensive and time-consuming. Deadlines are real and they often influence design as much as the features themselves.  If you have ever worked on a project where the goal was an MVP (minimum viable product), then you understand how this can feel!

Read more

PASS Regional Mentor Program Re-Launched

As a community-centric global organization, PASS continuously strives to engage with our 300,000+ members around the world – and PASS Regional Mentors help to facilitate these connections. For those who are not already familiar, the PASS Regional Mentor Program supports a team of passionate volunteers who are committed to the engagement, mentorship, and support of PASS Community Leaders and members of their respective regions across the globe. This program has been in place for several years, and it was time to re-visit the eligibility requirements, nomination & selection process, term duration, and responsibilities of the role. Over the past several months, the PASS HQ Community Team has worked closely with members of the PASS Board to re-develop the program, as well as collaborated with existing Regional Mentors for their feedback.

Read more

Being a Woman in the SQL Community

Read original blog post here.

In celebration of Women’s History Month starting next week, I was asked to write this blog about my experiences as a woman in the SQL Community, and it really got me thinking. At first, I thought I should be very politically correct and only talk about the great stuff and hype up all wonderful experiences I’ve had but then I thought that wouldn’t give a true picture. So, I am writing this as openly and honestly as I can. Here it goes.

Read more

Upcoming Microsoft Certifications for Data & AI

Qualified data professionals are always in demand. And their importance in digital transformation is undeniable. They modernize relational SQL Server databases on-premises, migrate and administer them on Microsoft Azure, or use the best of both worlds in hybrid environments. Plus, they drive insights at cloud scale, managing great volumes of data—from ingesting and storing to reporting and visualizing.

As a PASS member and a technical professional, you can probably identify with these tasks. In fact, they might even describe your typical workday. So I’m excited to share some big Microsoft Certification news with the PASS community! Effective early April 2020, Microsoft will offer two new role-based certifications, and they’re designed especially for data professionals. Microsoft Certified: Azure Database Administrator Associate and Microsoft Certified: Data Analyst Associate will expand the Microsoft Certifications Data & AI portfolio, which includes Azure Data Engineer Associate, Azure Data Scientist Associate, and Azure AI Engineer Associate.

Read more

PASS and the Anti-Harassment Policy

In 2012, PASS implemented the PASS Summit Anti-Harassment Policy because of our commitment to providing a safe environment for all of our members. Much of what led up to the creation of this policy was the need to have an avenue to investigate alleged harassment incidents. Unfortunately, most of us have either been a victim of or witness to an incident of harassment. The Anti-Harassment Policy is in place to support a safe and inclusive environment and covers far more than some of us know. From the policy:

“Harassment includes, but is not limited to, offensive verbal comments related to gender, race, sexual orientation, disability, religion, or any other protected classification directed toward an individual or group.”

Read more

Data, AI and Cloud: The Top Data Jobs of Tomorrow

Good news for the PASS community. World Economic Forum’s 2020 Future of Jobs report continues to forecast an exceptionally bright outlook for Data, AI, and Cloud Computing professionals. The Jobs of Tomorrow: Mapping Opportunity in the New Economy examines digital era changes and top emerging professions. World Economic Forum sourced the data from partnerships between New Metrics CoLab, Burning Glass Technologies, Coursera and LinkedIn. Let’s peek at the highlights.

Read more

RSS
123578910Last

Theme picker

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids