3 Things I Wish I Knew When I Started Using Entity Framework

• by Bert Wagner

• SQLServerCentral.com

• Entity Framework

Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.77 (64)

Log in or register to rate

2020-06-05 (first published: 2016-05-17)

16,999 reads

• Discuss

Using Python And NetworkX To Build A Twitter Follower Recommendation Engine

• by Bert Wagner

• Bert Wagner

Watch this week’s video on YouTube. This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on...

2020-01-14 (first published: 2020-01-07)

266 reads

SQL Server Converts Numbers to Asterisks

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. Pop quiz: What will be the output of the below three statements? As you might have guessed, the first conversion truncates the value,...

2019-12-17

87 reads

When a SQL UPDATE Statement DELETES Rows

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. At first I wasn’t going to write this post. I thought it would be too simple. Then I watched two experienced SQL developers...

2019-12-09 (first published: 2019-11-26)

1,725 reads

Azure SQL vs Azure Table Storage

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a...

2019-12-03

831 reads

First Time Speaking at PASS Summit

• by Bert Wagner

• Bert Wagner

This week, I filmed my experience as a first time speaker at PASS Summit in Seattle. No blog post, just a video to relive the experience.

2019-11-12

7 reads

SQL Server Stored Procedures vs Functions vs Views

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. SQL Server has several ways to store queries for later executions. This makes developers happy because it allows them to follow DRY principles: Don’t Repeat Yourself....

2019-11-04 (first published: 2019-10-22)

1,719 reads

SQL Server 2019 Feature Power Rankings

• by Bert Wagner

• Bert Wagner

Watch me comment on all of the features in this week’s video. With the release of SQL Server 2019 imminent, I thought it’d be fun to rank which features...

2019-10-29

525 reads

Are Stored Procedures Faster Than Stand-Alone Queries?

• by Bert Wagner

• Bert Wagner

Watch this week’s episode on YouTube. A few months ago I was presenting for a user group when someone asked the following question: Does a query embedded in a...

2019-10-24 (first published: 2019-10-15)

1,352 reads

Communicating Effectively at the Workplace

• by Bert Wagner

• Bert Wagner

This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...

2019-10-10 (first published: 2019-10-08)

406 reads