Home » Archives

Content tagged with: sql server

[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.

[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.

[7 Jun 2012 | No Comment | ]

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