How to create an autonomous transaction in SQL Server 2008
December 19th, 2011
Archive
Author Archive
SQL Server – Database Schemas
December 17th, 2011
Ever since SQL Server 2005 was released, each object in a database has belonged to a database schema. SQL Server 2008 has continued with database schemas, and an explanation follows. Read more…
SQL Server – Server Roles
December 17th, 2011
When creating a new user login in SQL Server, you get the option of assigning the login one or more server roles.
SQL Server – Stored Procedures
December 16th, 2011
Stored procedures are a powerful part of SQL Server. They can assist programmers and administrators greatly in working with the database configuration and its data.
SQL Server – Views
December 16th, 2011
In SQL Server, a view is a pre-written query that is stored on the database. A view consists of a SELECT statement, and when you run the view, you see the results of it like you would when opening a table. Some people like to think of a view as a virtual table. This is because a view can pull together data from multiple tables, as well as aggregate data, and present it as though it is a single table. Read more…
SQL Server – SQL Scripts
December 16th, 2011
In the previous lesson, we added data to our database table using the “Edit Top 200 Rows” option. In this lesson, we will look at how to write SQL scripts to update and run queries against our database. Read more…
SQL Server – Adding Data
December 16th, 2011
In the previous lesson, we created a new table in our database. We now have a database table, columns and all, but with no data. Read more…
SQL Server – Create a Table
December 16th, 2011
This lesson demonstrates how to create a table in a SQL Server database using SQL Server Management Studio (SSMS). Read more…
SQL Server – Create a Database
December 16th, 2011
One of the first things we should look at with SQL Server/Management Studio is how to create a database. After all, most of the tasks you perform with SQL Server will evolve around one or more databases. Read more…
C# 5.0 vNext – New Asynchronous Pattern
December 16th, 2011
Introduction
Hi! As of a recent buzz around the community, after the introduction of the C# vNext in the world of .NET languages, (more precisely on C# and VB.NET) its time to let you through and understand how the features are working in current scenario. Well, it is true a large mass of people is writing about it but believe me, I didn’t saw any which gives you the full example under one shot. Hence, I thought I might give it a try. In this post I will try to cover most of the bits related with Async programming model and also to give you a chance to understand the concept and give feedback on the same.
Recent Videos
Recent Comments