SQL Server


Dev Disasters -- Why They Happen, How to Overcome Them

Learn lessons about your own code through the errors committed by other developers.

Will Big Data Be Big with Developers?

.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.

Full-Text Search in SQL 2012 with Custom Proximity

Custom proximity search, a new feature in SQL Server 2012 Full-Text Search, is facilitated using the NEAR operator.

SQL Server 2012 Gets First Service Pack

Upgrades include improved business intelligence capabilities, Reporting Services support for SharePoint.

Microsoft's Big Product Year

We're almost at the end of 2012, and it's been an amazing year for Microsoft product releases.

Using FileTables in SQL Server 2012

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

Load Testing with Custom Performance Counters

Tracking down performance problems in your application can be a frustrating experience. Reduce your stress levels with custom counters.

The T-SQL Trick

When fewer SQL Server columns does not mean better performance.

Getting Started with Windows Azure Mobile Services

Set up and use create a simple Windows Phone program that connects to Azure Mobile Services.

SharePoint 2013 Changes with the Times

It's not clear when the service will be rolled out as a final release.

Big Data in the Cloud

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.

Build a More Powerful CRM System with Visual Basic .NET Extensions

Accessing a customer relationship management system with a custom .NET application can add important functionality.

Windows Azure: The Loose Ends Come Together

On June 7, Microsoft introduced its revamped Windows Azure cloud computing platform to the world.

Microsoft Releases Windows Azure SQL Reporting

The service is free until Aug. 1.

Windows Azure Release Includes New SDKs

By adding IaaS to its Platform as a Service (PaaS) portfolio, Microsoft is also mounting its most formidable challenge yet to Amazon Web Services.

Database Synchronization with the Microsoft Sync Framework

Use the Microsoft Sync Framework to synchronize data changes between SQL Server 2008 Standard, SQL Server 2008 Express and SQL Server Compact Edition 3.5.

Exec: Microsoft Plans to 'Cloud Optimize Every Business'

In Microsoft's last fiscal third quarter, Server and Tools delivered $4.57 billion in revenue to the company, up 14 percent. The division is large, growing and increasingly profitable

Windows 8 'Pre-Release' Version Coming in June

The "release candidate" of Windows Server 2012 is expected at about the same time.

Entity Framework Code-First Migrations

Code First Migrations allow for database changes to be implemented all through code. Through the use of Package Manager Console (PMC), commands can be used to scaffold database changes.

The Evolving Definition of 'Big Data'

While there's lots of talk about big data these days (a lot of talk), there currently is no good, authoritative definition of big data, according to Microsoft Regional Director Andrew Brust.

Subscribe on YouTube