This is a post relevant to all the developers out there that use Web Forms as their main ASP.Net platform. In this post I would like to talk about ViewState and how we can move it and store it in a session on the server's memory. We know that the default...(
read more)
In my seminars I always show how to fetch data from an SQL Server database to some UI controls (usually a GridView control). I use the connected data access model,I use the disconnected data access model (datasets) and obviously I provide samples that...(
read more)
In this post I would like to show you again with a hands-on example how to create an Ajax enabled WCF Service and invoke it using the Ajax Script Manager web server control. This is going to be a very simple example and it is for people who are not familiar...(
read more)
In this post I would like to show you with a hands-on example how to invoke a WCF service from JQuery . I have already posted a few posts regarding JQuery and server communication.Have a look in this post and in this post . This is a similar post . In...(
read more)
This is the second post in the new HTML 5 post series. You can find the first post about HTML 5 input form elements and validation here . In this post I would like to show you how to use audio and video.We all know that audio and video are everywhere...(
read more)
I am going to start a new series of posts that focus on HTML 5. HTML 5 is something I wanted to learn and finally I have covered enough ground to feel confident. HTML 5 gives us things like Semantic tags, the possibility to add video and audio in our...(
read more)
In these series of posts I am going to have a look into the various factors that make our web applications slower and how we can rectify that. Ι have already blogged about caching in this blog and you can find these blog posts below Caching an ASP.Net...(
read more)
This another post that is focusing on how to use JQuery in ASP.Net applications. If you want to have a look at the other posts related to JQuery in my blog click here In this post I would like to show you how to perform client-side validations using the...(
read more)
This another post that is focusing on how to use JQuery in ASP.Net applications. If you want to have a look at the other posts related to JQuery in my blog click here In this post I would like to show you how to create a simple watermark effect using...(
read more)
This another post that is focusing on how to use JQuery in ASP.Net applications. If you want to have a look at the other posts related to JQuery in my blog click here We all know that there is always a limited space in our web page to show content.In...(
read more)
This another post that is focusing on how to use JQuery in ASP.Net applications. If you want to have a look at the other posts related to JQuery in my blog click here We all know that there is always a limited space in our web page to show content.In...(
read more)
In this post I would like to present in detail how we can consume WCF services from a Silverlight 4 application.I strongly suggest that you have a look in this post of mine where I talk about using web services – .asmx services and how we consme them in our Silverlight applications.I do advise against using .asmx web services in Silverlight application.WCF is strongly recommended by Microsoft and is the distributed technology that MS supports and will continue to support and enhance. (
read more)
In this post I would like to talk about Common Table Expressions or CTE . I know there are samples of how to use CTE in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.CTEs were introduced in SQL Server 2005. You can think of them as temporary views.They last only for the duration of the execution of the query.(
read more)
In this post I would like to present in detail how we can consume .asmx web services from a Silverlight 4 application. Silverlight supports and “recognises” web services in a similar way that ASP.Net applications can “talk” to web services. One might say that .asmx web services are considered by Microsoft legacy software. I will not disagree with that. Sometimes we do not have the luxury (time or budget) to create the services from scratch. It is very difficult to convince your boss or client to create a WCF service that does something when the functionality already exists in a web service (.asmx). So if now, I have the chance to write a whole Silverlight application from scratch I would not use .asmx web services, I would use WCF. But as I said before we have to use and maintain legacy code. (
read more)
In this post I would like to talk about the large value data types and how we can use them to store large amounts of data. We can store up to 2^31 bytes of character, binary, and Unicode data. I know there are samples of how to use large value data types in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples. (
read more)
In this post I would like to talk about the new system data type HierarchyID which was introduced in SQL Server 2008. I know there are samples of how to use HierarchyID in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.It is used for storing hierarchical data. (
read more)
In this post I would like to talk about exceptions in SQL Server. I know there are samples of how to handle exception in SQL Server in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.
Well, let me make a general statement. All humans make mistakes.That includes application developers,database developers e.t.c. (
read more)
In this post I would like to look into transactions in SQL Server. A transaction is a group of tasks that perform as a single unit of work.In database terms all parts of the transaction must be saved in the database or must be abandoned.It is a great feature in the relational world since through transactions we make sure the database is never in an inconsistent state. (
read more)
In this post I would like to talk about a new feature in SQL Server 2008, Resource Governor and what this new feature offers us in terms of performance and good use of resources.
I know there are samples of how to use Resource Governor in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples. (
read more)
In this post I would like to look into Transparent Data Encryption (TDE) works in SQL Server 2008.I would like to stress that this is an SQL Server 2008/R2 Entreprise/Developer edition feature only.
I know there are samples of how to use Transparent Data Encryption in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.
read more
In this post I would like to talk about Security in SQL Server. This is a very big topic and you should embrace yourselves for a very long post.
I know there are samples of how to use secure data in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.
Many people have found useful my style of posting. They feel they can follow the steps and master the technology/topic.
At the beginning I will give a short introduction about the various security threats that our systems face and then look into aspects of Security in SQL Server .Then I will provide many examples on how to secure data in SQL Server. (
read more)
In this post I would like to look into Views in SQL Server.
As always I will demonstrate all the various concepts with hands-on examples.
I know that all these concepts are well documented elsewhere. I will try to look into views with step by step instructions and many screenshots.
Many people have found useful my style of posting. They feel they can follow the steps and master the technology.(
Read more)
In this post I would like to show a few examples of built in T-SQL functions and global functions. I teach T-SQL to people from all walks of life and many of them have asked me to write a simple post with examples of the most commonly used T-SQL functions and global functions.(
Read more)
In this post I would like to show a few examples of how to use triggers in SQL Server. I would like to talk about the uses of triggers, the type of triggers and some misconceptions about the triggers.
I know there are samples of how to use triggers in BOL,MSDN and elsewhere but I thought that it would be a good idea to give it a try with hands-on examples.(
Read more)
In this post I would like to talk about data compression/backup compression features available to us in SQL Server 2008 and R2 editions.
I will talk about Data Compression and Backup Compression.
Data Compression is only available in Enterprise (SQL Server 2008 & SQL Server 2008 R2) edition or higher, not in the Standard edition for SQL Server 2008/ R2.(
read more)