When you create tables and insert data, what’s SQL Server doing behind the scenes? How do your rows become part of the files on disk?

No news isn’t good news: sometimes it’s terrifying. Just because your SQL Server slaves away silently doesn’t mean all is well. If you’re frustrated with your server’s performance and you’re not sure why things aren’t going faster, maybe there’s a hidden hazard holding you back.

A look at the past, present, and future of the Entity Framework brings to light some interesting contrasts in API design and customer empathy. In this session we’ll cover everything from product marketing, to the true spirit of POCOs, and even see some of the new features in the latest version of the Entity Framework.

There are many disadvantages to the usage of the SELECT * in a SQL Server query. This video explains how users can avoid using SELECT * but instead list the column names.

You’re faced with a bewildering array of options for AlwaysOn Availability Groups. Should all the databases be in one availability group? What service accounts and IP addresses will you need? How will failover work? I’ll get you started with a simple checklist of things to consider before deploying your first SQL Server 2012 instance.