Today, I am very happy because my first article (SQL Server Encryption) was published in SQL Server Pro. In this article, after providing an overview of the SQL Server encryption model, I described the encryption options available in SQL Server and how you can use them to… Read more

Virtualization is a hot trend in the computing world, offering businesses substantial cost and performance benefits that include server consolidation, reducing power consumption and the effortless creation of virtual development and test environments. As a result of this trend, many organizations are interested in virtualizing SQL Server, and for a… Read more

Checkout the fourth part of my XML support and SQL Server article series here.

In this part, I talked about XML data type (typed and untyped) and its limitations. I also demonstrated how you can create XML variables and XML columns, and compare between typed and untyped XML.

This… Read more

This is the third part of the three part article series on partitioning relational data. 

In the first part of this three-part article series on partitioning relation data, I started the article by giving an introduction to partition relational data along with the reasons why you might want to partition… Read more

Checkout the third part of my XML support and SQL Server article series here.

In this part, I talked about the fundamental problems that we face when integrating XML and SQL Server. Then I talked about the storage options that are available in SQL Server to store XML data.… Read more

Today, I received an email from the development team complaining why they have not received any of the SQL Agent job notification emails today. Upon checking the SQL Agent error log, I see the following error message:

[264] An attempt was made to send an email when no email session… Read more

This is the second part of the three part article series on partitioning relational data. 

In the first part of this three-part article series on partitioning relation data, I gave an introduction to partition relational data along with the reasons why someone might want to partition relational data. Then I… Read more