Service Broker is message queuing for SQL Server. It is used for sending emails and through Database Mails. You can read about SQL SERVER – Difference Between Database Mail and SQLMail here. Service Broker is feature which provides facility to SQL Server to send an asynchronous, transactional message.
SQLAuthority News – Updated My Personal Book Mark Pages
It has been long time since I have updated my personal book mark list. I have just refreshed it. You are all welcome to checkout my personally picked articles. SQLAuthority Best Articles SQLAuthority Favorite Articles I often visit above two links to read my selected articles. If you have any…
Read MoreSQLAuthority News – Ahmedabad SQL Server Usergroup Meeting
I will be attending Ahmedabad SQL Server Usergroup Meeting on July 19, 2008. I will be taking session about “SQL Server Best Practices“. I invite all of the SQL enthusiastic to stop by User Group Meeting and meet all the fellow developers, DBAs and members. Location : 401, TIME SQUARE,…
Read MoreSQL SERVER – Readers Contribution to Site – Simple Example of Cursor
eaders are very important to me. Without their active participation this site would not be the community helping web site. I encourage readers participation and request that you help other users with your knowledge. I recently come across very good communication between two of blog readers. I want to thank…
Read MoreSQL SERVER – Deferred Name Resolution
One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is incorrect table name in the SP it creates the SP fine but while executing it gives run time error. However, if there is any valid table from database is referenced in SP…
Read MoreSQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
Previously I wrote about SQL SERVER – 2008 – Introduction to SPARSE Columns. Let us understand the concept of SPARSE column in more detail. I suggest you read the first part before continuing reading this article. All SPARSE columns are stored as one XML column in database. Let us see…
Read More
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
It is very good to know our server and its feature which are available for configurations. SQL Server always has many features which can be enabled or disabled. One should at least know what are the options SQL Server provides. This blog post we will learn how to display or change global configuration settings.
SQL SERVER – 2008 – User Account – sa or sysadmin
Just a day ago, I noticed ‘sysadmin’ user in SQL Server 2008. While looking more into it, I found that it has same account rights as ‘sa’ account. ‘sysadmin’ is actually replacement for legacy ‘sa’ account. ‘sa’ still exist in SQL Server 2008, however, it will be deprecated in future versions of SQL Server. It is recommended to all the users who switch to SQL Server 2008 to start migrating to ‘sysadmin’ from ‘sa’.
SQL SERVER – 2005 – Two Important Security Update
If you are using SQL Server 2005, following two are very important security updates not to be missed. Security Update for SQL Server 2005 Service Pack 2 (KB948108) A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your…
Read MoreSQL SERVER – 2008 – Introduction to SPARSE Columns
I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup Management. I have received very good replies from many users and have requested to write more about it. Today we will look into another interesting concept of SPARSE column. The reason…
Read More