SQL Server


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.

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.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.