SQLAuthority News – Thank You to Blog Readers
Thank You very much for reading SQLAuthority.com for entire 2007 year. Wish you the BEST for year 2008. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Remove Duplicate Characters From a String
Follow up of my previous article of Remove Duplicate Chars From String here is another great article written by Madhivanan where similar solution is suggested with alternate method of Number table approach. Check out Remove duplicate characters from a string Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Change Password of SA Login Using Management Studio
Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties. Change SA password, and confirm it. Click OK. Make sure to restart the SQL Server and all its services and test new password by log…
Read MoreSQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed
You might have listened and read either of following sentence many many times. “DELETE can be rolled back and TRUNCATE can not be rolled back”. OR “DELETE can be rolled back as well as TRUNCATE can be rolled back”. As soon as above sentence is completed, someone will object it…
Read MoreSQL SERVER – Mirrored Backup Introduction and Explanation
SQL Server 2005 Enterprise Edition and Development Edition supports mirrored backup. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations. T-SQL code to take…
Read MoreSQL SERVER – Delete Duplicate Records – Count Duplicate Records Links
I have wrote following two articles for Duplicate Rows Management in SQL Server. SQL SERVER – Count Duplicate Records – Rows SQL SERVER – Delete Duplicate Records – Rows Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Object Oriented Database Management Systems
I have received few emails and comments about why I do not write about Object Oriented Database Management Systems (OODBMS). The reason for that is that I am big follower of Relational Database Management Systems (RDBMS) and that particularly of Microsoft SQL Server. If you are interested in reading about…
Read More