Was the marketing hook 'The Internet of Things' conjured up before the technical definition? Are we being persuaded to spend money on fending off yet another fantasy tsunami of data? Already, we have televisions that listen to, and report, your conversations; so are we facing the Science Fiction future of gadgets that report where you go, who you visit and what medications you take? As Robert Sheldon says; "It's big, almost too big to get your arms around".

Cardinality Estimator – What’s new in SQL Server 2014

by Alessandro Mortola

SQLServerCentral.com

Cardinality Estimator

SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.

Creating a multi-option parameter report for SQL Server Reporting Services

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

If you have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values, Ghanesh Prasad explains how to accomplish this in a Reporting Services report?.

Painless Refactoring of SQL Server Database Objects

by Additional Articles

SimpleTalk

Database objects

Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.

Kanban

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about organizing and tracking work with kanban and how that might help you.

What is Database Continuous Integration?

by Steve Jones

SQLServerCentral.com

Continuous Integration (CI)

This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.

Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table

by Additional Articles

MSSQLTips.com

Deleting Data

In this tip, Daniel Farina explains an unconventional way of deleting millions of old records from a table which is accessed by a system 24x7, and without impacting that system.