Browse by Tags
All Tags »
feature (RSS)
Few developers on a client's place raised a question that why they should really be concerned about deprecated features or commands in SQL Server? Until SQL Server 2000 version it used to be a workaround to get the old scripts executed in a way. It is
Read More...
It is over 1 year and first anniversary for SQL Server 2008 RTM, last year the RTM is released on August 06th 2008 re. http://sqlserver-qa.net/blogs/sql2008/archive/2008/08/06/4727.aspx post. HAPPY first anniversary.... and kudos to SQL Server Development
Read More...
I had been receiving a good feedback about the solution that has been posted previous about Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008 and inline link for SQL Server 2005 too. In fact
Read More...
I was looking for more information on Table-Valued Functions (TVF) in SQL Server in attempting to perform sophisticated text analysis using the built-in string functions using .NET. To the subject using regular expressions are not new to SQL. These regular
Read More...
On day-to-day basis a DBA might come across with the issues on the fragmentation on the database, it may not be possible to design the database that will be totally efficient and optimum to perform without any issues. Due to the fact of data inserts,
Read More...
Having a feature of Notification on the server happenings is add-on for every DBA, Notification Services for SQL server 2005 has got that advantage. Microsoft confirms that capitalizing on the Microsoft .NET Framework and SQL Server, Notification Services
Read More...