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 of differences between SQL Server Native...
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 day such as documents, images and videos that needs...
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 of a hardware or software failure, also it could...
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 benefits, updates, news about their peers, and events...
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. There is no doubt that Ken Henderson's...
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. Before that you need to know few things about...
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 that SQL 2008 CTP6 is available to...
When you think about effective data management, archiving will also play important role to manage your data. In this regard Windows Magazine has included best practices for your data management. Data privacy and identity theft have a higher profile in the minds of consumers but data retention issues...
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 Availability per database level, as the feature behind...
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 reduce the storage requirements for your data....