SQL Server


Entity Framework 7 Beta 6 Out in Preview

EF7 Beta 6 adds data annotations, customization of reverse engineer via templates, and support for raw SQL commands.

Why I'm Excited About DocumentDB

DocumentDB brings together the best of No-SQL and the cloud, to give you a robust scalable data persistence engine. Here's what you need to know to start developing projects with it.

Tips for Snagging That Senior Developer Job

You're vying for a senior developer position. Here's what you need to know to win over your interviewer.

Speed Up Stored Procedures with Table Valued Parameters

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the call.

Leveraging Custom ASP.NET MVC Templates to Support Real-World Views

In the real world, you'll often need to display constant and repeating data, a.k.a. Master/Detail pages. Custom templates are the cleanest, simplest way for you to manage them.

The Danger of Received Wisdom (or, Stupid Things I've Said)

Peter reviews some of the more spectacularly incorrect things he's told other people and then draws some conclusions.

'Always Encrypted' Leads New SQL Server 2016 Features

Microsoft said a new Always Encrypted security feature highlights its upcoming SQL Server 2016 -- "the biggest leap forward in Microsoft's data platform history" -- shipping this summer in a public preview.

10 Takeaways from Microsoft Build

Microsoft believes Windows 10 will be big for consumers, and an even bigger opportunity for developers. The company trotted out nine more solutions that should keep developers busy.

Microsoft Build: Windows 10, Cross-Platform Development, Universal Apps Are Front, Center

The company packed quite a bit into a three-hour keynote that spanned the spectrum of Microsoft technologies and hardware. For developers, the emphasis was on cross-platform app building, with new tools built right into the next Visual Studio 2015.

Install Problems Reported in SQL Server 2014 SP1

Microsoft pulled its SQL Server 2014 Service Pack 1 after numerous reports of installation errors.

Speed Up Your Application with Stored Procedure and Temporary Tables

Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your stored procedure code).

Azure DocumentDB Goes Live

Microsoft announced general availability of its NoSQL service for developers and IT pros.

Data Platform Needs Foundation, Not Just Planks

As Microsoft continues to offer newer, more innovative data platforms in the cloud, the SQL Server flagship is languishing. Here's what Microsoft needs to do to ensure it moves forward.

Automatic Sorting for Your Collections

The .NET Framework has two collections that will guarantee your items are always sorted whenever you process the collection. Here's how to choose between the two and how to control the sort order (including supporting duplicate entries).

Pink Slip for the Developer Who Slipped In

If you think Bert is all talk when it comes to his decade of C# experience, you're wrong. He delivers…15 times.

Retrieve and Update Entity Framework with Dynamic Queries

You don't have to give up on creating dynamic queries just because you're using Entity Framework. Entity SQL and ObjectQuery will let you generate queries at runtime and still let you update your data through Entity Framework.

Crouching Manager, Hidden Database

If there's one life lesson to be learned here, it's that just because a manager knows how to write code, it doesn't mean that they should be allowed to write code.

A Near-Apocalyptic SQL Disaster Scenario

There once was an invoicing system that, when it worked, it worked very well, indeed. But when it was broken, it was horrid.

Using Multi-Swarm Training on Your Neural Networks

Now that you know how to work with multi-swarm optimization, it's time to take it up a level and see how to train your network to use it.

Dynamic Data Access with Plain Old SQL and SqlQuery

You don't have to give up using dynamic SQL just because you're using Entity Framework. The Entity Framework SqlQuery method will give you back the flexibility of dynamic SQL and still let you work with your data in an object-oriented way.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.