Απρίλιος 2012 - Δημοσιεύσεις
I have been looking into ASP.Net MVC 4.0 lately and I thought it would be a nice idea to create a small ASP.Net MVC 4.0 application and write a post about it. So this is going to be a rather long post that will show you with a hands-on example how to...(
read more)
In this post I would like to explain you with a hands-on example the importance of filegroups in Sql Server databases. This is not a post that experienced/advnanced DBAS/developers should read. The target audience is beginners (Level 100). Most beginners
Διαβάστε περισσότερα
In this rather short post I would like to provide you with a hands-on example on SPARSE columns. Sparse columns are very useful when we have tables and columns with many zero and NULL values.This feature was introduced in SQL Server 2008.We have a better
Διαβάστε περισσότερα
This is going to be a rather short post. I have been teaching the Official Microsoft SQL Server courses in my capacity as MCT and to be totally honest with you I enjoy it very much.One of my favorite subject is Backup & Restore. This is maybe the
Διαβάστε περισσότερα
In this post I would like to show you what happens when we issue ROLLBACK operations in nested transactions. Have a look in this post of mine to find out more information about transactions.A lot of people are confused on how a Rollbackstatement impacts
Διαβάστε περισσότερα
In this post I would like to show you a fairly simple example on how to use Log4Net logging service to log information in a text file.You can log information to a text file,a database table or Windows event viewer using the Log4Net logging assembly.This...(
read more)
In this post I would like to talk about DENY and GRANT security permissions. I will provide some examples that will demonstrate that DENY takes precedence over GRANT but there are some special cases. We use DENY and GRANT T-Sql commands to give permissions
Διαβάστε περισσότερα
I have been involved with an ASP.Net project recently and I have implemented it using the awesome DevExpress ASP.Net controls. In this post I will show you how to bind an XPODataSource control to an ASPxGridView control. If you want to implement this...(
read more)
In this post I would like to show you with a hands-on example why it is a bad idea to have duplicate indexes on SQL Server tables. Some people believe that having duplicate indexes will improve the performance. There will be no performance gain for SELECT
Διαβάστε περισσότερα
I have been involved in a ASP.Net project recently and I have implemented it using the awesome DevExpress ASP.Net controls. In this post I would like to show you how to use the client-side events that can make the user experience of your web application...(
read more)
I have been involved with a ASP.Net project recently and I have implemented it using the awesome DevExpress ASP.Net controls. Parts of the project involved binding data from custom objects, SqlDataSource & ObjectDataSource data sources to the ASPxGridView...(
read more)
I have been involved with a ASP.Net project recently and I have implemented using the awesome DevExpress ASP.Net controls. In this post I will show you how to implement Master-Detail functionality using the ASPxGridView control. If you want to implement...(
read more)
Recently I had to implement a web application for a client of mine using ASP.Net.I used the DevExpress ASP.Net controls and I would like to present you with some hands-on examples on how to use these ASP.Net controls. In this very first post I will explore...(
read more)
I have been teaching SQL Server recently in my capacity as MCT and to be totally honest with you I enjoy it very much.The topic that kept popping up all the time was indexes and how to use indexes to achieve high performance in SQL Server .Indexes is
Διαβάστε περισσότερα
I have been teaching in the past few weeks many people on how to use Entity Framework. I have decided to provide some of the samples I am using in my classes. First let’s try to define what EF is and why it is going to help us to create easily data-centric...(
read more)