Replacing SELECT * with Column Names in SQL Server
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.
Category: Database
Database
Planning for SQL Server 2012 AlwaysOn Availability Groups
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 …
Frictionless Persistence in .NET with MongoDB
This video explores some of the concepts of document databases and stuff that’s general to NoSQL technologies. Then you will see how easy it is to get up to speed with MongoDB with examples on how to do that in C#. At the end, it discusses a couple of applications …
High Availability SQL Server
This video presents the High Availability and Disaster Recovery basics of SQL Server, including clustering, log shipping, replication, AlwaysOn Availability Groups and more.
How to Create a Database in Visual Studio in Less than 10 Minutes
This Visual Studio tutorial walks you through the exact steps required to design and build a fully working contacts database application from start to finish in less than 10 minutes. The lesson is in Visual Studio 2008 Professional using Visual C#.
NoSQL in .NET
Learn how industry leaders like Facebook, Twitter, and Reddit use NoSQL-based technologies like MapReduce, BigTable, HBase, SimpleDB and Windows Azure Table Storage to read and write massive amounts of semi-structured data in real-time in order to surface large amounts of content to many end users concurrently. This video also explains …