SQL Server


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.

Splitting Tables in Entity Framework 6 to Improve Performance

There are some occasions when using Entity Framework can really hurt you: When you have tables with hundreds of columns or tables with large payloads. Here's how to get EF6 to do the right thing.

SQL Server Still on Top

Microsoft's venerable relational database management system remains on top with a regular pattern of updates and enhancements to ensure its continued strength in the market.

Managing Transactions in Entity Framework 6

Here's an article about managing transactions that you don't need to read because, with one exception, Entity Framework will do the right thing by default. But, in the .NET Framework 4 and later, you can do more (if you ever need to).

Visual Studio Online's Worst-Ever Week Continues

This time, it's an issue with new Git projects.

VS Offline? Mid-Month Outage, Explained

An explanation of the Visual Studio Online outage that occurred July 18 was simply Azure SQL Database slowness, but it was a bit more than that.

Security Tightened in SQL Server Data Tools Update

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

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.

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.

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.

Microsoft Releases SQL Server 2014 for General Availability

Memory support is expanded in the Standard edition, responding to feedback.

SQL Server Data Tools Now Supports SQL Server 2014

Fresh on the heels of SQL Server 2014 being released to manufacturing, the SQL Server Data Tools (SSDT) team yesterday announced support for the new version, along with numerous other enhancements.

SQLite Performance and Prepared Statements

SQLite is a tremendously useful database for C++ developers. In this follow-up, Kenny Kerr shows various techniques for improving performance even further.

Microsoft RTMs SQL Server 2014

Windows Azure HDInsight was also released, based on Hadoop 2.2.

43 Great Windows Azure Development Resources

Windows Azure is Microsoft's stack of cloud computing resources that lets you build Web apps and services based on the Windows, Microsoft .NET Framework, Visual Studio and SQL Server tools with which you're already familiar. Here's a collection of tools and information that will get you writing apps for Windows Azure today.

Satya Nadella's To-Do List: A 6-Point Plan

Microsoft needs fixing. Here's a list of the first things the new CEO should consider taking on.

Using SQLite with Modern C++

Incorporate the free database library with these easy, step-by-step directions.

Subscribe on YouTube