Big Data

Exploding the Myths of Big Data

  • Article

As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.


11,670 reads

Another Look at Tuning Big Data Queries

  • Article

Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers.


11,157 reads

Preparing Your Enterprise for Big Data

  • Article

Big data applications are now fairly commonplace in large organizations. It is, however, difficult to simply ‘drop’ these applications into an existing IT infrastructure and expect to run smoothly. In addition to energy and cooling requirements for new hardware to support the new big data application, other IT areas need to prepare.


9,144 reads

Integrating Big Data into the Enterprise Data Warehouse

  • Article

Big Data implementations are more than just lots of data. Of equal importance is the analytics software used to query the data. Analyzing business data using advanced analytics is common, especially in companies that already have an enterprise data warehouse. It is therefore only natural that your big data application must be integrated with the existing warehouse.


10,283 reads

Managing Big Data DBAs

  • Article

Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?


10,972 reads

Do We Still Need Database Design in the Era of Big Data?

  • Article

Many big data application implementations seem to begin with an existing data warehouse, one or more new high-volume data streams, and some specialized hardware and software. The data storage issue is often accommodated by installing a proprietary hardware appliance that can store huge amounts of data while providing extremely fast data access. In these cases, do we really need to worry about database design?


5,297 reads


Passwords = A Good Thing


Those my friends are, in my opinion, one of the single most wonderful things...

Speaking at SQL Saturday Oregon


SQL Saturday Oregon — in the city of Portland — is taking place next...

Want to be more comfortable with the Extended Events Viewer?


I’ll admit, I’m a lot more comfortable with tracing and the profiler than I...

Read the latest Blogs


Get lat/long from Point

By HildaJ

Hello everyone, I have a table with a field "shape" which is geometry.  I...

help !split the rows!

By caojunhe24

hi there, am new to SQL and now am trying to do row split....

split one rows to multiple rows in the table based on the size

By caojunhe24

hi there, am new to SQL and now am trying to do row split....

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers