Home » Archives

Content in the Database Category

[17 May 2013 | No Comment | ]

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?

[24 Apr 2013 | No Comment | ]

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.

[5 Feb 2013 | No Comment | ]

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.

[29 Jan 2013 | No Comment | ]

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.

[1 Oct 2012 | No Comment | ]

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.