quarta-feira, 1 de julho de 2015

MongoDB and PostgreSQL struggle for the lead of the chasing group in the popularity ranking


MongoDB regained the 4th rank from PostgreSQL this month and is one of the three systems within the top 10 which could improve their score.

from DB-Engines.com Blog http://ift.tt/1sb9rtx

Linux Foundation Announces R Consortium to Support Millions of Users Around the World

"The Linux Foundation, the nonprofit organization dedicated to accelerating the growth of Linux and collaborative development, today announced the R Consortium. This new organization will strengthen both the technical and user communities as a Collaborative Project hosted at Linux Foundation.
The R language is used by statisticians, analysts and data scientists to unlock value from data. It is a free and open source programming language for statistical computing and provides an interactive environment for data analysis, modeling and visualization. The R Consortium will complement the work of the R Foundation, a nonprofit organization based in Austria that maintains the language. The R Consortium will focus on user outreach and other projects designed to assist the R user and developer communities.
Founding companies and organizations of the R Consortium include The R Foundation, Platinum members Microsoft and RStudio; Gold member TIBCO Software Inc.; and Silver members Alteryx, Google, HP, Mango Solutions, Ketchum Trading and Oracle."

Read more: http://www.linuxfoundation.org/news-media/announcements/2015/06/linux-foundation-announces-r-consortium-support-millions-users

Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06

terça-feira, 30 de junho de 2015

Creating Forward-Looking KPIs


Creating a Forward-Looking KPI

Much of our organizational reporting today looks only at the past. It show us what happened in the past month, most recently completed quarter, or year-to-date. This information has value, but in many cases it would have more value if it would help us look to the future. Often, when decision makers look at past information, they use it to estimate a likely future state.

For example, a CFO looking at the following chart and assume that $2.676M represents ¾ of his total fiscal year sales:

read more

from SQL Server Pro http://ift.tt/1kCjeYg

sábado, 27 de junho de 2015

SQL Server Management Studio Now Has Its Own Upgrade Path


A few months ago I wrote a plea to Microsoft to start the process of modernizing SQL Server Management Studio. As the main application/management tool for interacting with Microsoft's flagship database platform it has lagged behind all other advancement with the product.  Since 2005 when released as the evoloution of SQL Server Enterprise Manager it's only (apparently) been upgraded in order to provide base functionality added as features the SQL Server through (now) five releases: SQL Server 2008, 2008 R2, 2012, 2014 and now 2016. 


read more

from SQL Server Pro http://ift.tt/1kCjeYg

sexta-feira, 26 de junho de 2015

SQL Server 2016 CTP 2.1 Available for Public Download


June 24, 2015 marked a change in how Community Technology Previews (aka CTPs) are released for Microsoft SQL Server 2016.  In his May 27th blog post, CVP of SQL Server Development, T.K.

read more

from SQL Server Pro http://ift.tt/1kCjeYg

terça-feira, 23 de junho de 2015

Q & A: Restore Missing SQL Server Performance Counters


See how to restore missing SQL Server performance counters
See how to restore missing SQL Server performance counters

read more

from SQL Server Pro http://ift.tt/1kCjeYg

sexta-feira, 19 de junho de 2015

Download the Free Data Dictionary APP!

Data Dictionary Free is a free software, that allows you to set the extended properties in a SQL SERVER Database and generate a Data Dictionary exported to a csv file.

As it is distributed freely, It is supported by your donation, so please donate!

If you find any issues or bugs in this application, please report it to sky@skytecnlogia.com.

Download the software here! Copy the files to a folder in your hard drive and execute the FreeDataDictionary.exe file.

quinta-feira, 18 de junho de 2015

First Look at System-Versioned Temporal Tables-Part 1: Creating Tables and Modifying Data


SQL Server 2016 introduces support for system-versioned temporal tables based on the ISO/ANSI SQL:2011 standard. A table without system versioning enabled holds only the current, most recent, state of its rows. You cannot query past, deleted or pre-updated states of rows. For the purpose of our discussion, I’m ignoring row-versioning capabilities related to concurrency control, like the multi-versioning concurrency control (MVCC) support of the In Memory OLTP engine, and the row versioning support of the snapshot and read committed snapshot isolation levels for disk-based tables.

read more

from SQL Server Pro http://ift.tt/1kCjeYg

terça-feira, 16 de junho de 2015

Quiz: New Features in SQL Server 2014


Read our article on SQL Server 2014, take our quiz, and receive 20% off a SQL Server Pro Online Training Class!

read more

from SQL Server Pro http://ift.tt/1kCjeYg

quinta-feira, 11 de junho de 2015

The Essential Guide the SQL Server 2014: The Resource Governor


Learn about the new capabilties of SQL Server 2014's Resource Governor
Learn about the new IO limiting capabilities of SQL Server 2014's Resource Governor

read more

from SQL Server Pro http://ift.tt/1kCjeYg