Just two days ago, I wrote a small note about SQL SERVER – Introduction to Service Broker.
SQL SERVER – Introduction to Service Broker
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.
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 – Find Space Used For Any Particular Table
We often run out of the space in our drive and that is the number 1 cause of SQL Server engine stop running on various machines. Quite often we wonder how much space if any of the objects takes in the database. It is very simple to find out the space used by any table in the database.
SQLAuthority News – White Paper: SQL Server 2008 Compared to Oracle Database 11g
Note: Download White Paper by Microsoft
Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.
SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server
I have previous written article about SQL SERVER Database Coding Standards and Guidelines Complete List Download. I just received question from one of the blog reader is there any way we can just prevent violation of company policy. Well Policy Management can come into handy in this scenario.