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.

Monitor Exceptions in Your Database

Introduction This article started with a problem my co-workers had: they got bug reports from users where the application displayed an error message from SQL Server. Since the issue occurred only occasionally, it was difficult for them to reproduce the problem and find out where the error...

Read more

PASS Summit 2020 Update – June Announcement

In my previous blog post, I mentioned that PASS Summit 2020 will be taking place this year, and that I would update the community throughout every step of the process and with every new development.

As we get further in understanding the logistics and financial impact of transitioning to a virtual PASS Summit conference, I wanted to share that we are confident that we will be in a place to announce whether this year’s event will be delivered in-person or virtually by early June.

Read more

Getting Started with Big Data Clusters – Part 1

So, you’ve heard about Big Data Clusters in SQL Server 2019 and want to get some hands-on experience? Let’s get you started today! This article will guide you step-by-step on how to deploy a Big Data Cluster in Azure Kubernetes Services (AKS) from a Windows client. The idea is to get your Big Data Cluster up and running fast without going into detail on every step involved, so don’t expect a deep dive on every component along the way.

Read more

Back to the Basics: Backups

For many organizations, backups tend to be a hassle-task; relegated to the bottom of the pile to be dealt with by whoever has a few minutes to spare to throw something together. For others, backups are deemed unnecessary due to other high availability or disaster recovery features in their software/hardware stacks. These assumptions are often made when time and money are limited resources, and developing new features is seen as more profitable than adding infrastructure and using up precious developer time. To begin to counter these (and other) common misconceptions, it is best to start out with the reasons that backups are important.

Read more 1 Comments

PASS Summit 2019 All Access Winner - Susan Dallegro

As the winner of the PASS Summit 2019 All Access contest I was awarded a complimentary 3-day general session registration for PASS Summit 2019 plus some perks that really made my first PASS Summit experience very special.  These included on-site VIP meet and greets, free ticket to a community-hosted games night, a PASStv interview, reserved front row seating for the PASS Summit 2019 Keynote sessions, a full USB of all PASS Summit 2019 recordings, and some nice swag a PASS Summit branded back pack and water bottle.

I was super excited when I found out that I had won.  I knew that the PASS Summit would be an excellent opportunity to receive world class technical training, learn where the future of the field is heading, make new friends, and experience everything that the community has to offer.  I intended to take full advantage of the opportunity.  I thoroughly and enjoyed every minute of my time at the event.

Read more

PASS Summit Cancellation/Refund Policy Explained

As we navigate through new territory in planning for PASS Summit, we realize that this uncertainty will naturally result in new questions from our community. Transparency is key at all times, and we have been working to get the information we need to answer all of your questions as they arise.

One of the questions we have been asked most recently relates to the PASS Summit refund policy. Wendy announced earlier this month that if we are unable to move forward with an in-person event as planned, we would be ready to switch to an alternative virtual conference. We know there are still a lot of important unanswered questions—including the pricing structure, format, and timing of the virtual event—and we hope to be in a position to provide all of these answers asap and no later than June.

Read more

Automate Professional PowerPoint Presentations Using R

The PowerPoint presentation is the vehicle of choice for information sharing among many businesses. R brings unparalleled power to data analysis and visualization. However, getting those visualizations from a window in R Studio to a formatted slide via copy/paste is tedious and error prone. There is a better way. Jeff Renz demonstrates how R Markdown can automate the creation of presentation-worthy slides from R code. This feature saves hours of time, eliminates errors, and allows a user to update a two-hundred-page slide deck with a key stroke. This is key for decks that include state-by-state data, profit margins across dozens of product lines, or complex visualizations reliant on constantly updated data.

Read more

What Are the Different Types of User Defined Functions in SQL Server?

A few years ago, I did quite a few query tuning engagements. Many of my clients were small software companies who typically did not have a SQL Server DBA on staff. I looked for several anti-patterns, or what I like to call “red flags,” to help find ways that I could help improve performance. One common pattern I saw was the use of user defined functions (UDF).

Just the mention of UDFs in the SQL Server community makes folks cringe. UDFs can be “bad things,” and, to the optimizer, they are often black boxes. It’s also not easy to tell when they are bad by looking at the typical tools used for query tuning like execution plans. In fact, the bad UDFs hide what is really going on from the plan.

Read more

PASS Summit Speaker Agreement Amendment

Members of the community have recently reached out to the Board, and to me personally, asking questions about changes to the PASS Summit speaker agreement cancellation policies; particularly relating to clause 16.

I wanted to share some additional information to clear up any confusion or concerns regarding these clauses.

Read more

Analytical Databases in the Microsoft Data Platform: A Single Source of Truth

Microsoft’s documentation calls Analysis Services an analytical data engine. This documentation references the Tabular Model relying on Vertipaq technology. The marketing involves Azure analytical databases and the growing presence of the refined Big Data tools. No matter what the message, analytical reporting relies on data. The source, structure, and retrieval are important yesterday and today.

Read more 1 Comments

RSS
1234567

Theme picker

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