SQL Server and SDS


Security Tightened in SQL Server Data Tools Update

Database schema comparisons, security among incremental updates made to this July 2014 release of SSDT.

Test-Driven Development with Entity Framework 6

You can completely disconnect your test code from your database with Entity Framework 6 in .NET and Visual Studio. You just need a little bit of custom code for your application, along with some boilerplate code.

The $100,000 Deadline

A critical auditing app was as down as the floor of the Grand Canyon. And each day it was down was a six-figure fine.

Shedding Tiers: Stop Thinking in Terms of Layers

Thinking in terms of layers or tiers really isn't much help to you. Stop doing it: The single responsibility principle and design patterns are all you really need.

Service Pack 2 for SQL Server 2012 Released

Also coming are reporting tools and other features.

Xamarin Support Added to Azure Mobile Services Offline

The upgrade is made possible by using SQLitePCL.

Capturing Results from Stored Procedures with Entity Framework 6

Entity Framework 6 gives you a variety of ways to call stored procedures that return data and capture the results those procedures return. Here's a look at all of them.

Two Big Data Companies Form Partnership

Cloudera and MongoDB also announce the MongoDB Connector for Hadoop.

Calling Stored Procedures from Entity Framework

Even in a Code First environment, you can call a stored procedure from a DbContext object. But it's a lot easier if you use the visual designer.

Microsoft Azure SQL Database Gets New Service Tiers

Microsoft yesterday announced its Database as a Service cloud offering is incorporating new Standard and Basic preview service tiers, along with new performance levels.

Making Complex Types Useful with Entity Framework 6 Custom Configurations

Complex Types let you reuse structures in your database design. But unless you've been very lucky around the names in your database, you probably couldn't use Complex Types -- until Entity Framework 6, that is.

The End of Days

It's a situation a coder should never have to face: perpetuating bad coding practices from years ago, or just fixing the darn thing!

New SQL, Hadoop Management Products Unveiled

Microsoft CEO Satya Nadella introduces Azure Intelligent Systems Service and Analytics Platform System.

SQLite Queries and Primary Keys

Learn about SQLite database engine internals so you can simplify your code and improve the performance of your applications.

Async Processing in EF6 and the Microsoft .NET Framework 4.5

The latest version of Entity Framework makes it easier to write asynchronous code. Here's how to write that code, and more important, where you'll actually find it useful.

Upcoming Events

.NET Insight

Sign up for our newsletter.

I agree to this site's Privacy Policy.