Browse by Tags
All Tags »
technet (RSS)
You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based
Read More...
As we blogged much on Books Online importance and recent changes to availablility of updated books online for SQL Server 2005 under BOL-Sep2007-MSDN-Technet the same update is available to download. Do not forget to update your local copies as it will
Read More...
Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by
Read More...
Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar
Read More...
Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema
Read More...
Virtual labs - in simple words its simple to use where a pre-installed environment is setup to try out /test SQL Server installation for your databses upgrade, that has full-featured labs. Not only this you have an option to download manual with a 90-minute
Read More...
Yikes, I can't see the DTS package that has been migrated from DTS to SSIS. This was the expression by one of the database user at our end. As you may be aware using Package Migration wizard you can migrate the DTS packages to SSIS within SQL Server 2005
Read More...
SQL Server version 2005 Books Online aka BOL has been updated by SQL Development Team in September 2007 and not available for download yet. As usual they are awaiting customer feedback from the BOL or via MSDN/Technet pages. Refer in their words: In the
Read More...
No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000
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...
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...
If you are a book reader to know on the new subject and that too looking for a SQL Server 2005 books then here is the place you can get upto 35% discount and also download free sample chapaters as a PDF format! DigDeep for more information on this offer,
Read More...
Using SSMS tool you can get information on tables, indexes and filegroup information for a database, how about using a TSQL statement: select 'table_name'=object_name(i.id) ,i.indid ,'index_name'=i.name ,i.groupid ,'filegroup'=f.name ,'file_name'=d.physical_name
Read More...
My TEMPDB is full what to do? This is a very common question in the forums and newsgroup, the first and foremost thing to check is to ensure TEMPDB drive has got enough free space to accomodate the calculations that are involved with the queries. This
Read More...
This was the question raised by a newbie DBA at my workplace! Endpoint in generic network terms they are the objects that represent a communication point between the server and client. In SQL Server as per the Authentication mode (Windows only & mixed)
Read More...