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 MoreSQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations
Sometimes things just go very convenient and we wish that how come it was not available in earlier versions. Let us see two features here. If it was SQL Server earlier versions we might have to write more lines to achieve what we can achieve in lesser lines. Following small…
Read More
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 – Thank You to Awarding Author SQL MVP
I received award from Microsoft for SQL Server Most Valuable Professional a week ago. I have received many many congratulations messages from many readers for getting this award. I thank all of you for sending me messages and your wishes. Honestly, I think this is all of yours award and…
Read MoreSQL SERVER – 2008 – Introduction to Row Compression
In my previous article SQL SERVER – 2008 – Introduction to New Feature of Backup Compression I wrote about Row Compression and I have received many request to write in detail about Row Compression. I like when I get request about any subject to write about from my readers. Row…
Read More