Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Business intelligence and data warehousing tips and trends for database administrators

SQL etc

Big Data Technologists Transition to Customer-Facing Roles 08/18/2014

Big data applications do not need the same infrastructure support teams as do more common applications. As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.

How Safe is Cloud Storage? 06/05/2014

As more and more companies look to the cloud for their data storage needs, the same questions are being asked over and over again: if a security breech were to occur, who would be responsible and how much of a guarantee could the provider give us that our data would be safe from prying eyes.

TokuMX Compared to MongoDB Using a Specific Common Use Case 05/22/2014

Former AOL database architect and independent database consultant John Schultz benchmarks basic MongoDB from MongoDB, Inc. and TokuMX, the Tokutek high-performance distribution of MongoDB, to see which one performs best at scale. Focusing on a number of important performance characteristics — such as storage I/O and database insertion rates – Schultz tracked the degradation in performance for both products as database size increased. Here are his results.

Getting Started with Microsoft Power BI for Office 365 04/21/2014

Power BI is familiar, intuitive, cloud based self-service BI (Business Intelligence) solution for all your data needs in your very own Excel. It includes different tools for data discovery, analysis and visualization. Furthermore, Power BI integrates with Office 365 to share, collaborate and much more.

Load Testing in a Big Data Environment 03/20/2014

Load tests give the database administrator (DBA) quite a lot of valuable information and may make the difference between poor and acceptable application performance. But what about a big data environment? Are there any gotchas or traps associated with big data?

Windows Azure SQL Database - Uploading Data by Using the bcp Utility 03/10/2014

While using a custom SSIS-based project to upload content of an arbitrarily chosen table from an on-premise SQL Server database to Azure PaaS-based SQL Database provides the most flexibility its inherent complexity might not be justified in more simplistic scenarios. Marcin Policht presents an alternative approach that addresses this concern by employing the bcp utility, which not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.

Getting Started with Microsoft Power Map for Excel 12/23/2013

Power Map is an Excel add-in under the Microsoft Power BI umbrella that extends the capability of Power View by enabling end users to visualize data in a 3D visualization format. Arshad Ali shows you how to install it and how to get started using it.

Getting Started with Microsoft Power Query for Excel 11/25/2013

Power Query, provided as part of the Microsoft Power BI self-service solution, is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Read on to learn how to install and get started using it.

Understanding Microsoft Power BI – Self Service Solutions 11/18/2013

Microsoft Power BI is a cloud based self-service Business Intelligence solution that you can use in Excel for all your data needs. It includes different tools for data discovery, analysis and visualization. Read on to learn more about Microsoft Power BI, the different tools under the Microsoft Power BI umbrella, and when each of them can be used.

SQL etc Archives




Latest Forum Threads
SQL etc Forum
Topic By Replies Updated
MySQL rollback UAL225 0 August 21st, 09:56 PM
Complex Search Query Galway 0 May 20th, 10:04 PM
change collation at once supercain 2 May 15th, 06:18 AM
SQL Features, tools and utilities question Neomite 1 April 10th, 09:13 AM