Browse by Tags
All Tags »
features (RSS)
Have you tested or downloaded the SQL Server 2008 Evaluation edition to know about new features? Say if you need to determine which edition of SQL Server 2008 is suitable it is best to download Enterprise Evaluation Edition to test the application, based
Read More...
How many tools (new and enhanced) are available within SQL Server 2008 when you have a need to monitor the performance of queries that are executing/generated? The initial ones you remember is PROFILER and PERFMON (SYSMON) tools, even further few will
Read More...
Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease : . ..announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence
Read More...
When it comes to the data encryption within SQL Server 2008 you would think about Transparent data encryption (TDE) which is a new encryption feature. It sounds good that this is a high level security feature you can deploy to secure the data, and a catch
Read More...
SQL Native client or MDAC - which is best one to use? This was the question I was asked during my presence at DAT booth at the Tech-Ed ITPRO conference in Orlando. The sensible answer will be 'it depends'. Practically I have seen that there are a number
Read More...
Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every
Read More...
Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because
Read More...
You may be aware that MVP s have the advantage of getting to know about the product information before it is let to the user community, that is the main advantage (I feel) to make the most of MVP award experience, Microsoft keeps MVPs informed of award
Read More...
Have you looked at the Activity Monitor screen within the Managment Studio? I feel this is somewhat surprise features included from February CTP (or was it there before?). This is more useful to the DBAs to have a look at resource activity and locking/blocking.
Read More...
What kind of security features you adopt to protect your data? Login security, permissions and unauthorised access to your data, there is more you can do with SQL Server 2008 new feature called TDE - Transperent Data Encryption that is provided automatically.
Read More...
It has been a 'very busy' month sofar, in particular to Microsoft world and sub-domains of Windows Server, Virtual Server & SQL Server and you know why from here. Not a 'real' launch for SQL Server folks out there, but a concession to their grief
Read More...
Database Mirroring - new feature from SQL Server 2005 within High Availability ranch, a software based solution for database availability. Very important for the DBAs to keep up the database recovery model to FULL at all the times to achieve the High
Read More...
Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and
Read More...
Since the release of SQL Server 2008 CTP most of the blogs are filled with 'whats new' feature within this release or going to create a highlight as compared to SQL 2005. The best of all those blogs I would recommend (thanks to) Bob Beauchemin in SQLSkills
Read More...
Here is the link to attend a free e-learning on SQL Server 2008 eLearning78337 link. Title: Clinic 7045: What's New in SQL Server 2008 Course Type: Self-paced Course (at your ease) Available Offline: Yes Estimated Time of Completion: 2 Hours Language:
Read More...