SQL Server


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.

A Visual Studio Trick for Creating External Lists for SharePoint

Make Visual Studio do the hard work to simplify the creation of external lists that can be used to connect outside data to your SharePoint projects.

Leveraging a Visual Studio Database Project

Peter shows how a Visual Studio database project can make you more productive when making changes to your database. But a database project also gives you a variety of tools to let you keep track of what those changes are -- which will make moving those changes to your production environment considerably safer.

Simplifying Development with Visual Studio Database Projects

Peter learns something by listening to readers: Visual Studio database projects provide a great environment for making changes to your databases. Here's a brief introduction about how they'll make life easier for you and all the steps for setting one up.

Visual Studio Online Updates Identity Controls

New identity controls are among the sprint 74 updates being made to the service. Plus, Brian Harry explains the outage from last week.

NoSQL for .NET: RavenDB 3.0 Takes Flight

Among a bevy of new features in this upgrade to the alternative open source NoSQL database engine for .NET is a new storage engine and file system.

Microsoft's Lankford Explores Cloud Development

The Visual Studio ALM product manager leads the crowd at Live! 360 through some of the market forces driving cloud development.

Out of Time

It’s crunch time for Ben and his team. After a long journey, their project to uplift their biggest client’s application code is nearly at an end. Hopefully they didn’t miss anything ...

How to Refactor for Dependency Injection, Part 6: Binding by Convention

Explicitly setting all the bindings needed to compose your application -- that's a lot of work! See how to use convention over configuration to save time and make your composition easier to understand.

Writing Cleaner Code with Reactive Extensions

When you have a process that can return multiple results over time, then .NET Framework Reactive Extensions will let you simplify your code and manage it better.

Azure Improves Table Storage Paging

Incremental improvement to Azure Mobile Services .NET Backend Azure Storage Extension and Windows Azure Mobile Services will ease table navigation pain with Web apps.

Azure Improves Auditing, Previews PowerShell 0.8.9

Microsoft adds Azure SQL Database auditing improvements, an Azure Websites support extension, and a cloud-based PowerShell in preview.

How To Solve the Impossible Data Problem

Andrew does integration for a living. As a result, weird client data comes with the territory, but one client's data in particular stands out as being truly unique.

SQL Server 2008 SP4: Really, That's It This Time

The differences between this release and the SQL Server 2008 R2 SP3 release from last week are distinct enough to warrant separate releases.

SQL Server 2008 R2 SP3 Is Last One You'll See

Microsoft makes good on commitment to continue improving older solutions, but the support will eventually end for this version as a newer, cloudified version 2014 takes over.

Splitting Tables To Improve Performance: A Designer-Based Solution

Peter returns to improve performance by splitting a single table into multiple entities, but this time, he implements his solution using the Entity Framework 6 designer.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.