Tokyo DB ShowTech Conference slides and scripts

Publicado originalmente em Blog - Fabiano Neves Amorim:

Hey, as I told, following is the link to download the slides and scripts from my sessions…

http://1drv.ms/1L2N4T7

Some printscreen from slides:

DBA CheckList

image

SQL Server execution plans – hidden and tricky optimizations

image

Ver original


SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083

Rodrigo Duda:

Estatísticas de banco de dados, vale a pena cuidar :)

Publicado originalmente em Journey to SQL Authority with Pinal Dave:

[Note from Pinal]: This is a 83rd episode of Notes from the Field series. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. There is a only one problem – there is no single solution or guidance for how to maintain the database. Everybody has their own opinion and way to do different tasks. Statistics is one of the most important aspect of the database. The performance of entire application can depend on statistics, as it can help SQL Engine with intelligence to execute optimal plan.

In this episode of the Notes from the Field series database expert Stuart Ainsworth explains about basic statistics maintenance.


Statistic maintenance is an important (but often overlooked) aspect of performance tuning for SQL Server.  The query optimizer relies on distribution statistics to determine how the query will be executed, with a particular emphasis on SEEKS vs…

Ver original 691 mais palavras


social listening insights on Adobe Systems, @Adobe, $ADBE using PlusOneSocial.com #realtime

Rodrigo Duda:

Mais sobre Sql 2016!
obs.: opção de criar mais de um tempDB ja na instalação.

Publicado originalmente em The Heartbeat of Social:

image

Download for FREE at http://plusonesocial.com and create your own social insights in real-time

Ver original


Bruce Schneier’s Must-Read Book on Security and Privacy

Publicado originalmente em What's The Big Data?:

Data and Goliath_978-0-393-24481-6“The surveillance society snuck up on us,” says Bruce Schneier in Data and Goliath: The Hidden Battles to Capture Your Data and Control Your World. It’s a thought-provoking, absorbing, and comprehensive guide to our new big data world. Most important, it’s a call for a serious discussion and urgent action to stop the harms caused by the mass collection and mining of data by governments and corporations. To paraphrase Schneier’s position on anonymity—we either need to develop more robust techniques for preserving our freedom, or give up on the idea entirely.

An expert on computer security, Schneier has written over a dozen books in the last 20 years on the subject, some highly technical, but this one is a call to action addressed to a mainstream audience. The impetus for writing such a book, it seems, were the 2013 revelations of the NSA mass surveillance. Schneier worked with The…

Ver original 1.865 mais palavras


3 Recent Books on Data Mining, Data Science and Big Data Analytics

Rodrigo Duda:

for Dummies: Data Mining, Data Science and Big Data Analytics

Publicado originalmente em What's The Big Data?:

Data-MiningNow that most of the hype around big data has died down, overtaken by the buzz over the Internet of Things, we are sometimes treated to serious discussions of the state-of-the-art (or science, for that matter) in data analysis. If you are planning a career as a data scientist or you are a business executive trying to understand what the data scientists are telling you, three recent books provide excellent and accessible overviews:

The Analytics Revolution: How to Improve Your Business By Making Analytics Operational In The Big Data Era by Bill Franks

Data Mining For Dummies by Meta S. Brown

Data Science For Dummies by Lillian Pierson

Bill Franks is the Chief Analytics Officer for Teradata, and his specialty is translating complex analytics into terms that business users can understand. The Analystics Revolution follows Franks’ Taming the Big Data Tidal Wave, which was listed on Tom…

Ver original 967 mais palavras


Skills for Big Data Jobs and Careers (Infographic)

Rodrigo Duda:

More data is being collected, stored and accessed than ever before. New database technologies offer higher availability, more flexibility and better security. As data is increasingly seen as a business asset, data and database management are no longer solely IT responsibilities. This shift is changing existing data management roles and creating the need for new ones. This free ebook takes a big-picture perspective on these key data-management roles and the required skills for attaining them:

  • Chief Data Officer
  • Chief Analytics Officer
  • The Evolving DBA
  • The Evolving Data Architect

faça download do ebook aqui.

tks

Publicado originalmente em What's The Big Data?:

Infographic - The Emerging Skillsets of the Data Revolution

Source: ObjectRocket

Ver original


Free Big Data Analytics Handbook

Rodrigo Duda:

FREE BIG DATA ANALYTICS HANDBOOK

Publicado originalmente em Data Science 101:

Brian Liou from Leada was kind enough to provide a guest post about their latest handbook, The Data Analytics Handbook: Big Data Edition.

Data Analytics Handbook Data Analytics Handbook

Have you ever wondered what the deal was behind all the hype of “big data”? Well, so did we. In 2014, data science hit peak popularity, and as graduates with degrees in statistics, business, and computer science from UC Berkeley we found ourselves with a unique skill set that was in high demand. We recognized that as recent graduates, our foundational knowledge was purely theoretical; we lacked industry experience; we also realized that we were not alone in this predicament. And so, we sought out those who could supplement our knowledge, interviewing leaders, experts, and professionals – the giants in our industry. What began as a quest for the reality behind the buzzwords of “big data” and “data science,” The Data Analytics Handbook, quickly…

Ver original 99 mais palavras


Seguir

Obtenha todo post novo entregue na sua caixa de entrada.

Junte-se a 390 outros seguidores

%d blogueiros gostam disto: