Properly Upgrading SQL Server

Upgrading to modern versions of SQL Server can be more challenging than it was to upgrade to SQL Server 2012 or older for several reasons. Many database professionals are not fully aware of how SQL Server 2014 and newer versions use the database compatibility level to control an increasing number of performance related behaviors. Glenn Berry shares how to properly upgrade SQL Server.

2018 Market Guide for Data Masking

PASS members can access the Gartner 2018 Market Guide for Data Masking, compliments of Redgate.

The report will help you assess your approach to protecting sensitive data, and presents key capabilities offered by data masking vendors such as Redgate.

Custom Migration to AWS Drives Cost Optimization and HIPAA Compliance for Massachusetts eHealth Collaborative

Faced with a growing need to manage 10 terabytes of sensitive healthcare data, Massachusetts eHealth Collaborative (MAeHC) needed to switch from an on-premises SQL Server 2008 environment to a solution that enabled greater agility.

Clustering and High-Availability

John Marlin discusses Failover Cluster resources and resource types. Find out what they are, what they do, and when they are added (or removed).

Tired of Wasting Time Fixing SQL Server Performance Problems?

Keep up to five SQL Server targets running at peak performance with SQL Sentry Essentials, a new edition of the top-rated database monitoring product.

How to Linux for SQL Server DBAs

As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In this series of articles, Kellyn Pot'Vin-Gorman demonstrates how to create a SQL Server instance via a Docker container, how to manage user accounts, and walks you through several examples of files and directories in Linux.

Data as a Service?

A new approach to data governance and data engineering. Get your business users access to the data they need – securely and quickly  using open-source tools. Accelerate queries using Apache Arrow.

Top 10 Enterprise Database Systems of 2019

There's no single correct answer for every data problem, nor is there a perfect database system; each has its own set of features and shortcomings. Here's a primer of the top enterprise database systems on the market in 2019 to help you determine which solution will likely work best for you.

Upcoming Virtual Events

Architectural Choices that Affect Performance

Tuesday, February 19. 17:00 UTC.

Stored Procedure Optimization Techniques

Tuesday, March 05. 17:00 UTC.

Where Should My Data Live (and Why?)

Tuesday, March 12. 01:30 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.