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.

Properly Upgrading SQL Server

For several reasons, upgrading to modern versions of SQL Server can be more challenging than it was when you upgraded to SQL Server 2012 or older. 

Read More No Comments >

FY2018 Financial Audit Process

You may have seen the recent PASS News post about the completion of our FY2018 financial audit. This is a rigorous process that our management team at PASS HQ (C&C) undertakes every year starting in June and ending in October.
But, what is an annual audit and why does PASS engage in one?

Read More No Comments >

Getting the Most Out of Entity Framework Core

This blog post is my attempt to bring a few nuggets of knowledge about Entity Framework Core (EF Core) to developers to make sure that their data queries are efficient and optimized. 

Read More No Comments >

Program Announcement: Introducing Streams

The PASS community has rapidly expanded over the years to include a wide variety of data professionals from across the industry. As our membership grows, our commitment remains unchanged; to provide industry-leading educational content that meets the needs of all of our members.

Read More No Comments >

SQL Server Perfmon Counters that are Still Interesting in 2019

Years ago, my first go-to tool for performance tuning was Performance Monitor: it was available everywhere, worked in all versions, and gave me a lot of useful information without paying for a monitoring tool. Since then, I've moved onwait stats are a much better starting pointbut there are still 3 good Perfmon counters that I rely on.

Read More No Comments >

Welcoming our New PASS Board Members in 2019

After having some time over the holidays to recharge batteries and get ready for the year ahead, I’d like to thank our outgoing Board members Allen White, Chris Woodruff, and Eduardo Castro for their countless hours of service to the PASS community. They will be transitioning off the PASS Board on December 31, 2018.

Read More 2 Comments >

Technology Architecture Analysis with Databricks or Data Lake Analytics

Databricks is a recent addition to Azure that is greatly influencing the technology choices that people are making when determining how to process data.  Prior to the introduction of Databricks to Azure in March of 2018, if you had a lot of unstructured data which was stored in HDFS clusters, and wanted to analyze it in a scalable fashion, the choice was Data Lake and using USQL with Data Lake Analytics.  With the introduction of Databricks, there is now a choice for analysis between Data Lake Analytics and Databricks for analyzing data.

Read More No Comments >

Are you Wasting Half the Capacity of IDENTITY?

Over time, I have worked on many databases that have used an INTEGER identity as a primary key or clustered index value. Most of the time there haven’t been any issues, but occasionally, I come across a problem table where the IDENTITY value ran out and inserts statements, then failed. This has typically been in a case of a logging table of some type.

Read More 1 Comments >

Licensing Power BI

Power BI can be licensed in three different ways: by user, by content workspace, or by server. Specifically, there are 5 different Power BI Licenses...


Read More No Comments >

Finding the Slowest Query in a Stored Procedure

It’s not uncommon to see procedures with hundreds, even thousands of lines of code.  You may have been told which stored procedure runs slow by a user or manager, or you might have found it by looking in SQL Server DMVs.  Either way, once you have detected the offending procedure, where do you start?

Read More No Comments >

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