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 SQL Server do not understand the concept of filegroups and why we need them.
Ι am going to start with a short introduction on data files,log files. (
read more)
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 more efficient way to manage empty space through SPARSE columns by enabling NULL data to consume no space at all.(
read more)
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 main DBA task.There is no way to explain adequately Backup & Restore without talking about Recovery models.Well some people in the class did not know how to find the recovery model for each database in the server. Another common question is how to find out the recovery models for all databases at once. (
read more)
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 a nested transaction. (
read more)
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 on a securable (e.g table) to a principal (a custom user we have created).Most developers are familiar with their use but there are some special cases I would like to point out. (
read more)
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 statements and there will be a performance degradation for INSERT,UPDATE,DELETE statements.
Have a look in this post if you want to learn about the possible dangers of over indexing your tables.
We will need a database to work with. I will use AdventureWorks2008R2. You can download it here . (read more)
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 a vast subject and well documented elsewhere on the web.In most cases the answer is “it depends” when someone asks me if a column in a particular table needs to be indexed. It is a very challenging and iterative process.(
read more)
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)
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)
In this post I would like to talk about how to import and export data using the bcp utility. I will also explain how the bcp utility works with tables that have constraints and triggers attached on them. No databases exist in isolation. We need to import data from other databases. We need to import data from text files,spreadsheets.We also need to export data to other systems or databases.One way to achieve is using the bcp utility. (
read more)
In this post I would like to talk about how to import data (from a text file) using the BULK INSERT statement.
If you want to find out more about BULK INSERT have a look here .
I will also explain how the BULK INSERT statement works with tables that have constraints and triggers attached on them. If you want to have a look in similar post in my blog regarding the bcp utility click here. (read more)
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.
In this post I will show you a step by step example on how to build a Windows Forms (Master – Details) application with C# and Entity Framework. Have a look in this post if you would like to see how to implement similar functionality with WPF. (
read more)
In this post I would like to show you how to activate Windows Activation Services or WAS for TCP based activation.What this means is that it is possible to host WCF Services in IIS and expose TCP endpoints. (
read more)
In this post I will show you how to host a WCF Service in your own applications.This is referred as self hosting, meaning the hosting of a WCF Service in a Console application or a Windows Forms application. This is the third post in a series of posts on the various options we have when it comes to hosting WCF Services. (
read more)
In this post I will show you how to host a WCF Service in a Windows service.This is the second post in a series of posts on the various options we have when it comes to hosting WCF Services.If you want to know how to host the WCF Service in IIS have a look in this post.
I will use a simple a WCF service that just completes some basic math tasks.The main focus in this post is not to implement a very complicated WCF Service. The main focus is demonstrating how to host the WCF Service in IIS.(
read more)
I am going to start a series of posts regarding the various options we have when we want to host a WCF Service. I am going to show you (in seperate posts) how to host WCF Services in IIS, in Window Services and self-host them.
In this post I will show you to host WCF Services in ASP.Net Web Applications in IIS.I will use a simple a WCF service that just completes some basic math tasks.The main focus in this post is not to implement a very complicated WCF Service. The main focus is demonstrating how to host the WCF Service in IIS.(
read more)
In this post I will provide you with hands-on examples on how to retrieve data from a WCF Data Service and bind the data to WPF data bindable controls that reside inside a WPF window.The client application in this case will be a WPF application again. (
read more)
In this post I will provide you with hands-on examples on how to retrieve data from a WCF service and bind the data to a WPF data bindable control that resides inside a WPF window. This is not going to be a post that will look into WCF Services in great detail. In the near future I will be writing posts on WCF.In a nutshell WCF provides a unified programming model for building service oriented applications. (
read more)
In this post I will not be investigating at what some people call the “Windows single technology applications” which basically means that we build WinForms apps for the windows operating systems using only Windows Forms controls or alternatively build a windows WPF application using only the built-in or 3rd party WPF controls. (
read more)