SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power.
- By Erik Bartlow
Possible products include a Windows 8/RT interim release, and a SQL Server Parallel Data Warehouse update.
Latest cuts are seen as a response to reductions in Amazon cloud offerings.
Developers continue to show gains in salary and have better job security than most others, according to Visual Studio Magazine's second-annual salary survey.
Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.
The latest version of SQL Server expands its capabilities. Here are four new things developers can do with it.
What's next on the data frontier? Microsoft will take us into the world of in-memory transactional databases and big data. And if you know how to write code and queries against SQL Server, then you already have the necessary skills to play there.
- By Andrew J. Brust
A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects.
Learn lessons about your own code through the errors committed by other developers.
- By Readers of Visual Studio Magazine
.NET developers are database developers. Whether using ADO.NET, the Entity Framework or data binding, .NET devs work with transactional data as a matter of course.
- By Andrew J. Brust
Custom proximity search, a new feature in SQL Server 2012 Full-Text Search, is facilitated using the NEAR operator.
Upgrades include improved business intelligence capabilities, Reporting Services support for SharePoint.
We're almost at the end of 2012, and it's been an amazing year for Microsoft product releases.
FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.
Tracking down performance problems in your application can be a frustrating experience. Reduce your stress levels with custom counters.
- By Benjamin Day
When fewer SQL Server columns does not mean better performance.
Set up and use create a simple Windows Phone program that connects to Azure Mobile Services.
- By Nick Randolph
It's not clear when the service will be rolled out as a final release.
Microsoft has cooked up a feast of value-added big data cloud apps featuring Apache Hadoop, MapReduce, Hive and Pig, as well as free apps and utilities for numerical analysis, publishing data sets, data encryption, uploading files to SQL Azure and blobs.
- By Roger Jennings
Accessing a customer relationship management system with a custom .NET application can add important functionality.