Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

Archives: February 2013

SQL Server Encryption

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

0 comments, 517 reads

Posted in Basit's SQL Server Tips on 23 February 2013

The pros and cons of virtualizing SQL Server environments

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

0 comments, 841 reads

Posted in Basit's SQL Server Tips on 23 February 2013

XML Support and SQL Server (Part 4)

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

0 comments, 400 reads

Posted in Basit's SQL Server Tips on 23 February 2013

Partitioning Relational Data – (Part – 3)

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

0 comments, 302 reads

Posted in Basit's SQL Server Tips on 23 February 2013

XML Support and SQL Server (Part 3)

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

0 comments, 340 reads

Posted in Basit's SQL Server Tips on 11 February 2013

SQL Agent Alert System Error: [264] An attempt was made to send an email when no email session has been established

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

10 comments, 2,709 reads

Posted in Basit's SQL Server Tips on 11 February 2013

Partitioning Relational Data – (Part – 2)

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

0 comments, 379 reads

Posted in Basit's SQL Server Tips on 5 February 2013