Subscribe to DSC Newsletter

All Blog Posts Tagged 'SQL' (13)

Visually Explained: Three Excel Core-Features Even Excel-Pros Don't Know

Over the last few years, Excel has been redesigned from the ground up. Currently, Microsoft is making the new Excel core-features available to every user, regardless of your Office 365 license. Thanks to the Microsoft naming conventions, it is easy to confuse the new features with existing ones. That being said, Power Query and Power Pivot are not the same things as Pivot Tables, which you have likely been using for years.…

Continue

Added by Rafael Knuth on November 28, 2019 at 6:10am — No Comments

Azure Data Studio in One Picture

I was invited at the recent Microsoft’s Azure Data and AI Tech Immersion event (March 2019) and we played a bit with various tools, including Azure Data Studio and Azure Databricks. The picture below summarizes my understanding of this platform, based on my short experience with it. 

Azure Data…

Continue

Added by Vincent Granville on April 3, 2019 at 7:30am — No Comments

How to Execute R and Python in SQL Server with Machine Learning Services

Introduction

Did you know that you can write R and Python code within your T-SQL statements? Machine Learning Services   in SQLServer eliminates the need for data movement. Instead of transferring large and sensitive data over the network or losing accuracy with sample csv files, you can have your R/Python code execute within your database. Easily deploy your R/Python code with SQL stored procedures making them accessible in your…

Continue

Added by Kyle Weller on June 4, 2018 at 7:00am — 4 Comments

Everything you need to Know about Scaling MySQL

E-Commerce has been on the rise with more and more businesses taking to online platforms to reach out to their clientele. Consequently, there has been a significant increase in the number of online spending, which has been due to the increase in the adoption and ownership of mobile devices that has resulted in a shift to the web. As a result, shoppers are always looking out for unmatched shopping experiences. That is, quick access, round-the-clock availability, accessible content and smooth…

Continue

Added by Tony Branson on November 17, 2016 at 9:00pm — No Comments

Global NoSQL Market Predictions 2023: North America

Not only SQL (structured query language), also known as NoSQL, is a popular tool used for data management and design of large chunks of distributed data. NoSQL database includes a…

Continue

Added by Madhuri Pawar on December 30, 2015 at 1:30am — No Comments

R Packages: A Healthcare Application

Building off my last post, I want to use the same healthcare data to demonstrate the use of R packages. Packages in R are stored in libraries and often are pre-installed, but reaching the next level of skill requires being able to know when to use new packages and what they contain. With that let’s get to our example.

Useful function:…

Continue

Added by Divya Parmar on November 10, 2015 at 12:36pm — No Comments

How PROC SQL and SAS® Macro Programming Made My Statistical Analysis Easy? A Case Study on Linear Regression

Life scientists collect similar type of data on daily basis. Statistical analysis of this data is often performed using SAS programming techniques. Programming for each dataset is a time consuming job. The objective of this paper is to show how SAS programs are created for systematic analysis of raw data to develop a linear regression model for prediction. Then to show how PROC SQL can be used to replace several data steps in the code. Finally to show how SAS macros are created on these…

Continue

Added by Venu Perla PhD on October 10, 2015 at 9:00am — No Comments

An introduction to Apache drill and why is it useful

With the rapid growth of data and the shift towards rapid development solutions much data is being stored in NoSQL stores such as Hadoop and MongoDB. The infrastructure built upon relational databases that have been used for decades cannot keep up with the volume and scope of data being captured. Further to this SQL is also a really good invention and method for extracting and analysing data that is very widely used.  In short it will not be replaced by hierarchical query techniques…

Continue

Added by Zygimantas Jacikevicius on September 17, 2015 at 6:06am — No Comments

SQL: An Introduction

As the amount of the data grows exponentially and terms such as big data become mainstream, the need to handle all this data has increased. Database skills have become some of the most sought-after in the job market today. SQL, which stands for Structured Query Language and is used for relational databases (RDBMS), is one of those skills. In fact,…

Continue

Added by Divya Parmar on September 8, 2015 at 9:26am — No Comments

GUI software for database performance management

As the size of the database grows database performance becomes critical. Automation is a growing focus for data center operators facing increasingly complex environments. Database administration is complex, repetitive and time consuming. DBAs have to work long hours during off hours downtime. The outage of database costs heavily to the companies and affect their repute.

Shopping engines and online shopping places are highly dependent on database performance. Slower application…

Continue

Added by Muhammad Saeed on May 9, 2014 at 4:00am — No Comments

Introduction to the BigObject® and In-place Computing Model

The BigObject® - A  Computing Engine Designed for Big Data

BigObject® presents an in-place* computing approach, designed to solve the complexity of big data and compute on a real-time basis. The mission of the BigObject® is to deliver affordable computing power, enabling enterprises of all scales to interpret big data. With the advances in what a commodity machine can perform, it…

Continue

Added by Yuanjen Chen on November 20, 2013 at 5:29pm — No Comments

The assumptions on which the RDBMS is based has changed: data and code

In general, computer scientists treats code and data in two very different ways. Virtual memory was originally developed to run big programs (code) in small memory, while data are entities kept in external storage and must be retrieved into memory before computing. As a result, today’s application developers think by instinct the programming model based on storage and explicit data retrieval. This model, referred to as storage-based computing, plays an important role and has done a great job…

Continue

Added by Yuanjen Chen on October 31, 2013 at 7:24pm — No Comments

Monthly Archives

2019

2018

2017

2016

2015

2014

2013

2012

2011

1999

Videos

  • Add Videos
  • View All

© 2019   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service