SQL Server and SDS


Leverage Joins in Entity Framework To Get Just the Data You Want

Every once in a while you'll need to use the LINQ Join to get the data you want.

Logistic Regression Using R

I predict you'll find this logistic regression example with R to be helpful for gleaning useful information from common binary classification problems.

Speed Up Skip and Take in Entity Framework with Lambda Expressions

If you're using Skip and Take in LINQ to page through your data, a tweak to your syntax can cut your response time by as much as 10 percent as you page through your data.

Azure Data Lakes Tools for Visual Studio Code Now in Preview

The ability to embrace U-SQL jobs via authoring, scripting, extensibility via the VSCode environment and using C# is the key to this tooling preview.

Best Practices for Lazy Loading in Entity Framework

Sometimes you want child objects retrieved with the parent object, and sometimes you don't. What you NEVER want is to retrieve child objects accidentally. Here's Peter's advice on how to get the best performance when loading child objects.

SQL Server SP1 Gets Connected

One highlight of this roll-up release is the addition of row-level security and dynamic data masking, which were only available in the Enterprise version, are now in Standard, Express, and other versions.

What Makes SQL Server 2016 a Game-Changer

Polybase, Query Store, dynamic data masking, row-level security, and temporal data JSON support -- just some of the new features that veteran SQL Server Live! presenter Leonard Lobel covers in this exclusive Q&A with Lafe Low.

Defining Columns, Primary, and Composite Keys in Entity Framework

There are two attributes you can put on your entity class properties: one is a convenience, the other is essential, and both are required when the primary key for a table consists of two columns.

ASP.NET Core, .NET Core, EF Core 1.1 Updates In Preview

The first preview of the next incremental update to ASP.NET Core comes with a slew of new middleware components for speeding up app performance, while updates to .NET Core and Entity Framework Core come with mainly support additions.

Best Practices for Loosely Coupled Classes

In an object-oriented world you create flexible applications by combining objects. You'll want to keep those objects loosely coupled, though, so that a change in one class doesn't force you to rewrite every class. Here's how to keep them loosely coupled.

Results Are in -- the Sign Test Using R

The R language can be used to perform a sign test, which is handy for comparing "before and after" data.

Microsoft Claims Fastest Network in the Cloud

Microsoft CEO Satya Nadella demonstrated some of the AI supercomputing capabilities in its Azure public cloud that make it now among the fastest cloud services available. The secret sauce is the use of field-programmable gate arrays.

How Helper Variables Can Simplify Debugging

If the data you work with is complex and hard to understand, it's easy to get stuck on them when debugging. Add helper variables to make data much simpler to use and comprehend.

How I Created a RavenDB Python Client

You might be surprised how easy it was to port this NoSQL database for .NET to the Python language.

Do You Know the Answers to These Hanselman Questions?

Back when he had a job, Peter used to hire developers. When he did, there were three questions he got from Scott Hanselman's blog, way back at the beginning of the .NET Framework that he's still asking today.

Subscribe on YouTube