Browse by Tags

MSDN & Technet webcast for SQL Server 2008 and SQL Server Compact 3.5 versions
Published 3 September 8 4:4 PM | SSQA.net
TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300) Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change...
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?
Published 28 April 8 3:1 AM | SSQA.net
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...
Microsoft Empower Program - good deal for ISVs
Published 28 February 8 4:11 AM | SSQA.net
Microsoft has rolled out new program called - Empower Program that will enable the ISVs to receive software, support and additional resources designed to help you lower your development costs, test your software and speed your solution's time-to-market...
BI Virtual labs on MSDN - specific to data mining and top 10 classed in Tech-ed.
Published 26 February 8 4:45 AM | SSQA.net
As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual...
SQL Server 2008 February CTP, is availble to download now!
Published 20 February 8 5:37 AM | SSQA.net
Continuing from this SQL2008CTP blog post it seems there is a confusion on the SQL 2008 CTP downloads page The technet link 851664 refers that Evaluate Microsoft SQL Server 2008 today page was p ublished: November 12, 2007 and further after registering...
SQL Server: How do I identify the queries that are worth tuning?
Published 16 November 7 7:2 AM | SSQA.net
Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...
Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)
Published 15 November 7 7:16 AM | SSQA.net
It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read &...
How to find whether that service pack file is a 32 bit or 64 bit?
Published 1 November 7 6:44 AM | SSQA.net
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...
NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
Published 16 October 7 7:18 AM | SSQA.net
You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and...
SQL Server Virtual Labs - fully featured virtual environment for testing!
Published 5 October 7 11:4 AM | SSQA.net
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...
Featured downloads - from Technet center
Published 5 October 7 10:56 AM | SSQA.net
Have you seen the Technet Center flash recenlty, how many of you get/follow the Technet center flash? I get to update myself with other Microsoft technologies with that flash letter. The TechNet Flash is full of pointers to in-depth technical information...
SQL Server 2005 Books Online update - September 2007 on MSDN & Technet
Published 29 September 7 9:49 AM | SSQA.net
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...
The Next Release of Microsoft SQL Server: Overview
Published 4 June 7 12:30 PM | SSQA.net
Simulcast from Microsoft Tech·Ed 2007 in Orlando, FL. This session provides an overview of the next release of Microsoft SQL Server that is currently under development. We cover the core value proposition, major themes and scenarios, and some specific...
Is Katmai going to be named as SQL Server 2008?
Published 3 June 7 4:37 PM | SSQA.net
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...
Changes to SQL Server TechCenter
Published 30 May 7 8:45 AM | SSQA.net
You might have observed or not there is a change in the MSDN documentation User Interface (UI) and the way it is connected with regard to the feedback from the user. Well SQL Server TechCenter has been given a new look with an UI face-off in addition...