Posts Categorized: Pythian

Data toons: Cirque du DBA

It’s not uncommon for database administrators (DBAs) to feel like ring masters at the circus. But what happens when you free up in-house DBAs by outsourcing database management? This work is licensed under a Creative Commons Attribution-NoDerivs 3.0 Unported License. Based on a work at

Why is Affinity Mask Negative in sp_configure?

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value. name                                minimum     maximum     config_value run_value ———————————– ———– ———– ———— ———– affinity mask                       -2147483648 2147483647  -1066394617  -1066394617 Affinity mask is a SQL Server configuration option which is used to assign processors to specific threads for improved…

The Growing Trend Toward Data Infrastructure Outsourcing

Outsourcing White Paper graphic - blog post

Today’s blog post is the first of three in a series dedicated to data infrastructure outsourcing, with excerpts from our latest white paper. Despite the strong push to outsource corporate functions that began more than two decades ago, many IT shops have been hesitant to outsource their data management requirements. Generally, the more mission-critical the…

Oracle RMAN Restore to the Same Machine as the Original Database

Among the most critical but often most neglected database administration tasks is testing restore from backup. But sometimes, you don’t have a test system handy, and need to test the restore on the same host as the source database. In such situations, the biggest fear is overwriting the original database. Here is a simple procedure…

Paul Vallée’s Interview with Oracle Profit Magazine

Aaron Lazenby, Editor at Oracle’s Profit Magazine interviewed Pythian Founder, Paul Vallée this week to discuss the growing risk of internal threats to IT. “What we need to create is complete accountability for everything that happens around a data center, and that’s where our industry is not up to snuff right now. We tend to…

4 Things Every CMO Should Do Before Approaching IT About Big Data

Read the full article, 4 Things Every CMO Should Do Before Approaching IT About Big Data.   “You’ve likely heard the whispers (or shouts) about Big Data’s potential, how it’s the holy grail of marketing—and it can be. But to uncover this information and take action on it, marketing needs to partner closely with all…

VIDEO: The Evolution of IT Outsourcing

“For us to understand what’s going on in the industry at large, it helps for us to have a deeper understanding of the history of the outsourcing industry.” Pythian founder, Paul Vallée shares his insights on the history and evolution of IT outsourcing. Pythian has developed 5 criteria for choosing a data management outsourcing partner….

Page 1 of 19512345...102030...Last »