Back to the Basics: Backups

How can we ignore the harsh experiences of data loss experienced by so many? Ed Pollack discusses the importance of backups and how to determine if a backup plan is adequate.

Webinar: Advanced SQL Server Indexing for DBAs

Develop new techniques that you can use to increase performance in your database right away.

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

Just the mention of UDFs in the SQL Server community can make people cringe. UDFs can be “bad things” and, to the optimizer, they are often black boxes. However, Kathi Kellenberger demonstrates how ITVFs, one of the three types of UDFs, can actually help improve performance.

Webinar: Dell EMC PowerStore for Microsoft SQL Server 2019

Jointly presented by Doug Bernhardt and Bryan Walsh of Dell Technologies, along with Bob Ward from Microsoft, this webinar will discuss the primary considerations for architecting and deploying a foundational infrastructure for containerization and Big Data Clusters in SQL Server 2019.
Learn how the newly released PowerStore storage appliance provides the ideal deployment infrastructure in your journey to SQL Server 2019 and beyond.

Troubleshooting Performance in Azure SQL

At some point, whether you’re a DBA, Developer, or application administrator, you’re going to find yourself troubleshooting performance in Azure. Erin Stellato discusses the tools she used within the Azure Portal to look at performance for an Azure SQL.

Lift-And-Shift to the Cloud With SQL Server on Azure Virtual Machines

Get the combined performance, security, and analytics of SQL Server with the flexibility and hybrid connectivity of Azure.

New Metadata-Only Column Changes in SQL Server 2016

Paul White investigates the new metadata-only column data type changes possible in SQL Server 2016, when using data compression.

Brent Ozar is Giving You Live Database Training!

Join Brent Ozar, Pinal Dave, Janis Griffin, and other top experts for this fun and educational webcast series. Secure your place for Quest ® Database Training Days now.

Learner’s Guide to SQL Server Query Tuning

Kendra Little gives an overview of Query Tuning, sharing the common mistakes, problems, and popular built-in query tuning tools.

Upcoming Virtual Events

 


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.