Feed: Databasejournal.com – Feature Database Articles. Author: . An interesting question was posted on the Oracle General Database forums recently inquiring about creating a B-Tree index on a BLOB to speed queries looking for NULLs in that BLOB. The conventional wisdom states that, because it’s a BLOB, NULLs shouldn’t be present. And because it’s a […]
Read MorePosts tagged column
Getting Started with Azure SQL Data Warehouse – Part 5
Feed: Databasejournal.com – Feature Database Articles. Author: . Introduction Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In my last article of the series, I discussed round-robin and the distributed table, how partitioning works in SQL Data Warehouse and […]
Read MoreGetting Started with Azure SQL Data Warehouse – Part 4
Feed: Databasejournal.com – Feature Database Articles. Author: . Introduction Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In my last article of the series, I talked about the different types of tables we can create in SQL Data […]
Read MoreUltra-fast OLAP Analytics with Apache Hive and Druid – Part 1 of 3
Feed: Hortonworks Blog – Hortonworks. Author: Carter Shanklin. This is part 1 of a three-part series of doing Ultra Fast OLAP Analytics with Apache Hive and Druid. Unlock Sub-Second SQL Analytics over Terabytes of Data with Hive and Druid Modern corporations are increasingly looking for near real time analytics and insights to make actionable decisions. […]
Read MorePower BI + ZoomCharts = (Power BI)²: Boost your productivity and add the cool-factor to your reports
Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . As of today, all Microsoft Power BI users can start using dynamic and cool-looking ZoomCharts in reports and dashboards. With ZoomCharts, you can easier than ever before, explore, present and analyze your data. Full multi-touch support makes interaction seamless across all your devices. Try […]
Read MoreVisual Checks on How Data is Distributed in SQL Server
Feed: Blogs – Simple Talk. Author: Phil Factor. This article is all about how to go about looking at a visual representation of the way that data is distributed in tables, in a quick unpolished way, while you are programming with SSMS or whatever you prefer to use. The way that the values of your […]
Read MoreGenerating HTML from SQL Server Queries
Feed: Blogs – Simple Talk. Author: William Brewer. Can you produce HTML from SQL? Yes, very easily. Would you ever want to? I certainly have had to. The principle is very simple. HTML is really just a slightly odd dialect of XML that imparts meaning to predefined tags. SQL Server has built-in ways of outputting […]
Read MoreHow to do cross-platform analytics with Google BigQuery
Feed: Google Cloud Big Data and Machine Learning Blog. Author: Google Cloud Big Data and Machine Learning Blog Team. By Tahir Fayyaz, Sales Engineer and Arun Venkatesan, Developer Advocate Learn how to analyze web (in Google Analytics 360) and mobile (in Firebase Analytics) data together using BigQuery. It’s a common requirement for developers to track […]
Read MoreGoogle Cloud Platform for Data Scientists: Using R with Google Cloud SQL for MySQL
Feed: Google Cloud Big Data and Machine Learning Blog. Author: Google Cloud Big Data and Machine Learning Blog Team. By Gus Class, Developer Programs Engineer, Google Cloud By connecting R to Cloud SQL, you can take advantage of all R features on top of a scalable, fully-managed MySQL service. Many developers working with relational data […]
Read More
Recent Comments