June 2007 - Posts
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...
In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under
Read More...
Here is the script I have used to list the information regarding database objects such as tables, indexes and file groups along with their file names : ( extracted from Technet ) select 'table_name'=object_name(i.id) ,i.indid ,'index_name'=i.name ,i.groupid
Read More...
I have had an interesting discussion in SSP World about how to grant access & privileges to handle SSIS packages in a high availability and Disaster Recovery scenario. As you may be aware that privilege involves having access to Distributed COM components
Read More...
As you may be aware SQL Server installation (70 & 2000) will automatically install the sample databases pubs and northwind, if you aren't using them or not a training institute then simply drop them. Whereas this behaviour is changed in SQL Server
Read More...
Tool: SQL Server Tables and Exchange Web Services sample demonstrates a powerful integration of Exchange Server 2007 and SQL Server 2005 features. This integration enables you to provide data from both Microsoft Exchange and SQL Server to client applications
Read More...
Useful information on data storage format using available data-types in SQL Server 2005 SP2: The Vardecimal storage format became available starting with Microsoft SQL Server 2005 Service Pack 2 (SP2) in the Enterprise Edition. This storage format can
Read More...
You may be aware that the native encryption is introduced in SQL Server 2005 by making use of the algorithm involves a component known as the encryption key (a sequence of characters). Using this method the process can be reversed by applying an appropriate
Read More...
Further details and resolution for this problem can be found from this FAQ entry.
Read More...
I always see many posts in the forums asking about transaction log backups and their importance. For the point in time recovery they are must in order to provide the data upto date or atleast that are committed. Yet I have seen many articles out there
Read More...
You might get this doubt "How do I move the default log files placed in: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG to a different location?" This may not be required all the times but say on the partition where these log files are stored
Read More...
I have been asked about Database Administrator roles and responsibilities many times and also seen in forums/newsgroups. In a nutshell DBA is responsible for all sorts of database within the organisation. This might vary for the management of Enterprise
Read More...
On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located
Read More...
I came across interesting post in SSP looking for a way of automating the Database Tuning Advisor tool of SQL Server 2005 with the help of SQLServer Agent. As the originator looking to schedule it on a regular basis to scan a trace (Profiler) file and
Read More...
I have been pestered by the Developers asking about feature of Page Numbering in Reporting Services. So far there is not direct way to accomplish this, because reports are not physically paginated until you use print preview (or export to a physical page
Read More...
When using SNAPSHOT backups in SQL Server there are few things you need to consider, that included monitoring the disk space usage where the database backups & snapshot files are stored. BOL confirms about SNAPSHOT backups as: The underlying backup
Read More...
There is no easy or best way, but few options are available such as DMO or SMO or even using Enterprise Manager for SQL 2000 or SS Management Studio for SQL 2005. Look for DBPublish wizard tool in this case that will help quite a bit and a lso you can
Read More...
One of the IT support team member asked me the question " Is there a way to have SQL Server 2005 send some sort of email notification when it starts up? " The solution is straight forward and yes you can have such alerts or notifications based upon the
Read More...
Yet another update to SQL Server 2005 Books Online, though it states May 2007 update that was released on June 06th 2007! During February 2007 with the release of Service pack 2 Microsoft has updated the BOL content to reflect the changes with SP2. For
Read More...
Already I have been getting questions asking about what will be support for SQL 2000 version as the SQL 2008 is in CTP phase at the moment which is expected to release during next year. As it look at the moment the support (official) ends by April 2008
Read More...
Microsoft VHD Test Drive Program provides customers with an enhanced server-based software evaluation experience that’s faster, better supported and more flexible. You can now access the entire catalogue of pre-configured Microsoft and partner products
Read More...
Recently SQL Server support team had changed the process of releasing support hotfixes for the issues that are specific to a customer base. This KBA revises the incremental servicing model that is deployed for all the support fixes. We have moved away
Read More...
I believe day by day the support options are changing on Vista and with recent evolution of Windows Server 2008, Microsoft has been investing and preparing a lot of trustworthy secured computing methods in all their products. So whats the catch on the
Read More...
Well so far the tradition from the Microsoft is to keep up the codename's exciting and name RTM with real-sense like Windows 2000 or SQL Server 2000 so and so forth. June 04th 2007 is going to be big as they are big surprises on way in Tech-ed2007 conference
Read More...