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.

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.

This video presents the High Availability and Disaster Recovery basics of SQL Server, including clustering, log shipping, replication, AlwaysOn Availability Groups and more.