The following tutorial will show how to export JSON data to a CSV file using SSIS

Can I Use Statistics to Design Indexes?

by Additional Articles

SQLServerCentral

statistics

"I’ve noticed that many indexes in my data warehouse aren’t used frequently. Is there a way to use the automatically generated statistics to make useful indexes?"
Kendra Little answers the question in episode 18 of Dear SQL DBA.

Local Database Issues

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about the issues with using a local database in your application.

SQL Server 2016 Distributed Availability Groups

by Jennifer Brocato

SQLServerCentral.com

always on

High availability solution with cross cluster support using the new Distributed Availability Groups

Top 6 MySQL DBA Mistakes

by Additional Articles

Database Journal

MySQL

To err is human, or so the saying goes. Unfortunately, in the world of IT, innocuous mistakes made early on can lead to really daunting problems down the road. In this article, Rob Gravelle goes over a few of the most common DBA mistakes to avoid. Some of these relate specifically to MySQL, while others may be applicable to any RDBMS.

Performance Improvement for Cursors in Stored Procedures

by Brian Hibbert

SQLServerCentral.com

cursors

Exploring some differences between using cursors, local fast forward cursors and using set logic.

The Google Solution

by Steve Jones

SQLServerCentral.com

Editorial

Google had an interesting solution to managing their databases.

Multi-Step Input Forms in ASP.NET MVC

by Additional Articles

SimpleTalk

ASP.NET

It is a common problem with a web page that a form is too complex to fit easily on the page. You can, of course, rely on the scrollbar, but it soon becomes a daunting and erratic process for the poor user. Wizards, that allow you to guide the user through a process, are great but take time to set up. Is there a simple solution for those occasions where there is too much data-entry for a form but a full wizard seems like overkill?