SQL Server Perfmon Counters that are Still Interesting in 2019

While wait statistics are a good starting point, you may encounter an issue that requires Perfmon counters to solve it. Find out which three Brent Ozar relies on.

Data Expert Series!

Announcing the first-ever PASS Data Expert Series! Register now for a full day of data training from leading experts in Architecture, Data Management, and Analytics - including Kimberly Tripp, Brent Ozar, Pinal Dave, and more. We’ve curated the top-rated, most impactful sessions from PASS Summit 2018 for a jam-packed day of solutions and best practices to keep you at the top of your field.
Whether you’re learning for today, for tomorrow, or trying to stay ahead of emerging trends and technologies, these sessions will give you all of the tools you need to take your data career to the next level.

How Stack Overflow Upgraded to SQL Server 2017

Taryn Pratt, DBA at Stack Overflow, describes the execution of an extremely complex series of 30 Microsoft SQL Server upgrades.

DBA Secrets!

What’s hype and what’s common practice among DBAs? This study reveals the surprising truth.

Microsoft Offers Incentives to Migrate to Cloud for SQL Server 2008 Users

Microsoft SQL Server 2008 and SQL Server 2008 R2 are quickly approaching their end-of-life date, which also means the end of free extended support by July 2019. Learn more about Microsoft's options to bridge the pre-upgrade gap.

Standardizing on SQL Server?

Have other databases you need to migrate to SQL Server?
Toad Data Modeler simplifies the start of your migration journey.

Closest Match, Part 1

Itzik Ben-Gan shares a T-SQL challenge that involves finding the closest match, as opposed to finding an exact match. Itzik provides code to create a sample database and challenges you to match rows from two tables.

The Business Value of Database Health Checks

Inefficient databases cost companies billions per year. Make sure yours are running optimally.

Kubernetes' First Major Security Hole Discovered

There's now an invisible way to hack into the popular cloud container orchestration system Kubernetes.

Upcoming Virtual Events

Let's talk about Big Data using SQL Data Warehouse

Tuesday, February 12. 02:30 UTC.

Winning the Head Game in 2019 with Bobbi-Jo Brighton

Tuesday, February 12. 17:00 UTC.

 


We are recruiting community contributors for all PASS Insights newsletter editions:

DBA, BI, Developer, and Analyst.
We’re looking for engaging, in-depth, and technically-focused ideas to feature each month. If you are interested, submit your ideas to insights@pass.org.
You just might see yourself featured in an upcoming edition!

Looking for more than just DBA educational and technical content?
Log in to your PASS account and subscribe to the new Analyst, BI, and Developer PASS Insights newsletters.